Forum Replies Created
Viewing 2 posts - 1 through 3 (of 3 total)
-
Reply To: Line number in error message doesn't match up with line number in code
I use the (undocumented) LINENO command when testing my stored procedures. This makes the line reported in the error correspond more exactly to the code.
-
Reply To: Merge statement - matching ON all columns
This is what I typically end up with. It handles either column being null.
WHEN MATCHED AND (IIF(T.Site_Name IS NULL, IIF(S.Site_Name IS NULL, 0, 1), IIF(S.Site_Name...
Viewing 2 posts - 1 through 3 (of 3 total)