Viewing 15 posts - 5,461 through 5,475 (of 7,484 total)
CELKO (9/11/2011)
September 11, 2011 at 3:01 pm
Good easy question.
I got it wrong because I am not case-sensitive when scanning SQL :blush::laugh:
September 11, 2011 at 2:47 pm
mattech06 (9/11/2011)
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...
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...
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...
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...
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...
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...
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...
September 10, 2011 at 8:01 am
Grant Fritchey (9/9/2011)
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...
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...
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...
September 10, 2011 at 4:11 am
GilaMonster (9/9/2011)
How many rows does that select return? 0, 1,...
September 9, 2011 at 4:33 pm
Viewing 15 posts - 5,461 through 5,475 (of 7,484 total)