samhrishi
Grasshopper
Points: 16
More actions
April 20, 2011 at 4:39 am
#389327
Date Shift Reading col4 col5 col6 ..col85
01-MAR-08 1 879.880 .. .. .. 85
o/p
one Column
01-MAR-08
1
879.880
..
85.
I need to show data from 85 column into a single one. How can i do that.
Thanks
Jack Corbett
SSC Guru
Points: 184394
April 20, 2011 at 8:38 am
#1313987
Sound like you want to PIVOT. You can lookup the PIVOT function in BOL or you can look at the 2 articles linked in my signature line about CrossTabs & Pivots.
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply