>Hi
>
>I have a list of data
>
>ID From To
>1001 100 103
>
>I want to use this to create data rows in another table
>
>ID Type
>1001 100
>1001 101
>1001 102
>1001 103
>
>any thoughts on the best way to do this in sql
>
>Thanks
>
>Nick

I've got it thanks

 WITH each AS
(
    SELECT an_eventid,  an_label_range_start AS n, an_label_range_end
      FROM SERVER01.dbo.campaign where an_label_range_start is not NULL
    UNION ALL
    SELECT an_eventid,  n + 1, an_label_range_end
      FROM each
     WHERE n + 1 <= an_label_range_end
)
SELECT an_eventid,  n
FROM each order by an_EventID,n