Viewing 15 posts - 2,941 through 2,955 (of 4,080 total)
True enough, Gail. I'm guilty both of assuming that Flo is on 2005/2008 and that a dashboard application looking at huge files only needs a "close enough" value....
__________________________________________________
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 26, 2009 at 8:09 am
Hey Paul, I followed your link about the new flag. My son has lived in Dunedin for years now, but never mentioned this to me. As...
__________________________________________________
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 26, 2009 at 7:24 am
Greetings Flo:
Never saw the bottle, but you're welcome to anything I ever post up here, as is everyone else. I wouldn't think you'd need my code after 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 26, 2009 at 7:03 am
My thought exactly, Lynn. It may be a case of procedural addiction. No cursor or while loop, but still a sort of step-by-step approach.
__________________________________________________
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 25, 2009 at 11:55 pm
How about this one? Fresh off the presses...
1. Create temporary table "A"
2. Populate it with base ids
3. Query table "B" and update one column in...
__________________________________________________
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 25, 2009 at 9:54 pm
So are we just saying it depends?
Seriously, if this can be boiled down to performance characteristics tied to a matrix of variables, it would be a valuable resource...
__________________________________________________
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 25, 2009 at 2:22 pm
How many phrases are you going to search for? I've got a solution that is child's play to code, but it's never been tested at large volumes. ...
__________________________________________________
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 25, 2009 at 1:16 pm
Hey Flo:
I haven't seen anything. When, where, and how did you send it? 🙂
__________________________________________________
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 25, 2009 at 1:00 pm
If you don't already have one, you will really find it to your advantage to create a calendar table and prepopulate several years in advance with dates, flagged as weekends...
__________________________________________________
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 25, 2009 at 1:00 am
One other thought, although I know and love the ORDER BY CASE technique...
If you will be using this sort order in many places, and may be adding additional items in...
__________________________________________________
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 25, 2009 at 12:26 am
So the repeating record gets listed only once.
This sounds like a SELECT DISTINCT query. It returns only the unique combinations of all columns included in the SELECT list.
__________________________________________________
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 25, 2009 at 12:13 am
While I'm sure your solution will work fine, it seems like overkill to fire a trigger and delete a row every time a user hits a new page. ...
__________________________________________________
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 25, 2009 at 12:08 am
agreed
__________________________________________________
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 24, 2009 at 4:01 pm
We're not talking about linked servers... I KNOW the answer to that question.
Not sure the table sizes justify separate disk resources, but they could live where the load is lightest.
Query...
__________________________________________________
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 24, 2009 at 12:19 pm
Can someone help out here? I started to answer yet another question about catching output from a procedure which builds dynamic SQL. Jeffrey Williams and 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 23, 2009 at 6:16 pm
Viewing 15 posts - 2,941 through 2,955 (of 4,080 total)