-- Prepare sample data
DECLARE	@NutDef TABLE (NutrientID INT, NutrientName VARCHAR(20))

INSERT	@NutDef
SELECT	4, 'Natrium' UNION ALL
SELECT	6, 'Water'

DECLARE	@FoodDef TABLE (FoodID INT, FoodName VARCHAR(20))

INSERT	@FoodDef
SELECT	5, 'Salt' UNION ALL
SELECT	9, 'Cucumber'

DECLARE	@Nutrients TABLE (FoodID INT, NutrientID INT, Value SMALLMONEY)

INSERT	@Nutrients
SELECT	5, 4, .83 UNION ALL
SELECT	9, 4, .01 UNION ALL
SELECT	9, 6, .98

-- Prepare parameters
DECLARE	@Val1 INT,
	@Val2 INT,
	@Val3 INT,
	@Val4 INT,
	@Val5 INT,
	@Val6 INT

SELECT	@Val1 = 6,
	@Val2 = 0,
	@Val3 = 0,
	@Val4 = 0,
	@Val5 = 4,
	@Val6 = 0

-- Show the expected output
SELECT		hi.FoodID,
		fd.FoodName
FROM		(
			SELECT	FoodID,
				ROW_NUMBER() OVER (PARTITION BY FoodID ORDER BY Value DESC) AS HighRec
			FROM    @Nutrients
			WHERE	NutrientID IN (@Val1, @Val2, @Val3)
		) AS hi
INNER JOIN	(
			SELECT	FoodID,
				ROW_NUMBER() OVER (PARTITION BY FoodID ORDER BY Value) AS LowRec
			FROM    @Nutrients
			WHERE	NutrientID IN (@Val4, @Val5, @Val6)
		) AS lo ON lo.FoodID = hi.FoodID
INNER JOIN	@FoodDef  AS fd ON fd.FoodID = hi.FoodID
WHERE		hi.HighRec = 1
		AND lo.LowRec = 1

-- Show the expected output again
SELECT		n.FoodID,
		fd.FoodName
FROM		@Nutrients AS n
INNER JOIN	@FoodDef AS fd ON fd.FoodID = n.FoodID
GROUP BY	n.FoodID,
		fd.FoodName
HAVING		MIN(n.Value) = MIN(CASE WHEN n.NutrientID IN (@Val4, @Val5, @Val6) THEN n.Value END)
		AND MAX(n.Value) = MAX(CASE WHEN n.NutrientID IN (@Val1, @Val2, @Val3) THEN n.Value END