• 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