INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
"...What a great service! This is the best site I've ever seen!!! It totally restores my faith in humanity when people take time out to help other people..."
Where in the world do Tek-Tips members come from?
T-SQL Hints and Tips
How to add sequence number within groups of repeating values
Posted: 7 Apr 04 (Edited 11 Jul 04)
This has been asked in various forms a number of times. It occurs when you have groups of numbers in a column e.g.
and you want to apply a sequence number within each group of numbers, starting at 1 again for each instance of a new group, so your resulting data will look like this;
102 1 )
102 2 ) An ascending sequence number is created
102 3 ) for each group of numbers e.g. '102'
102 4 )
Note: After some useful discussions on various threads I've decided to remove my original solution and point you toward the threads containing much better solutions by ESquared, Donutman, NigelRivett and others;
ESquared & Donutman's solution;
NigelRivetts solution, without requiring temp tables;
Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close