Viewing 15 posts - 2,986 through 3,000 (of 4,080 total)
🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 12:17 pm
Henk:
Look up sp_rename in SQL books online. Before renaming a column, check dependencies to see if you have any views, stored procedures, functions, etc that might depend...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 9:58 am
Looking at the schema, and I use the term loosely, of your input table, I assume you are pulling this from a spreadsheet and that you won't have hundreds of...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 9:20 am
Talk about a photo-finish. 😛
I set up a test against one million rows, run 100 times with half the numbers being negative. (The code for the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 8:41 am
John, I'm NOT absolutely sure, having seen your numbers. I would have expected CASE to be less code, basically a single "if". But the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 7:19 am
Paul, I am drawing on the experience that oftentimes a precalculated date or calendar table produces faster solutions than doing DATEADD,DATEDIFF on the fly. It would seem...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 7:01 am
Something to ponder.
This thread has also made me broaden my horizons about tally tables. Why should there be just one flavor? If...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 12:15 am
Hey Paul, this thread may be the motivator for me to finally learn that awful note (pun) of a language. But it also convinces me that CLR isn't...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 22, 2009 at 12:06 am
Jeff: Just a hair slower than you guys... on my laptop at least.
Hard to isolate because of other processes, but it seems to be about...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 11:58 pm
Flo and Jeff, I just had to try.
This beast features double-barelled carburetors.... errrr tally tables.... one with two columns, and nested CROSS APPLYs.
Can you help me...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 8:52 pm
I'm about to test my only thought on the matter. If it seems to perform well, I'll send it to you.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 2:48 pm
Flo:
After following the Tally thread, there is no way I can claim to be your mentor. However you are welcome to any little tips or techniques I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 2:34 pm
Jeffrey is absolutely correct.
Because the date test appeared late in the WHERE clause, I assumed that there wasn't an index over the date(s).
(Don't ask...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 2:20 pm
If the white space is to the left, why aren't you searching where clientcode like
%LC157790%
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 10:56 am
Okay... let's rethink this in terms of SQL functionality. You are wanting to do month/year comparisons ignoring the date and time. There is no need...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
April 21, 2009 at 10:23 am
Viewing 15 posts - 2,986 through 3,000 (of 4,080 total)