I'm trying to turn off all beautification in just one package by putting --NoFormat Start and --NoFormat End just inside the CREATE and END statements. The package no longer reformats, but it still adds an additional indent of 3 spaces to every line. Is there a way to avoid this?
Here's the...
When setting a field to NULL in a MERGE statement, it appears to incorrectly interprets the = as a comparison operator and generates a compiler hint "Comparison with NULL":
MERGE INTO hydro.address_cleanup ac
USING (SELECT DISTINCT aci.unique_id
FROM hydro.address_cleanup aci) x
ON...