A simple CrossTab procedure

• iecdba

  SSC-Addicted

  Points: 424

  More actions

  October 13, 2007 at 9:05 pm

  #179071

  Comments posted to this topic are about the item A simple CrossTab procedure

• Jeff Moden

  SSC Guru

  Points: 1004565

  More actions

  December 25, 2008 at 1:19 pm

  #917667

  Interesting concept... but it doesn't work correctly. I ran the code and the test code, as is... the results are not exactly a cross tab... look at the scores for each person in each column...

  [font="Courier New"]student course_SQL__grade course_VB___grade

  ---------- ----------------- -----------------

  ELI 79 79

  ELI 80 80

  SHMIL 69 69

  SHMIL 99 99

  (4 row(s) affected)

  [/font]

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