1

SQL Management Studio Query, Horizontal to Vertical array?

view story
linux-howto

http://serverfault.com – Basics:I'm running SQL Server 2008 R2 Standard. I need to create a query that has data from multiple columns (Columns 1-6 with coresponding Date started and Date Completed data) displayed vertically, but also has the column name the preeceeding column to identify it...along with other data (Record number, status). Record Number, Status, Column Name, Date Started, DateCompleted 1, Open, Column 1, 1/1/2012, 2/1/2012, 2, Hold, Column 2, 1/3/2012, 3/1/2012, 1, Open, Column 3, 2/5/2012, 4/6/2012, 3, Closed, Column 4, 5/10/2012, 7/25/2012, 2, Hold, Column 5, 3/9/2012, 4/1/2012, 1, open, Column 6, (HowTos)