Convert rows to columns

Question

Convert rows to columns

goodtomorrow01

Old Hand

Points: 352
More actions
November 27, 2012 at 8:10 pm

#285452

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!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61141 More actions · Answer 1

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

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

thava SSCrazy Points: 2275 More actions · Answer 2

seems this Cross Tab Procedure[/url] will help your to solve this issue

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

vivekkumar341 Say Hey Kid Points: 681 More actions · Answer 3

vivekkumar341

Say Hey Kid

Points: 681

November 27, 2012 at 9:39 pm

#1562920

Your Question is not clear.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

goodtomorrow01 (11/27/2012)
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!

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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

goodtomorrow01 Old Hand Points: 352 More actions · Answer 5

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.