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