Update Procedure

• jimkiely

  Old Hand

  Points: 350

  More actions

  March 16, 2005 at 10:12 am

  #66071

  Situation, I need to sum up data in a table A and then update table B, with the data in table A.

  Normally I would Create a temp table and insert all the selected/sumed data (table A) into the temp table, then update table A from the temp table.

  Does anyone have a better way to do this?  Maybe an update statement with a subquery?

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 16, 2005 at 10:47 am

  #547322

  It will be VERY helpful if you post the DDL of the tables and Columns involved

  but here is a hint

  Update a set aggregateOnA = DSum.TheSum

  From TableA a

       join (

              Select ID, Sum(Q) TheSum

              from TableB

              Group by ID

            ) DSum

        on a.ID = DSum.ID

   

  
  * Noel