Click here to monitor SSC

Paul Nielsen Paul Nielsen
Paul Nielsen is a hands-on database developer, Microsoft SQL Server MVP, and trainer specializing in data architecture and database development using Microsoft SQL Server technologies. Active in the SQL Server community, Paul is the and founder of Colorado PASSCamp. Paul presents around the world at conferences such as Microsoft Tech Ed (Dev), SSWUG Virtual Conference, SQL Teach (Canada), SQL Open World (Denmark), and devLINK (Nashville), and PASS Summit. Besides holding several certifications, Paul is an instructor with Learning Tree, served on the Microsoft Education Domain Objectives panel for SQL Server 2005, and was the Design-SME (subject matter expert) for the Microsoft Official Course, 2784: Tuning and Optimizing Queries using Microsoft SQL Server 2005. Paul has been developing data-centric solutions since 1982, and was the Enterprise Data Architect for Compassion International, a SQL Server instructor with Learning Tree, the technical editor for a database magazine, and a U. S. Navy Submariner (Data Systems Tech Petty Officer).
Switching rows and columns in SQL
by Paul Nielsen | 04 February 2010 |  9 comments |
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? Read more...
Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk