469,902 Members | 2,002 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

Break in sequence

Hello,
does anyone knows of a way to group a set of records everytime a break in a sequence occurs. Let me explain.
I have a sequence of numbers like 1,2,3,4,5,7,8,9 when I reach the break (6) I need to group 1,2,3,4, and 5 together and 7,8, and 9.
I have it working with a cursor but it seems extremely slow. There has to be a better way to do it.
any help would be appreciated. Inn advance thank you
Jun 25 '07 #1
0 966

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Martin Lucas-Smith | last post: by
5 posts views Thread by Ann | last post: by
reply views Thread by Rary | last post: by
9 posts views Thread by Bill Borg | last post: by
2 posts views Thread by JoeW | last post: by
5 posts views Thread by John Speth | last post: by
15 posts views Thread by suga.masanobu | last post: by
10 posts views Thread by Dick Moores | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.