I was wondering if I could use the SQL MERGE command inside a DSS SQL Query recipe.
The structure of the Merge command is:
USING source_table ON merge_condition
WHEN MATCHED THEN update_statement
WHEN NOT MATCHED THEN insert_statement
WHEN NOT MATCHED BY SOURCE THEN DELETE;
Thanks in advance.