compute sum withbreak

• newbieuser

  SSCrazy Eights

  Points: 9423

  More actions

  April 23, 2008 at 2:49 pm

  #184772

  Hi,

  Does anyone know whats the equivalent sqlserver syntax for the compute command?

  This is in oracle..

  SQL> break on title

  SQL> compute sum of amt on title

  SQL> select title,amt from shipping order by title;

  THanks.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  April 23, 2008 at 4:05 pm

  #806332

  GROUP BY .. WITH ROLLUP can usually get you there.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]