SET somecolumn =
WHERE keyid = TargetTable.keyid)
Please reply only to the newsgroup
"Tonny René Poulsen" <anonymousdevdex.com> wrote in message
news:uZtPp4NQDHA.704tk2msftngp13.phx.gbl...> I need to replace the data in one column and keep the rest. I have
> 18,000 row.
> I tried various import/export procedures, but i'm not certain that the
> data is kept in a consistent state.
> I have two tables:
> One with working data (14 columns) and one with the new data (2
> columns). each table has a unique identifier.
> Regards Tonny
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!