Viewing 15 posts - 346 through 360 (of 379 total)
Jeff Moden (4/6/2009) The first rule that many developers seem to omit is that the code actually has to work. 😉
OK, you got me there!:-P However, I was referring...
April 6, 2009 at 7:42 am
I also got this wrong because I thought that the second choice would also result in a null, so I expanded on the code a bit to test each condition:
DECLARE...
April 6, 2009 at 7:29 am
David Walker (4/3/2009)
April 6, 2009 at 6:48 am
But, done properly,
make the query rather self documenting.
No. NO!!! NO!!!! The table name itself is the most accurate representation of what's being joined. ...
April 3, 2009 at 3:01 pm
When you go to a toolbox, not the one in your IDE but a real one that holds a wrench, hammer, screwdriver and the like, do you pick up the...
April 3, 2009 at 2:12 pm
katedgrt (4/3/2009)
April 3, 2009 at 12:54 pm
Jason Miller (4/3/2009)
I guess I'm strange, I prefer an language/environment where explicit definitions are required.
I couldn't agree more. While it may be a pain to type in the "extra"...
April 3, 2009 at 8:35 am
I think it all comes down to a paradigm. Folks who spend most of their time in an object-oriented environment tend to think in those terms. The same...
April 3, 2009 at 7:07 am
My dad always told me that too much of anything, even a good thing, can be bad for you. I can't think of any example that is more applicable...
March 30, 2009 at 6:48 am
It's about 25 UDF/SP files and the dependencies are not always direct. While I really wanted to have a "click it and forget it" approach, I just may have...
March 25, 2009 at 7:02 pm
That allows one to execute a SQL file from a .BAT file (requiring a connection to the database for each file), but what about within an existing SQL file that...
March 25, 2009 at 4:39 pm
J (3/17/2009)
March 17, 2009 at 8:02 am
I agree with the earlier statement that the choice of a procedure named "GO" was a red herring. That has NOTHING to do with the GO separator. The procedure...
March 16, 2009 at 1:10 pm
I think you're getting those scans because of the ISNULL clauses. You could try an OR where you check for each of the values independently, but that still might not...
February 19, 2009 at 9:13 am
The ad-hoc query shows an estimated 697 rows from the att_patient table, while the function shows just 1. Which sounds more correct?
The 697 is more correct. Dave posted the...
February 19, 2009 at 8:47 am
Viewing 15 posts - 346 through 360 (of 379 total)