Pivot table for Horiz display with nothing to agg

• craigeguyer

  Newbie

  Points: 5

  More actions

  May 30, 2002 at 11:20 am

  #78767

  Wondering how to create a pivot table for display..when there is nothing really to aggregate in the case statement...so data of

  ID field value

  1 05 abc

  1 06 xyz

  1 07 a123

  to display as

  ID 05 06 07

  1 abc xyz a123

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 30, 2002 at 11:48 am

  #430048

  This should help. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=204

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)