Hi Eichpeel,

the output is caused by the following sequence (example quarterid = 1):

transactionidquarteridamountruntotalmax_amountusedtransactionamount

1155125

2138123

31715124

41-51012-5

51212122

Transactionid 3 exceeds the limit, and therefore is marked as "partial transaction".

Note: Due to the WHERE condition all...

Hey Flo, remember: I'm not too far away...

Let me know where and when. I'd assume an "Oktoberfest" invitation with accommodation and...

Steve Brett (6/23/2009)

---

Cheers - this is what I was heading for but need to justify it's benefit over a tree based approach preferred by some of the other developers.

The problem...

Eichpeel (6/23/2009)

---

First of all, I wanted to thank all of you for the help. I reused the original portion of the script posted by Lutz in my real life project...

You're welcome.

I just did remember a different thread with a similar question... 😉

I don't know if the following example will answer your question...

DECLARE @xml XML

SELECT @xml='

*$199 SHARED

24MTHS

AS PER AGREEEMENT PRE MAY.

*BAN:...

Please clarify what you're looking for.

"inserting XML data into SQL server / DB2 native XML database" is really confusing as far as I can see...

A brief description of the process...

We're almost there...

in order to get the top 5 per group you need to rank them first. Also, you have to define, how you deal with tie values. Please look...

We're getting closer...

So, what have you tried so far?

Regarding the 2nd question:

The answers for any given "N" with 0 < "N" <= [total number of rows in that table]...

Please follow the link in my signature on how to post sample data.

This should include what you've tried so far.

Please help us help you.

Please provide some sample data together with your expected result.

For posting xml data please use [ code="xml" ] tag (with spaces removed) around your sample data.

Other than that, please see...

Hi Steve,

as per the information you provided I can't really see the performance gain of a tree based solution. What would it look like?

If I understood you right then I...

Thank you for posting the results!

Since they are almost equal I'm wondering what the execution plans would look like...

Would you mind posting the actual execution plan for both options (saved...

I'm not sure if you need that job because you get data that often or if you just have to react "immediately" in case of some external events.

If it's the...

Great you found a solution that worked for you. But which one was it?