How would I copy x amount of records, at the same time changing one of the
fields?
I can't copy the records as is, because of unique constraints, and I can't
leave the field that needs to be changed blank, also because nulls are not
allowed.  So how would I do it in one swoop?

Use a staging table.

Copy the rows from TableA to a staging table. Change the data that
needs changing and then copy the rows in to Table B

Barry

Ah.  That works great, thanks!


Show quoteHide quote

Not sure about doing in one swoop but you could use a staging table.

Copy the rows from TableA to a staging table. Change the data that
needs changing and then copy the rows in to Table B

Barry

what does it need to be changed to? and from? and what data type is it?
x amount of records? do you mean e.g., "copy 50 rows from a to b" or
"copy however many rows match my criteria from a to b"?

Please post DDL, including constraints etc., sample data and desired
results. Otherwise, all answers can be considered nothing more than guesses.

dew wrote:
Show quoteHide quote

NESTED SQL QUESTION and aggregate function
CLR Triggers and inserted table
SQL script, split digits and letters
Concatenating:www.aspfaq.com/show.asp?id=2529 Is the glass half full or half empty or..?
Query help - resultset too large... impossible!