• Good question, but wrong explanation (and also wrong error message from SQL Server):

    The coalesce expects at least one typed NULL in order to execute and hence the error.

    Simple example that does NOT contain a typed NULL:

    COALESCE(1,1)

    Best Regards,

    Chris Büttner