Viewing 15 posts - 196 through 210 (of 2,443 total)
report logic might have a slight flaw. I get why you'd do this for ER visits over midnight, but what if the patient comes in on Friday at noon, goes...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 4, 2012 at 6:44 am
David Cuthill (10/1/2012)
In answer to your question: yes. Are you asking for help? If so,...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 1, 2012 at 3:28 pm
David Cuthill (10/1/2012)
The author is made to appear ignorant of their own...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
October 1, 2012 at 5:32 am
Kiara (9/28/2012)
Grant Fritchey (9/27/2012)
THREADIZENS!Who is going to make it to any of the SQL in the City events coming up in the next week+?
I'd be at the Chicago event, except...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 28, 2012 at 1:36 pm
I wasn't saying it can't be done, I was saying you're doing it incorrectly.
IIf() works off of three values, Test, True and False. You're feeding in a fourth value,...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 28, 2012 at 1:33 pm
Kinda rough suggestion, I realize it, but basically Why Bother?
Install SSMS Tools Pack (free) or buy RedGate SQL Prompt.
Works lots better than Intellinonsense.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 28, 2012 at 8:57 am
Change all objects into a new schema, then see who complains and transfer those back...
(clarification: that's a joke)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 28, 2012 at 8:49 am
Ignore Jeff, he has a beard. I, on the other hand, actually OWN a Gillette. I would imagine taking part in Open Source also keeps Microsoft's ear to the ground...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 28, 2012 at 8:47 am
Not sure exactly what you're evaluating, but looks to me like you have four arguments in the IIf() function, when it only accepts three.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 28, 2012 at 8:43 am
Ray K (9/20/2012)
jasona.work (9/20/2012)
Rob Schripsema (9/20/2012)
Cliff Jones (9/20/2012)
SQLRNNR (9/20/2012)
Daniel Bowlin (9/18/2012)
Woah!Nelly
deli
dilly-dally
procrastinate
procreate
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 20, 2012 at 12:40 pm
SQLBalls (9/20/2012)
At this level it appears that way, but when you get...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 20, 2012 at 7:43 am
Bob McClellan-320407 (9/20/2012)
Great Article.I am also interested in John Mitchel's question...
"Are elements and attributes functionally equivalent? "
tia,
Bob
John/Bob, while not an expert, I would have to say no, they are not...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 20, 2012 at 7:42 am
Eugene Elutin (9/19/2012)
Jeff Moden (9/18/2012)
Eugene Elutin (9/18/2012)
Please ignore this stupid remark!Easy, big guy. You're right but that's something that he would say. 😉
I've spent 5 minutes to choose...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 20, 2012 at 7:12 am
crookj (9/19/2012)
Aarrrrg. Ye scurvy Dogs! 😉
Morose (I've just been informed that not only was it Talk Like A Pirate Day yesterday, but if you dressed like a pirate, you...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 20, 2012 at 7:04 am
L' Eomot Inversé (9/18/2012)
Evil Kraig F (9/18/2012)
Does EXCEL handle that many columns? I didn't think it did (well, reasonably anyway) but I've certainly been inaccurate before.
No, it doesn't. ...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 19, 2012 at 4:56 am
Viewing 15 posts - 196 through 210 (of 2,443 total)