Generating simc profiles for gearing path

DECLARE @startnum INT=5000
DECLARE @intervalnum INT=500
DECLARE @endnum INT=35000
;
WITH gen AS (
    SELECT @intervalnum AS num
    UNION ALL
    SELECT num + @intervalnum FROM gen WHERE num + @intervalnum <= @endnum
)
SELECT
	c.num AS CritRating
	,h.num AS HasteRating
	,m.num AS MastRating
	,v.num AS VersRating
	,c.num + h.num + m.num + v.num AS TotalRating
INTO #Temp
FROM gen AS c
CROSS JOIN gen AS h
CROSS JOIN gen AS m
CROSS JOIN gen AS v
WHERE (c.num + h.num + m.num + v.num) < @endnum
	AND (c.num + h.num + m.num + v.num) >= @startnum
option (maxrecursion 0)

--DECLARE @endnum INT=35000
SELECT
	'profileset.C' + cast(a.CritRating AS varchar(5)) + '_H' + cast(a.HasteRating AS varchar(5)) + '_M' + cast(a.MastRating AS varchar(5)) + '_V' + cast(a.VersRating AS varchar(5)) AS profilename,
	a.CritRating,
	a.HasteRating,
	a.MastRating,
	a.VersRating
INTO #Temp2
FROM #Temp AS a
WHERE a.CritRating <= (@endnum / 2)
	AND a.HasteRating  <= (@endnum / 2)
	AND a.MastRating  <= (@endnum / 2)
	AND a.VersRating  <= (@endnum / 4)

SELECT
	*
FROM ((SELECT
		b.profilename + '+=gear_crit_rating=' + cast(b.CritRating AS varchar(5)) AS profile
	FROM #Temp2 AS b)
	UNION
	(SELECT
		b.profilename + '+=gear_haste_rating=' + cast(b.HasteRating AS varchar(5)) AS profile
	FROM #Temp2 AS b)
	UNION
	(SELECT
		b.profilename + '+=gear_mastery_rating=' + cast(b.MastRating AS varchar(5)) AS profile
	FROM #Temp2 AS b)
	UNION
	(SELECT
		b.profilename + '+=gear_versatility_rating=' + cast(b.VersRating AS varchar(5)) AS profile
	FROM #Temp2 AS b)) AS c
ORDER BY c.profile

DROP TABLE #Temp
DROP TABLE #Temp2