DECLARE 
	@childAge1 AS FLOAT = 2,
	@childAge2 AS FLOAT = 5,
	@childAge3 AS FLOAT = 7,
	@childAge4 AS FLOAT = null,
	@childAge5 AS FLOAT = null;

DECLARE @Childs TABLE 
(ChildAge FLOAT);

INSERT INTO @Childs (ChildAge)
VALUES
	(@childAge1),
	(@childAge2),
	(@childAge3),
	(@childAge4),
	(@childAge5);

declare @NeededChildsTotal AS INT
select @NeededChildsTotal = COUNT(ChildAge) from @Childs where ISNULL(ChildAge, -1) != -1

select Code, SUM(NeededChildCount) as SumNeededChildCount
from (select ChildAge, COUNT(1) as NeededChildCount from @Childs where ISNULL(ChildAge, -1) != -1 group by ChildAge ) CH
INNER JOIN 
	(select Count(1) as FoundChildCount, Code, ChildAge from NumberRanges group by Code, ChildAge) N
	ON CH.ChildAge = N.ChildAge AND CH.NeededChildCount > 0 AND CH.NeededChildCount <= N.FoundChildCount
GROUP BY Code
HAVING COUNT(FoundChildCount) = @NeededChildsTotal OR SUM(FoundChildCount) = @NeededChildsTotal