Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create data from a range
Message
From
17/10/2014 06:50:58
Nicholas Mason
London, United Kingdom
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Create data from a range
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01609576
Message ID:
01609576
Views:
50
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
Next
Reply
Map
View

Click here to load this message in the networking platform