When I use larger numbers I get this error "types don't match between the anchor and the recursive part"
CREATE TABLE #TempBet
(Id int, Low numeric, High numeric)
INSERT INTO #TempBet (Id, Low, High)
SELECT 1, 10000000000, 30000000000 UNION ALL
SELECT 2, 20000000000, 30000000000 UNION All
SELECT 3, 50000000000, 80000000000
; WITH Info (Id, Low, High, Result) AS (
SELECT Id, Min(Low), Max(High), Min(Low)
FROM #TempBet
GROUP BY Id
UNION ALL
SELECT Id, Low, High, Result + 1
FROM Info
WHERE Result < High )
SELECT * FROM Info
ORDER BY Id, Result