Viewing 15 posts - 121 through 135 (of 621 total)
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 11:17 am
SQL Kiwi (5/31/2012)
Greg Snidow (5/31/2012)
I hope my description of that record to Lynn will clarify things a bit.
Aha, ok this is an easy tweak - we just need to traverse...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 9:48 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 8:53 am
SQL Kiwi (5/31/2012)
Greg Snidow (5/31/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 8:46 am
SQL Kiwi (5/31/2012)
Lynn Pettis (5/31/2012)
It happens to be the one that Paul found with his solution.
Yes I highlighted that difference in my first post. I wonder if Greg missed...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 8:37 am
Lynn Pettis (5/31/2012)
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. ...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 8:33 am
jblovesthegym (5/31/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 6:32 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 6:17 am
Thank you Paul. I was actually in the process of letting you know what a dunce I am for not trying that first. DOH!
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 6:00 am
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...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 31, 2012 at 5:48 am
dwain.c (5/30/2012)
Greg Snidow (5/30/2012)
Lynn Pettis (5/30/2012)
you will have to tell me if it is okay.
Lynn, it's very close. Below is my expected output. The three rows with asterisks...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 30, 2012 at 7:02 pm
Lynn Pettis (5/30/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 30, 2012 at 6:57 pm
Lynn Pettis (5/30/2012)
you will have to tell me if it is okay.
Lynn, it's very close. Below is my expected output. The three rows with asterisks are data missing...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 30, 2012 at 1:02 pm
Lynn Pettis (5/30/2012)
Not sure this is correct, couldn't find any expected results based on the sample data provided, so you will have to tell me if it is okay.
Lynn, I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 30, 2012 at 12:41 pm
SQLKnowItAll (5/30/2012)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
May 30, 2012 at 11:50 am
Viewing 15 posts - 121 through 135 (of 621 total)