Viewing 15 posts - 361 through 375 (of 392 total)
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
Thanks for the explanation. Apparently, recalculating the statistics did wonders. The function executes now!! :w00t:
Still, I'm going to investigate the index issue. While SourceID is indeed on...
February 19, 2009 at 8:39 am
I can certainly see your concern about this:
WHERE R.MedGroupID = ISNULL(@MedGroupID, R.MedGroupID)
But I'm not sure what else I can do to allow the MedGroupID to be specified yet if it's...
February 19, 2009 at 8:19 am
The commented lines are what I used to change it from an inline UDF to a multi-line UDF. You're correct in that it did not solve the problem, so...
February 19, 2009 at 7:54 am
Viewing 15 posts - 361 through 375 (of 392 total)