I am using following pivot to get the result but getting error
Expand|Select|Wrap|Line Numbers
- SELECT StartDate,[headCount] AS headCount
- FROM
- (SELECT StartDate, headCount
- FROM SAR_HeadCount ) ps
- PIVOT
- (
- headCount
- for StartDate IN
- ([headCount])
- ) AS pvt
Expand|Select|Wrap|Line Numbers
- StartDate Headcount
- 08/01/2010 182
- 08/08/2010 176
- 08/15/2010 198
- 08/15/2010 192
Expand|Select|Wrap|Line Numbers
- 08/01/2010 08/08/2010 08/15/2010 08/22/2010
- 182 176 198 192