请问SQL server 中pivot的详细用法及语法规则

请教SQL server 中pivot的详细用法及语法规则：
请教SQL server 中pivot的详细用法及语法规则：
 

请帮忙检查一下这段语句的语法问题呗。
create table test2(id int,name varchar(20),quarter char,profile1 int) 
insert into test2 values(1,'a',1,1000)
insert into test2 values(1,'a',2,2000)
insert into test2 values(1,'a',3,4000)
insert into test2 values(1,'a',4,5000)
insert into test2 values(2,'b',1,3000)
insert into test2 values(2,'b',2,3500)
insert into test2 values(2,'b',3,4200)
insert into test2 values(2,'b',4,5500)
select * from test2
select *id,name,
[1] as "一季度",
[2] as "二季度",
[3] as "三季度",
[4] as "四季度" 
from test2
pivot
(count([profile1])
for [quarter] in ([1],[2],[3],[4])
) pvt
总是提示count([profile1])这行，括号处有语法问题。。一直没弄明白。


[解决办法]
2005里是用sp_dbcmptlevel

SQL code

sp_dbcmptlevel <databasename>, 90