..bunch of code..
COMMIT TRAN
SELECT @id