ACCESS语句在sql server如何用啊

ACCESS语句在sql server怎么用啊！
TRANSFORM       Count(ccc.num)      
SELECT       ccc.name,address,       Count(ccc.num)       AS       合计      
FROM       ccc      
GROUP       BY       ccc.name,address      
PIVOT       ccc.class;

这里面好像   TRANSFORM，PIVOT，sql都不认，是不是有其他语句可以替代？
谢谢！


------解决方案--------------------
declare @sql varchar(8000)
set @sql = 'select name, sum(source) as 总分 '

select @sql = @sql + 'sum(case subject when ' '+subject+ ' '
then source else 0 end) as ' '+subject+ ' ', '
from (select distinct subject from test) as a

select @sql = left(@sql,len(@sql)-1) + ' from test group by name '

exec(@sql)