Got a Compute Question

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  September 13, 2005 at 5:19 pm

  #168729

  Got a question for you old timers,, oops; sorry, i mean more experienced sqler's

   

   When would be the proper implemation to use the ....compute ?

   

  FROM BOOKS ONLINE::

          USE pubs

  GO

  -- Row aggregates

  SELECT type, price, advance

  FROM titles

  WHERE type LIKE '%cook'

  ORDER BY type

  COMPUTE SUM(price), SUM(advance) BY type

  Thanks,

  Erik....

  Dam again!

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 15, 2005 at 7:25 am

  #590130

  If you need detail data and aggregated data at the same time, you can use COMPUTE.

  COMPUTE generates multiple record sets. Your client side app need to have the capability to handle this.

   

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  September 15, 2005 at 8:06 am

  #590147

  Thanks..

  Dam again!