Category "sql-merge"

OUTPUT $action in SQL server, casing the updated rows output for a specific column

I am making merge upserts to my data warehouse. I don't need to keep the history on this particular object, so I'm using a type i slowly changing dimension. I'm