I've got a final table I've created which I believe I need to use PIVOT on in order to get my desired results, but not sure how to. Any help would be GREATLY appreciated as I'm new to most of this. (Using SQL Server 2005) A representation of MyTable: Person , date , C1 , C2 Person1 , 20090101 , .89 , .39 Person1 , 20090201 , .99 , .85 Person1 , 20090301 , .78 , .98 etc.. Person2 , 20090101 , .80 , .81 Person2 , 20090201 , .75 , .79 etc.. A representation of the results I'd like to get (Each Person's percentages by month(date)): Person , JanC1 , JanC2 , FebC1 , FebC2 , MarC1 , MarC2 Person1 , .89 , .39 , .99 , .85 , .78 , .98 , etc... Person2 , .80 , .81 , .75 , .79 , etc... ...I initially tried to use Selects with Cases, but without setting Person to a specific one, I don't know how to generate results
(comments are locked)

I'm not sure if you can PIVOT on a date column, but this will work:
(comments are locked)

It works very well  Thanks for your help & quick response Andomar! ...It looks like I made this much harder than it needed to be:)
(comments are locked)
