Switching rows and columns in SQL

Posted on Simple Talk See other posts from Simple Talk
Published on 04 February 2010 Indexed on 2010/03/16 17:01 UTC
Read the original article Hit count: 161

Filed under:
When they use SQL Server, one the commoner questions that Ms Access programmers ask is 'Where's the TRANSFORM/PIVOT command? So how do you swap colums and rows in an aggregate table? Do you really need to use a CLR routine for this?

© Simple Talk or respective owner

Related posts about T-SQL Programming