Relative Content

Tag Archive for sqlsql-serverinsertsql-insertbulkinsert

Insert with values from existing table

I need to move some values based on expiration date, but unfortunately because the tables are not one to one in number of records I receive an error message when my query is run. I need SQL to be able to assign it’s own primary key value because I believe that is where the conflict is coming from.

Insert into sql table with values from existing table

I need to move some values based on expiration date, but unfortunately because the tables are not one to one in number of records I receive an error message when my query is run. I need SQL to be able to assign it’s own primary key value because I believe that is where the conflict is coming from.