Select Statement in Update Clause

• avesh.agarwal

  SSC Journeyman

  Points: 96

  More actions

  August 5, 2008 at 5:29 am

  #382128

  Hi i want to use select statement in update Clause means in a single update statement all the rows has been updated on a particular condition please provide me help thanks in advance!!

• Kent Waldrop

  Hall of Fame

  Points: 3064

  More actions

  August 5, 2008 at 6:29 am

  #853132

  I am not sure if I understand your question, but you might want to give a look at the OUTPUT clause for the UPDATE statement in books online.

• Lowell

  SSC Guru

  Points: 323518

  More actions

  August 5, 2008 at 6:38 am

  #853137

  Maybe you mean something like this?

  this updates a table, and uses a SELECT to pull in relevant data from a select statement?

  [font="Courier New"]

  UPDATE SomeTable

  SET SomeTable.BudgetAmount = X.BudgetAmount

  FROM

  (

  SELECT ID,SUM(AMT) AS BudgetAmt FROM OtherTable WHERE SomeField = 1 GROUP BY ID

  ) X --aliased this select statement as X

  WHERE SomeTable.Id = X.ID

  [/font]

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!