Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
SELECT A.CostID, CONVERT(DECIMAL(10,3), SUM(ISNULL(D.CHARGE,0))) AS CHARGE, COSTNAME, COSTNUMBER FROM wbCostCentre A LEFT JOIN wbCompany B ON A.CompID = B.CompID LEFT JOIN wbAssetTrack E ON E.CostID = A.CostID LEFT JOIN wbAssetHist G ON G.CostID = A.CostID LEFT JOIN wbMCD C ON C.AssID = E.AssID LEFT JOIN wbvoiceout D ON D.MobDevID = C.MobDevID AND INVNUMBER = '92007' AND D.COSTID = A.COSTID LEFT JOIN wbCostManager F ON F.CostID = A.CostID WHERE A.COMPID= 16 AND F.EMPID = 2102 OR A.COMPID= 16 AND INVNUMBER IS NULL AND F.EMPID = 2102 GROUP BY A.CostID,COSTNAME,COSTNUMBER ORDER BY A.CostID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Whats wrong in this query - Select * from tableA,tableA||11||58|
|Clone table from one server.database to another server.database||24||61|
|Can I skip a node in XML?||9||46|
|Change this SQL to get all nodes||3||56|
Join the community of 500,000 technology professionals and ask your questions.