When I run the SQL below, I get this warning message :
Warning: Null value is eliminated by an aggregate or other set operation
The warning is due to line for when the SEQUENCE_NUMBER is compared to "IS NULL".
Why is this? Can someone tell me how I can fix this?
1 DECLARE @MAXIMUM INT
2 DECLARE @MINIMUM INT
3 SELECT @MAXIMUM =
4 ISNULL(MAX(MyList.SEQUENCE_NUMBER),0) from
5 (select distinct (A_NUM),SEQUENCE_NUMBER from SHAKER WHERE SEQUENCE_NUMBER IS NULL) MyList