Display results VERTICALLY in Results window

• D Simmons

  SSC Journeyman

  Points: 75

  More actions

  September 27, 2007 at 2:27 pm

  #178159

  Comments posted to this topic are about the item Display results VERTICALLY in Results window

• rasha.adel82

  Grasshopper

  Points: 15

  More actions

  December 19, 2010 at 1:15 pm

  #1264455

  Hi ,

  I belive Pivot which is a new TSQL 2005 feature can do it easily

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  December 19, 2010 at 4:06 pm

  #1264460

  rasha.adel82 (12/19/2010)

  ---

  Hi ,

  I belive Pivot which is a new TSQL 2005 feature can do it easily

  Pivot is also quite a bit slower than a good ol' fashioned crosstab. Have a look, rasha...

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

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)