>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.