January 17, 2013 at 5:00 am
my question is how to display table two rows in two columns.
pls reply my topic
January 17, 2013 at 5:11 am
You can use PIVOT function to convert rows into columns. Bt please bear in mind that the reverse is not true.
January 17, 2013 at 8:36 am
Often times a cross tab will out perform the pivot function. Take a look at the links in my signature about pivots and cross tabs. Those articles will explain the process in great detail.
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/
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply