I need a SQL Server 2000 stored procedure that can do the following.
Sort a table similar to the following by column SVC_TYPE, BEG, END. Also the stored procedure should update the group column with the correct group number for each change in SVCTYPE. The group number should always start with 1.
<colgroup> <col style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" span="5" width="98" /></colgroup>
| ID | SVCTYPE | BEG | END | GROUP |
| 2 | AAA | 120 | 120 | 1 |
| 1 | AAA | 100 | 100 | 1 |
| 5 | BBB | 100 | 100 | 2 |
| 3 | BBB | 105 | 107 | 2 |
| 6 | CCC | 210 | 210 | 3 |
| 4 | CCC | 210 | 210 | 3 |
| 7 | DDD | 155 | 155 | 3 |
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
## Platform
SQL SErver 2000