Viewing 5 posts - 1 through 5 (of 5 total)
I'm looking forward to trying this completely CTE based tally table. My impression is that this script is going to be very fast for what it is. I'll...
October 3, 2013 at 4:44 pm
Works perfectly. Elegant and fast solution. The only change I made was to the condition for the CASE statement:
WHEN SumStrength < 100 THEN 0 ELSE
It wasn't filling 0s...
October 3, 2013 at 3:41 am
This looks fantastic. I do get an "invalid object name TALLY" when I try to run it. Am I missing a few lines? I've never used a...
October 2, 2013 at 8:20 pm
Something else I just learned... while trying to apply this to my actual database: if I leave out an addresstype in the "ROW_NUMBER() OVER () section, that row with the...
February 28, 2013 at 1:30 pm
Thank you for this, and for putting together the sample code! Definitely helping me to learn a bit more!
February 28, 2013 at 11:26 am
Viewing 5 posts - 1 through 5 (of 5 total)