Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imrajesh
Starting Member
2 Posts |
 Posted - 2014-01-17 : 00:19:50
|
| I need to generate the trip number (shown as below) for each carrier, truck, trip eligibility combination. if the trip eligibility has 'Y' then serial number to be continued with next number, other wise previous row serial number has to be maintained.Anyone can help for this.? Thanks.Carrier Truckno TripElg TripNo SlNoA aa Y 1 1A aa N 1 2A aa N 1 3A aa Y 2 4A aa Y 3 5A aa N 3 6A aa Y 4 7A bb Y 1 8A bb N 1 9A bb Y 2 10A bb Y 3 11A bb Y 4 12B ac Y 1 13B ac N 1 14B ac N 1 15B ac Y 2 16B ac N 2 17B ad Y 1 18With Thanks & RegardsRajesh S |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
imrajesh
Starting Member
2 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Conditional Serial Number Generation