The solution is composable dml.INSERT dbo.Approvals ( RequestFormID, [Approval (Y/N)], ApprovalDate, ManagerEmployeeID, Comments )SELECT RequestFormID, [Approval (Y/N)], ApprovalDate, ManagerEmployeeID, CommentsFROM ( MERGE dbo.RequestForms AS tgt USING ( VALUES (@Approval, @RequestFormID) ) AS src(Approval, RequestFormID) ON src.RequestFormID = tgt.RequestFormID WHEN MATCHED THEN UPDATE SET tgt.[Approval (Y/N)] = src.Approval OUTPUT tgt.RequestFormID, tgt.[Approval (Y/N)], tgt.ApprovalDate, tgt.ManagerEmployeeID, tgt.Comments ) AS d;
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA