SQL Merge command in SQL query

MRvLuijpen

Hello Community,

I was wondering if I could use the SQL MERGE command inside a DSS SQL Query recipe.

The structure of the Merge command is:

MERGE target_table
USING source_table ON merge_condition
WHEN MATCHED THEN update_statement
WHEN NOT MATCHED THEN insert_statement
WHEN NOT MATCHED BY SOURCE THEN DELETE;

See https://www.sqlservertutorial.net/sql-server-basics/sql-server-merge/

Thanks in advance.

fchataigner2

Hi,

you cannot use MERGE inside a SQL Query recipe, but that should work inside a SQL Script recipe (the second option in the modal you get when you create a SQL recipe)

MRvLuijpen

Thank you for your response.