Update row from row in same table
Posted on 2007-10-16
SQL is not my strong point, but I am familar with it.
I am creating a stored procedure to get the following from a table
select columns where condition is met. - This works fine
What I need to do now is get the values from the select and update rows in the same table with the values where conditions are met.
Just not sure how to form this. I know how to do a basic update statement, but not how to pass in variables from select. Any help would be appreciated.