DECLARE @p_NumberOfRows Bigint SELECT @p_NumberOfRows=1000000; WITH Base AS ( SELECT 1 AS n UNION ALL SELECT n+1 FROM Base WHERE n < CEILING(SQRT(@p_NumberOfRows)) ), Expand AS ( SELECT 1 AS C FROM Base AS B1, Base AS B2 ), Nums AS ( SELEC…