Viewing 15 posts - 181 through 195 (of 262 total)
Thanks, looks like QU is still a winner even in 2012. 🙂
May 28, 2014 at 10:24 pm
Has anyone done any significant testing of the Quirky Update method in SQL Server 2008, 2012, or 2014? Does it work in those versions too?
It's easy enough to test...
May 28, 2014 at 8:11 pm
Terrific, thank you for confirming this!
May 28, 2014 at 2:06 pm
Yessir, all is well! 🙂 Thank you for checking back in!
May 25, 2014 at 9:26 am
Normally I would be sharing all my code. But this particular time it would not be appropriate to share. 🙁 I had to abstract the problem and the code a...
May 25, 2014 at 8:30 am
Update:
J Livingston's version of Craig's version of Jeff's QU is basically the solution I am going with. Thanks again to J and also to everyone else involved in getting us...
May 24, 2014 at 7:11 pm
Thanks for the extra work, J Livingston! I didn't think of updating a CTE rather than the temp table itself. As long as it follows the same rules vis a...
May 23, 2014 at 12:50 pm
I was just about to post an update when I saw your reply, Craig!
My update for the day, coincidentally, was that I actually spent a good deal of time...
May 22, 2014 at 7:54 pm
@jeff, in testing your rCTE code on larger data sets, it seems to work most optimally in batches of about 1000 records at a time. (And even so,...
May 21, 2014 at 7:54 pm
Thanks to everyone who has replied already. A better group of fellas I couldn't possibly ask for.
@Eirikur: Thank you again for all your work on this solution! I have...
May 21, 2014 at 12:35 pm
Thanks Craig for the considered reply. I spent a good 2 hours today reading through Jeff's QU solution and all the dozens of pages of replies and heated debate. After...
May 20, 2014 at 7:01 pm
So, first off, thanks again. This is amazing to me.
I've spent well over an hour looking at this and trying to break it down into its individual elements, doing...
May 19, 2014 at 11:36 am
Thanks for the reply! Looks as if you may have cracked it! 🙂 I'll take a close look on Monday morning when I have SSMS access and get back to...
May 18, 2014 at 11:05 pm
P.S. There is some added logic to do with whether subsequent sales are attempted by the original SalesRep or another SalesRep, but I'll leave that for later. Just wanted to...
May 16, 2014 at 4:24 pm
Viewing 15 posts - 181 through 195 (of 262 total)