Re: syntax help - updating multiple rows

On Jan 29, 12:44 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:

> Not sure what you mean by "my desired column values";
> do you supply these, or are these from the table?

thanks, frank. put simpler what i mean is, "i want to update target rows w/ values from source rows". so i want to run a query that returns a set of source rows. then, i want to update some target rows (that exist in this same table) w/ the values of the source rows.

id bet this is standard/simple, but i just dont know how. i found one solution:

1. get resultset of source rows; place into CURSOR
2. loop each row of source rows
3. run UPDATE statements onto target row, using loop-row's values.

...that could work. but i think theres probably a way to do it into a single statement.

see what i mean?

sm Received on Tue Jan 29 2008 - 13:12:50 CST