I need to copy data from an ExisitngID and Description values to a new ID and existing description. For instance
Existing records in a one to many table
NewRecordID with the same values in Desc as above
I am tyring to pretty much clone the values from one ID to a new ID. Is there a better way of doing this without a cursor?
What I have in my proc so far is the developer passing me the ExistingID and the NewID and I have to fetch the ExistingID values and Insert them into the same table with the NewID