Sql查询问题 - MS-SQL Server / 应用实例

SQL code:
select * from (select top 200 LicensePlat,GPSDate,RowCnt from GPSVehicle v inner join GPSStatLocating s
on v.DeviceId = s.DeviceId) a pivot (max(RowCnt) for GPSDate in (20100315,20100330,20100331)) b


通过上面的查询语句，我想得到下面的结果，可是老是报20100315附近有语法错误

---

SQL code ([20100315],[20100330],[20100331])) b

---

引用

SQL code
select * from (select top 200 LicensePlat,GPSDate,RowCnt from GPSVehicle v inner join GPSStatLocating s
on v.DeviceId = s.DeviceId) a pivot (max(RowCnt) for GPSDate in (20100315,20100330,20……

不好意思，刚才一直搞到都忘了。谢谢啊