Viewing 15 posts - 1,816 through 1,830 (of 4,080 total)
It depends.
Do you want to (1) get the min, max or average size within each name, along with your max SeqID , (2) group by size...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 11:23 am
Whups, my apologies to the Guru and to Paul both. I promise to come back when I have time to read through all this more carefully.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 10:14 am
I wasn't told there would be a TEST... :w00t: :w00t: :w00t:
But I do recall writing at some point in the article.... 'testing, testing, testing'.
I'm surprised (but pleased) to see that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 17, 2010 at 8:06 am
Frankly, it's always a pleasure to hear someone just admit that they are new to SQL and open to learning.
If you keep looking at articles in SSC,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 4:49 pm
Sorry, I misunderstood the role of the VB application. Is the visual basic application creating the query string and passing it? Or is it executing a stored...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 4:29 pm
tstaker (3/16/2010)
The Dixie Flatline (3/16/2010)
...Gail, in ancient Geece you would have been a goddess in the Geek pantheon.
So what you're saying is around 137 BC she'd be a goddess 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
March 16, 2010 at 4:01 pm
l33t u r
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 3:57 pm
To paraphrase Dilbert:
"A number of studies have shown that made-up statistics are just as good as factual statistics."
"How many studies have said that?"
"42"
-----------
Gail, in ancient Geece...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 3:39 pm
Hey Lutz 🙂 I beat you to the punch for once !! 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 3:28 pm
I echo Lutz' question.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 3:10 pm
Odd....
Here are the results I'm getting with your test data. Looks like one row per employee to me, with this data.
What are you expecting your...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 3:01 pm
group by EmpID, EmpName, StartDate, EndDate, TotalHours
This is just a snapshot answer, but if you only expect one row per employee, I would expect to see a group by...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 2:50 pm
Only 25,000 rows? (rows... not records) No way should that be taking 30 seconds. Try this.
INSERT INTO TargetTable (column list)
SELECT FROM SourceTable (column list)
WHERE...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 2:12 pm
Grant Fritchey (3/16/2010)
Yeah, it was absolutely top notch. Too bad he didn't write it for the Standard. I would have paid more. 😀
You would have paid 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
March 16, 2010 at 10:14 am
Thanks, guys.
Your comments did me more good this morning than my first cup of coffee (which I have yet to pour).
Flo: ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 16, 2010 at 6:17 am
Viewing 15 posts - 1,816 through 1,830 (of 4,080 total)