Give me simple example for Pivot and is applicable for text data?

• ramya.praba

  SSC Veteran

  Points: 285

  More actions

  January 10, 2011 at 1:42 am

  #230153

  give me some example

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  January 10, 2011 at 2:07 am

  #1271279

  Hi..

  Please refer this link

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

  http://www.devx.com/dbzone/Article/28165/0/page/3

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  January 10, 2011 at 2:12 am

  #1271281

  PIVOT on character data

  http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-programming/71624/SQL-2005-PIVOT-on-character-data