How to transfer rows data to dynamic column

• Vijay Sinha

  Mr or Mrs. 500

  Points: 591

  More actions

  April 11, 2009 at 4:55 am

  #220111

  How to transfer rows data to dynamic column in sql server?

  Thanks in advance.

• Laerte Poltronieri Junior-367636

  Hall of Fame

  Points: 3314

  More actions

  April 11, 2009 at 6:06 am

  #976038

  I dont understand dynamic column...

  are want to say computed column ?

  or dynamic column in pivots ?

  If was a computed column just add de computed column and the value and will be "updated".

  If was in pivots, this link is a great article about this

  http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

  $hell your Experience !!![/url]

• Jeff Moden

  SSC Guru

  Points: 1004356

  More actions

  April 11, 2009 at 3:38 pm

  #976209

  A well formed crosstab can be almost twice as fast as a Pivot and a whole lot easier to read, to boot. Please see the following articles...

  http://www.sqlservercentral.com/articles/T-SQL/63681/ (Performance info near the end)

  http://www.sqlservercentral.com/articles/cross+tab/65048/

  --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)