That looks like it is just what was ordered. If it were me I would much rather have it the way it is to start with. Can you...

SQL Kiwi (5/31/2012)

---

Aha, ok this is an easy tweak - we just need to traverse...

Lynn Pettis (5/31/2012)

---

Doesn't match with this from your original post:

Also, the NSF transactions are assumed to occur in the same order as the payments. For example, if customer 1 has...

SQL Kiwi (5/31/2012)

---

Greg Snidow (5/31/2012)

---

I don't get it Paul. I took 10 of the accounts that had records in my result set and not yours, and ran both of...

SQL Kiwi (5/31/2012)

---

Yes I highlighted that difference in my first post. I wonder if Greg missed...

Lynn Pettis (5/31/2012)

---

Greg,

Last night while working n this I did find a problem with your solution. Based on your requirements, one of the records you return is incorrect. ...

jblovesthegym (5/31/2012)

---

Greetings Greg, glad to see you're making progress on your issue. It's far above my mediocre scripting skills, otherwise it looks like a juicy one to sink teeth...

I don't get it Paul. I took 10 of the accounts that had records in my result set and not yours, and ran both of our code on only...

Thank you Paul. I was actually in the process of letting you know what a dunce I am for not trying that first. DOH!

Thank you so much Paul for investigating. I ran your solution against a table with around 800,000 rows and it ran in around 4 seconds, where my solution took...

dwain.c (5/30/2012)

---

Greg Snidow (5/30/2012)

---

Lynn, it's very close. Below is my expected output. The three rows with asterisks...

Lynn Pettis (5/30/2012)

---

Once I got your code to run, I do see a slight problem. I have three less values than you. So I am looking into why...

Lynn, it's very close. Below is my expected output. The three rows with asterisks are data missing...

Lynn, I...

SQLKnowItAll (5/30/2012)

---

I could see maybe adding another table and a trigger to parse out your 5008 payments into their own table? Sometimes the reorganization of data in another step will...