Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Create Records Using Number Range From One Record RE: Create Records Using Number Range From One Record

  • May 26, 2016 at 9:29 am

    #1881600

    sestell1 (5/26/2016)

    Would this work?

    SELECT

    Row_ID, Serial_Table.Serial_Number + Sequence.Digit

    FROM

    Serial_Table

    JOIN

    (

    SELECT

    DIGIT

    FROM

    (VALUES (0), (1),(2),(3),(4),(5),(6),(7),(8),(9), (10)) Numbers(digit)

    ) Sequence

    ON

    Sequence.Digit <= Serial_Table.End_Serial_Number - Serial_table.Serial_Number

    This worked perfectly. Thanks!