TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
P G
NA
6
7.2k
Procedure to generate serial number from a range in a table
Apr 15 2011 1:05 PM
I have table which contains order number and corresponding Serial number range for those order.
I need to create another table where I can store order number with a list of all serial numbers for that order.
Table I have:
Order No SerialNoStart SerialNoEnd
1 55 66
2 77 90
3 233 237
Table I need to generate from above table:
Order No SerialNumber
1 55
2 56
3 57
| |
| |
3 66
4 77
4 78
| |
| |
4 90
5 233
5 234
| |
| |
5 237
It would be great if anyone can show me how to get this done. I dont care if it's done using function, procedure, etc. whatever is easy.
Thanks.
Reply
Answers (
3
)
Sql Query Problem
ssrs subscriptions