2 Added link, details, improved formatting (maybe!)
source | link

Annoying isn't it. I've done some research and it turns out it is incorrectly reporting a ANSI warning as an errorincorrectly reporting a ANSI warning as an error (resolved in SQL Server 2012, no patch available for previous versions). The easiest

One way to stop the error is to go through all your code, and wherever you have an aggregate function (i.e. SUM()g. SUM), use ISNULLISNULL to ensure the argumentaggregated value can never be NULLNULL:

i.e. change

SUM(Field1+Field2)

SUM(Field1+Field2)

to

SUM(ISNULL(Field1,0)+ISNULL(Field2,0))

SUM(ISNULL(Field1,0)+ISNULL(Field2,0))

This makes the error go away but might be impractical.

Annoying isn't it. I've done some research and it turns out it is incorrectly reporting a ANSI warning as an error. The easiest way to stop the error is to go through all your code, and wherever you have an aggregate function (i.e. SUM()), use ISNULL to ensure the argument can never be NULL:

i.e. change

SUM(Field1+Field2)

to

SUM(ISNULL(Field1,0)+ISNULL(Field2,0))

This makes the error go away but might be impractical

Annoying isn't it. I've done some research and it turns out it is incorrectly reporting a ANSI warning as an error (resolved in SQL Server 2012, no patch available for previous versions).

One way to stop the error is to go through all your code, and wherever you have an aggregate function (e.g. SUM), use ISNULL to ensure the aggregated value can never be NULL:

i.e. change

SUM(Field1+Field2)

to

SUM(ISNULL(Field1,0)+ISNULL(Field2,0))

This makes the error go away but might be impractical.

1
source | link

Annoying isn't it. I've done some research and it turns out it is incorrectly reporting a ANSI warning as an error. The easiest way to stop the error is to go through all your code, and wherever you have an aggregate function (i.e. SUM()), use ISNULL to ensure the argument can never be NULL:

i.e. change

SUM(Field1+Field2)

to

SUM(ISNULL(Field1,0)+ISNULL(Field2,0))

This makes the error go away but might be impractical