Nested SQL Query - % of Group Total

• Jeff Moden

  SSC Guru

  Points: 1004343

  More actions

  February 9, 2013 at 2:42 pm

  #1586256

  mjbkm (2/9/2013)

  ---

  Ha, you are correct. I just ended up keeping the previous as is and created all new. And entire switchboard of different results. However, this is awesome. I will pull it in and try it out too.

  Thank you!!

  You're welcome. Thanks for the feedback. I also added a couple of links above for more information on the "CrossTab" method I used.

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