Recent content by jwilson2004

  1. J

    --NoFormat still adding indenting

    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...
  2. J

    Incorrect "Comparison with NULL" Compiler Hint

    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...
Back
Top