I need to move some records from one table (staging area)
to another exactly similar.
Both tables, tough, have PK in first column,
and I need to save the new IDs inserted in the ProdTable.
Something similar to:
INSERT INTO ProdTable(Field1, Field2)
SELECT Field1, Field2
WHERE UserId = 10
How can I save (for future use) these new inserted Ids?
Thank you in advance.