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 |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2004-03-19 : 04:45:53
|
Dear All, Can I accumulate the number on a number of records. For example, for every three record, the accumulated number is increment by 1.Stk_Name AccumulateNo-------- -----------AAAAAAAA 1BBBBBBBB 1CCCCCCCC 1DDDDDDDD 2EEEEEEEE 2FFFFFFFF 2GGGGGGGG 3OOOOOOOO 3 Thanks |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
|
|
|
|
|
Accumlation on a number of records