USE DYNAMICS
GO
DELETE FROM dbo.SY08140 WHERE USERID = 'Destination_UserId';
INSERT INTO dbo.SY08140 (USERID
,SEQNUMBR
,TYPEID
,CmdID
,CmdFormID
,CmdDictID
,DSPLNAME
,ScbTargetStringOne
,ScbTargetStringTwo
,ScbTargetStringThree
,ScbTargetLongOne
,ScbTargetLongTwo
,ScbTargetLongThree
,ScbTargetLongFour
,ScbTargetLongFive)
SELECT 'Destination_UserId'
,SEQNUMBR
,TYPEID
,CmdID
,CmdFormID
,CmdDictID
,DSPLNAME
,ScbTargetStringOne
,ScbTargetStringTwo
,ScbTargetStringThree
,ScbTargetLongOne
,ScbTargetLongTwo
,ScbTargetLongThree
,ScbTargetLongFour
,ScbTargetLongFive
FROM dbo.SY08140
WHERE USERID = 'Source_UserId';
GO