Viewing 15 posts - 5,461 through 5,475 (of 7,483 total)
Good easy question.
I got it wrong because I am not case-sensitive when scanning SQL :blush::laugh:
Tom
September 11, 2011 at 2:47 pm
mattech06 (9/11/2011)
Tom
September 11, 2011 at 1:14 pm
I think I get it: is this what you mean?
The phone table contains two lines for each patient - one marked (in the dbphonetypeid column) 9 which contains the email...
Tom
September 11, 2011 at 11:01 am
CELKO (9/10/2011)
Another good rule of thumb is that no procedure should be longer than one page.
It's a good rule of thumb for any language, not just SQL; but of...
Tom
September 11, 2011 at 6:05 am
GilaMonster (9/10/2011)
That might get you a percent or two improvement at most.
If "that" means the OPs suggestion of using uodate...where current it won't give even a couple of per...
Tom
September 11, 2011 at 5:47 am
You give no indication how to determine which row in T2 corresponds to a row in T3, or which row in T1 corresponds to a row in T2. Do...
Tom
September 10, 2011 at 8:59 am
GilaMonster (9/10/2011)
Fix non-SARGable predicates, add indexes, fix catch-all queries (very common), suggest application rewrites (to stop being chatty), simplify SQL code, remove cursors.
Another one that is sometimes very useful is...
Tom
September 10, 2011 at 8:41 am
If you realy mean just add another column in the output of the select statement, then you can go with Lutz' fiorst option - use a case function. this...
Tom
September 10, 2011 at 8:35 am
Came across this a couple of years late. Didn't see it when it first came out (befoe Ijoined SQLS Central). Saw it now because it's linked from Steve's editorial...
Tom
September 10, 2011 at 8:01 am
Grant Fritchey (9/9/2011)
Tom
September 10, 2011 at 6:44 am
Hey Steve, are you saying that my gebneration had no serious developers?
From my point of view, it would be moe accurate to say that most senior developers didn't got to...
Tom
September 10, 2011 at 6:28 am
You need to use a derived table to select the maximum sequence number and whatever else you need from the history, and join that derived table with the case table...
Tom
September 10, 2011 at 5:12 am
Looking at the code, one thing I can think of is that maybe you are trying to use MAX in one of the components of the union, instead of in...
Tom
September 10, 2011 at 4:11 am
GilaMonster (9/9/2011)
How many rows does that select return? 0, 1,...
Tom
September 9, 2011 at 4:33 pm
Revenant (9/9/2011)
bopeavy (9/9/2011)
FRIDAY!Beer(s)!
Wine(s)!
I'm sticking to wine this evening. No beer. Well, maybe a beer at home before I go out and head for the bar, just to celebrate the...
Tom
September 9, 2011 at 4:18 pm
Viewing 15 posts - 5,461 through 5,475 (of 7,483 total)