>>OK. One other question - are you trying to produce this query for a report in Reporting Services? Or will the output be used by something other >than SSRS?
>
>>Reason I ask....SSRS has a very nice dynamic pivot capability (the SSRS matrix) where you don't need to specify the columns names.
>
>>By contrast, the regular SQL PIVOT (or even CASE statements to build columns) requires that you "spell out" the column names. If the >names of columns is dynamic and could change over time, you'd have to use dynamic SQL. Certainly not horrible, but it does add a level of >complexity.
>
>I don't have access to SSRS in that server, it must be run in standard procedure and return the resultant table.
OK, I'm typing out some code, give me a little bit of time.