how do you do a rollup without using the rollup

• matt101

  Default port

  Points: 1456

  More actions

  October 2, 2002 at 9:53 am

  #79136

  I just like to make things complicated for myself. Actually my select has 15 fields and I need to calculate sub totals and grand totals and was wondering if there was a way to do it manually or is it better just to do it in the code?

  Matt

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  October 2, 2002 at 10:35 am

  #437666

  Ok, I know this is not what you where asking but here is an example the "USEs" rollup, sorry.

  http://www.geocities.com/sqlserverexamples/#sum

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP