Viewing 15 posts - 3,256 through 3,270 (of 3,957 total)
GPO (7/2/2012)
A stunning contribution to the discussion Dwain. The SQL Server world just got a little better.
Thanks GPO, for the kudos and the inspiration! The article was fun to...
July 2, 2012 at 10:46 pm
Sean Lange (7/2/2012)
July 2, 2012 at 9:07 pm
Hey Les! Just wanted you to know that I haven't forgotten about you and Sweden.
Here's a progress report. I have a single, cascading CTE that generates the following:
1....
July 2, 2012 at 8:07 pm
Your welcome. That's actually the first time I've had a chance to try a correlated subquery inside a CROSS APPLY!
July 1, 2012 at 10:53 pm
Since valuation date has changed on the B record for counterparty, I don't see how you can consider it to be part of the same group on deal ID, contract...
July 1, 2012 at 9:22 pm
Sorry but I do know why the CTE returns 0 rows. You must still have the population equality check on the last line. Try taking that out.
You'll find...
June 30, 2012 at 5:52 am
Les Cardwell (6/29/2012)
BTW, I ran it against this server, and it ran in 7min...however, no rows were returned.
Singles - you can limit this...
June 30, 2012 at 5:39 am
Jeff Moden (6/28/2012)
June 28, 2012 at 8:20 pm
Les,
I'll need to go over your posts carefully to thoroughly understand but I think what you're saying I can grok.
Last night when I was working on this, I realized that...
June 28, 2012 at 8:04 pm
Jeff,
First of all, thanks for not laughing. 🙂
Clearly you've made a wonderful improvement to the speed. And I do recognize the trick (CROSS APPLYs right?). I've been meaning...
June 28, 2012 at 7:57 pm
I think this SQL is the correct algorithm, however I have not been able to arrive at a way yet to prune the resultset of unwanted results to pass to...
June 28, 2012 at 8:46 am
Jeff Moden (6/28/2012)
dwain.c (6/27/2012)
I like this problem and wanted to contribute.Let other people in on the fun. 🙂 What does dbo.GenerateCalendar() look like?
Please don't laugh! This was a...
June 28, 2012 at 8:16 am
Hello again Les!
Since I couldn't stop thinking about this today, I decided to learn what I could so as to ask you my questions prior to the weekend. To...
June 28, 2012 at 6:50 am
Les,
I did take a quick 15 minute look. It appears you didn't implement Chris's speed improvement suggestions. However I doubt that will be sufficient for the size of...
June 28, 2012 at 12:42 am
Finally? I didn't realize I was on a deadline...:w00t:
June 27, 2012 at 11:14 pm
Viewing 15 posts - 3,256 through 3,270 (of 3,957 total)