tyekhan
Starting Member
29 Posts |
Posted - 04/20/2013 : 10:01:22
|
I need help on the following I need 10 column in to one query output,
So the single query are as below,
SELECT CompanyName, COUNT(CompanyName) AS TotalRecords FROM cmp_Everything AS ee WHERE (Cmonth = N'March2013') GROUP BY CompanyName
select ee.CompanyName, SUM(CASE Last WHEN 'EE002' THEN SuccessValue * 1 WHEN 'EE003' THEN SuccessValue * 1 WHEN 'EE004' THEN SuccessValue * 1 ELSE SuccessValue END) AS TotalSales FROM cmp_Everything AS ee INNER JOIN History AS h ON ee.DID = h.DID INNER JOIN EECRCSuccessValues ON h.CRC = EECRCSuccessValues.CRC WHERE (ee.Cmonth = N'March2013') GROUP BY ee.CompanyName
SELECT ee.CompanyName, COUNT(CRC.Contact) AS TotalD FROM cmp_Everything AS ee INNER JOIN History AS h ON ee.DID = h.DID INNER JOIN CRC ON h.CRC = CRC.CRC WHERE (CRC.Contact = 1) AND (ee.Cmonth = N'March2013') GROUP BY ee.CompanyName
I Want to combining the above into one select query
|
|