Home Forums Article Discussions Article Discussions by Author Discuss content posted by Keithdb CTE Example with Pivot operator Reply To: CTE Example with Pivot operator

  • May 2, 2019 at 4:15 pm

    #3630295

    wrote:

    Coalesce() with two arguments is equivalent to IsNull() ... might as well save yourself some typing

    Actually, Phil, I feel I need to correct you on that one. ISNULL and COALESCE do behave differently. COALESCE is a shortcut function for a CASE expression and therefore uses Data Type Precedence to determine the return value. ISNULL, however, returns the data type of the first parameter.

    I certainly agree on the dates though. Most of those would fail to convert to a date on my instance, or would provide the wrong value.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk