Home How to pivot or rotate columns in a table of strings in SQL
Reply: 0

How to pivot or rotate columns in a table of strings in SQL

user650
1#
user650 Published in June 19, 2018, 6:22 pm

First question here so I apologise if I messed something up. I was wondering how you would go about performing a pivot on a SQL table with two columns of strings like below:

    ID   Label                Text
   ----  ----------          ----------
   10    Lead Source          Internet
   10    Display              Washington
   10    Sale                 Brick
   10    Colour               Blue

Into This:

   id   Lead Source   Display     Sale    Colour
   --   -----------   -------     ----    ------
   10    Internet      Washington  Brick   Blue

Thanks!

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.314077 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO