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 |
|
seidburns850
Starting Member
1 Post |
 Posted - 2009-05-03 : 17:05:58
|
| http://www.sqlteam.com/article/detecting-runs-or-streaks-in-your-data How would I alter that not to track streaks across uniqute dates but rather across several entries PER date.Primarily, if we have data like this:DATE EVENT_NUM HR 3/31 1225 13/31 1232 0 3/31 1243 03/31 1257 04/2 1342 14/2 1394 14/2 1399 04/3 1404 04/3 1412 04/4 1565 04/4 1587 1Since the dates are not unique, I'd want to doctor that above linked-script to tell me how many event_num entries occur between each run group. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Jeff Smith Runs/Streak Script