CrossTab Query

[TedMosby]

I am transferring a Access DB in SQL Server and trying to work a way of building a CrossTab Query.

I have this from Access below, how can I transfer into SQL Server?



TRANSFORM Sum(dbo_REP_NON_PATIENT_EVENT_PERF_MAN.ACTUAL_ATTENDEES) AS SumOfACTUAL_ATTENDEES
SELECT SueProfCarers2.SERVICE
FROM dbo_REP_NON_PATIENT_EVENT_PERF_MAN LEFT JOIN SueProfCarers2
ON dbo_REP_NON_PATIENT_EVENT_PERF_MAN.PROCA_REFNO = SueProfCarers2.PROCA_REFNO
WHERE (((dbo_REP_NON_PATIENT_EVENT_PERF_MAN.START_DTTM) Between #4/1/2008# And #9/30/2008 23:59:59#)
AND ((dbo_REP_NON_PATIENT_EVENT_PERF_MAN.MAIN_CODE)
In ("ANT","CHILD","DENT","GRPSS","HED","HPROM","PATNT","WELL")))
GROUP BY SueProfCarers2.SERVICE
PIVOT Mid(dbo_REP_NON_PATIENT_EVENT_PERF_MAN.START_DTTM,4,2);