How to show header in left side

Question

my select query will return the result like this   id name 1 naresh 2 suresh 3 ramesh   but   i would like to reutn    id          1                             2                                  3  Name  naresh                 suresh                            ramesh   thanks in advance

Puneet Kankar · Accepted Answer

Many ways to do this given below one of them try this query. select   [1], [2], [3], [4]   from    (      select  Id,  Name       from  [TableName]   ) d   pivot   (      max ( Name )      for  Id  in  ([1], [2], [3], [4])   ) piv;

Salman Beg · Answer

Hi. You need to use unpivot for this. You can follow these links to implement the same, http://blog.devart.com/is-unpivot-the-best-way-for-converting-columns-into-rows.html   https://dzone.com/articles/pivoting-and-unpivoting-multiple-columns-in-ms-sql   https://stackoverflow.com/questions/5337380/converting-columns-into-rows-with-their-respective-data-in-sql-server   Thanks.