The solution is composable dml.INSERT dbo.Approvals
(
RequestFormID,
[Approval (Y/N)],
ApprovalDate,
ManagerEmployeeID,
Comments
)
SELECT RequestFormID,
[Approval (Y/N)],
ApprovalDate,
ManagerEmployeeID,
Comments
FROM (
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