>Hi All,
>I need help construct SQL Statement in T-SQL, which will convert single record with a range into multiple records. (MS SQL Server 2005)
>
>The source table has structure like:
>

>cName nChar(50)
>nStartYear numeric(4,0)
>nEndYear Numeric(4,0)
>
>cName                  nStartYear                   nEndYear
>Name1                  2000                            2003
>Name2                  2010                            2012
>Name3                  2010                            2010
>
>The resulting set should look like
>cName                  nYear
>Name1                2000
>Name1                2001
>Name1                2002
>Name1                2003
>Name2                2010
>Name2                2011
>Name2                2012
>Name3                2010
>
>Thank you in advance
>
>Yelena

Did you try using UNPIVOT command or you need some help with it? Oops, didn't notice you need to insert records - simplest way would be using Numbers table.