I need to select a set of rows from a table, based on two columns
, give one of those columns a new value in the selected set, and then insert the selected set into the source table.
I can bring them down from the server, do the changes and then insert them one at a time, but I'm not crazy about that all those trips to and from the server, I'd rather do it all on the server, but can't figure out how
Any suggestions?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.