brgdotnet
asked on
The warning is due to line for when the SEQUENCE_NUMBER is compared to "IS NULL".
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
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
5 (select distinct (A_NUM),SEQUENCE_NUMBER from SHAKER WHERE SEQUENCE_NUMBER IS NULL) MyList
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER