Pretty dense sql query

[darkgen]

Hopefully a very simple one:
SELECT monthyear, COUNT(*) AS callcount, SLAPass
FROM vw_RAA_RA
WHERE (TICKET_ID_ IS NOT NULL) AND (Actual_Date >= DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 11, 0))
GROUP BY DATEADD(month, DATEDIFF(month, 0, Actual_Date), 0), monthyear, SLAPass

The above query produces 3 columns as follows:

Monthyear,callcount,SLAPAss
Jan2012,10,No
Jan2012,8,Yes
...

However, what I want to do is crosstab, I suspect, the result as follows:

Monthyear,callcountFail,callcountPass
Jan2012,10,8
...
Any guidance most welcome, I'm even less than a total noob when it comes to sql so please be gentle.

Cheers, Paul.

 

[philldutton]

If i've understood correctly, you should be able to do something like:

SSELECT DATEADD(month, DATEDIFF(month, 0, Actual_Date), 0) AS MonthYear,
	SUM(CASE WHEN SLAPASS='No' THEN 1 ELSE 0 END) AS CallCountFail,
	SUM(CASE WHEN SLAPASS='Yes' THEN 1 ELSE 0 END) AS CallCountPass
FROM vw_RAA_RA
WHERE (TICKET_ID_ IS NOT NULL) AND (Actual_Date >= DATEADD(month, DATEDIFF(month, 0, GETDATE()) - 11, 0))
GROUP BY DATEADD(month, DATEDIFF(month, 0, Actual_Date), 0)

 

[darkgen]

Thank you. SUM was my friend. Wood for trees!