Viewing 15 posts - 946 through 960 (of 4,080 total)
GilaMonster (8/5/2011)
The Dixie Flatline (8/4/2011)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2011 at 10:44 pm
Just thinking out loud here. If he could come up with some sort of formula to condense the name strings down... by omitting vowels for example... could...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2011 at 6:26 pm
I took Lowell's code and tossed in a couple of bells and whistles. Like standardizing the commas.
-- Dude, periods in state abbreviations... seriously?
SELECT CityState,City+', '+st as fixed,city,st
FROM
(SELECT...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2011 at 1:59 pm
A couple of comments:
1. Think of a view as a template of a query, with a lot of stuff pre-written for you (joins, columns, calculated columns). ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2011 at 9:10 pm
I found a semi set based solution in a loop instead of using the cursor.
Would you mind posting your solution up here?
Don't forget the warnings about performance....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 2, 2011 at 9:47 pm
Please post the execution plans.
One big difference is that, for the adhoc query, the optimizer knows absolutely that the value of @StartTime = '07/08/2011 19:00PM'. 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
July 30, 2011 at 9:09 am
GilaMonster (7/29/2011)
I'm getting way too snide and cynical. Maybe time to take a short forum break again...
A little snide and cynical is part of your charm, Gail. 😉
Shake 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
July 29, 2011 at 8:22 am
I have nothing to add except my compliments on a really good 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
July 27, 2011 at 9:39 pm
Steve Jones - SSC Editor (7/27/2011)
The Dixie Flatline (7/27/2011)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 27, 2011 at 10:38 am
bopeavy (7/27/2011)
some select or what ever would show:
exid1 | exid2 | exid3 | combo
0 ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 27, 2011 at 7:23 am
Steve, maybe it's because I haven't had enough caffeine this morning, but I have a question: How does the ROWID column that you propose differ from...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 27, 2011 at 7:11 am
Haven't seen Captain America yet, but I may see it twice this week.
Cap ties with Ben Grimm for my all-time favorite comic book hero.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 25, 2011 at 4:20 pm
That's true given the data supplied. But my understanding is that the requirement was to get the salary from the row with the max(id), whether or not...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 25, 2011 at 1:40 pm
Count this as another vote for opc.three's solution.
+1
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2011 at 3:32 pm
I STRONGLY agree with Lowell. You are shooting yourself in the foot by storing the datetime information as varchar. You are losing the entire...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 21, 2011 at 3:29 pm
Viewing 15 posts - 946 through 960 (of 4,080 total)