heh heh..sorry bout that, couldn't...

I think you're...

Garadin (10/18/2008)

---

Interesting... I swore it worked when I ran it at the office. I don't even remember adding the WITH INDEX clause to the second piece. In any...

bhovious (10/17/2008)

I have tested it against one of the patterns you just sent and found a discrepancy there which can be fixed, but first let me ask: Will...

I...

Garadin (10/17/2008)

---

OK. This will be attempt #1 at a set based solution. I'm not 100% sure at the speed of this, as the index does not fully cover...

Hi,

I also have an attachment here named demo to help understand on what I'm about to achieve or help better support my objectives.

-dans

Gary Johnson (10/16/2008)

---

Thanks for posting the sample data and DML.

I'm not clear on what you want the output to be. If you can post that maybe we can come...

Matt Miller (9/8/2008)

---

It sounds like you have a working solution, but if you want to pursue tracking down the scenarios it doesn't work in, let me know what an example...

Matt Miller

Thank you very much for the script and idea. This works for some of the scenarios though some of which are giving me incorrect data output.

Christian Buettner

Your script is...

Hi All,

Sorry for the late reply.

Christian Buettner:

Hi dans,

You might try something like in the attached example.

I have not spent too much time verifying it, so it might contain a...

I see. What we are dealing here is a huge data like about 2 Million or more with possible pattern as to my sample. Aside from this, I'm also looking...

To parackson:

RowID 15 shouldn't be part of first set since this should be in sequence and this is a stored procedure which returns directly the result (range of row ids)

To...

Actually no, I'm trying to find the interleaving rows of unique data (trying to look at the combination of RowKey and Locale column). In the above sample, you can see...

RowIDs are just for row counters on which to return the range result. What I need to look at is the combination of the two columns [RowKey] and [Locale] as...