Convert rows to columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Convert rows to columns

Convert rows to columns

Rate Topic

Display Mode

Topic Options

Author

Message

goodtomorrow01

Posted Tuesday, November 27, 2012 8:10 PM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 45, Visits: 65

We have a following table:
[Day] [Time]
Mon 07:00
Tue 12:00
Mon 10:00
Mon 15:00
Tue 15:00
Tue 20:00
I want to make a query in sql 2005 to have the following result:
07:00 10:00 12:00 15:00 20:00
Mon Mon Tue Mon Tue
NULL NULL NULL Tue NULL

Please help me do it?
Thank you very much!

Post #1389487

Alan.B

Posted Tuesday, November 27, 2012 8:40 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:06 AM
Points: 223, Visits: 1,137

Edit: I misunderstood your question... What's with the NULLS?

-- AJB
xmlsqlninja.com

Post #1389488

thava

Posted Tuesday, November 27, 2012 9:38 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 10:22 PM
Points: 103, Visits: 161

seems this Cross Tab Procedure will help your to solve this issue

Post #1389500

vivekkumar341

Posted Tuesday, November 27, 2012 9:39 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 1:47 AM
Points: 196, Visits: 87

Your Question is not clear.

Post #1389501

Sean Lange

Posted Wednesday, November 28, 2012 8:32 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 8,620, Visits: 8,261

goodtomorrow01 (11/27/2012)

Nobody can help you because you didn't provide enough details for somebody to help. Please see the first link in my signature for best practices when posting a question.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1389837

goodtomorrow01

Posted Thursday, November 29, 2012 12:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:46 AM
Points: 45, Visits: 65

Thank you very much for interested in my question. However, I find out answer from here : http://social.msdn.microsoft.com/Forums/en/transactsql/thread/07dd8fb0-4c2c-4ed0-a6a6-4ca6a488f2d0
Again, thanks anyway and hope continue getting your help for next time.

Post #1390316

« Prev Topic | Next Topic »

Permissions