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
SQL script, split digits and letters
CLR Triggers and inserted table
Colour My World
Guaranteed consecutive identity values
Removing duplicate data
wtf - sorting table doesnt work????
Query Help - Counting Dates and Times
Select query
Need help setting up linked server