Home Forums SQL Server 2005 T-SQL (SS2K5) column into a row using select RE: column into a row using select

  • November 29, 2007 at 2:17 am

    #755284

    try the below querry

    select id, col1 from table

    union all

    select id, col2 as 'col1' from table

    order by col1