>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

For such problems the best solution will be to have 2 permanent tables in the database: Numbers and Calendar.

Check this blog post

http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2011/01/04/filling-in-data-potholes-redux-tally-tables-vs-ctes.aspx

You may also check my blog post where I provide scripts and links to the Numbers and Calendar tables:

http://blogs.lessthandot.com/index.php/datamgmt/datadesign/passing-multiple-ranges-to-stored-proced/