--



;WITH CTE AS
(
    SELECT DISTINCT Number FROM Master..Spt_Values WHERE Number > 1 AND Number  <= 1000 
) 
SELECT MAX(Number) Number FROM 
( 
      SELECT DISTINCT Number FROM MASTER..SPT_VALUES num 
       WHERE Number >= 2 AND Number <= 50 
       AND NOT EXISTS 
       ( 
                SELECT 1 FROM MASTER..SPT_VALUES AS num1 WHERE num1.Number > 1
		AND  num1.Number < num.Number
		AND  num.Number % num1.Number = 0
	)

)r
WHERE @ % Number = 0

--

--



DECLARE @ INT = 39

;WITH CTE AS
(
    SELECT DISTINCT Number FROM Master..Spt_Values 
    WHERE Number > 1 AND Number  <= 1000
)   
SELECT MAX(Number) Number 
FROM 
(

SELECT Number FROM CTE
EXCEPT
(
    SELECT ( F1.number * F2.number ) a
    FROM CTE AS F1, CTE AS F2
    WHERE
    F1.Number BETWEEN 2 AND CEILING (SQRT (1000))  
    AND F1.Number <= F2.Number
    AND (F1.Number * F2.Number) <= 1000
)

)r
WHERE @ % Number = 0


--