>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.