weekly and monthly rollups in 7.0

• brownguyr

  SSC Enthusiast

  Points: 137

  More actions

  July 7, 2003 at 11:01 am

  #83786

  I am trying to get weekly and monthly averages in sql 7.0, is there a operator similar to compute by from sql 2000 in 7.0 to do this?

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 9, 2003 at 3:34 am

  #464644

  I might be misunderstanding the question. COMPUTE BY is available in SQL 7.0. Can you post the SQL2000 query?

  
  Cheers,
  - Mark