@ChrisM@Work

The end to end process is pretty much what I have said, I have products I need to clone. I have 10 tables, in any table I might need to clone a certain product. in each table there are products with their productID. If have productA in TableA and I need to clone this product, if productID of this product is 123, it's clone will have different productID, but everything else will be the same. but the products I need to clone are in different table.

So I'm thinking of a generic solution where the user can just pass the parameters then any table, row or column affected will be processed.

e.g @parameters, tablename, @productID, @newProductID, with these parameters, the proc or fuction should be able to clone any product in any table.

But other tables has IDENTITY(1,1) and other doesn't have. this comes a challenge, giving me errors I mentioned before.