Hey all. What I'm trying to do seems to be very simple, yet I can't get it to work correctly. I need to make a stored procedure that takes in an ID number (unique key), finds that record and appends a copy of that record to the bottom of the table, with a new ID number. SQL Server keeps throwing errors at me, no matter what I do. I've tried to copy the record to a temp table and drop the identitiy column, and then copy back to the original table, but that doesn't work either. Anyone have a few suggestions? Thanks!!