Post reply

Select Query

  • April 20, 2011 at 4:36 am

    #238102

    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.

  • April 20, 2011 at 5:39 am

    #1313857

    Join to a numbers/tally table:

    http://www.sqlservercentral.com/articles/T-SQL/62867/

  • April 20, 2011 at 7:37 am

    #1313938

    Research PIVOT.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • April 20, 2011 at 7:42 am

    #1313945

    Use UNPIVOT to get all data in one coumn

Viewing 4 posts - 1 through 3 (of 3 total)

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