Viewing 15 posts - 2,266 through 2,280 (of 2,443 total)
Lowell (11/3/2008)
WHERE ISNUMERIC(SOMEVARCHAR) = 1
but as others will tell you, it's not 100% reliable, because of the way it is structured; for exampel
select isnumeric('1E2')
select...
---------------------------------------------------------
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."
November 4, 2008 at 5:59 am
Politician AND a manure spreader - http://www.tomlynch4supervisor.com-a.googlepages.com/pastisprologue
By the way, what's the second half of the title?
"Life is like a manure spreader" . . .
. . . If you're 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."
November 3, 2008 at 1:58 pm
rbarryyoung (10/26/2008)
rbarryyoung (10/9/2008)
Jeff Moden (10/9/2008)
True enough... but have you ever see it used for anything other than a delimiter? 🙂I've seen it used for emoticons-> :Þ
Jeff Moden (10/9/2008)
---------------------------------------------------------
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 27, 2008 at 8:35 am
ggraber (10/27/2008)
Jack Corbett (10/26/2008)
Fraggle (10/26/2008)
However, to my knowledge, SQL Saturday are Florida only.
Actually SQLSaturday is NOT a Florida only thing. There have been SQLSaturday's in Washington state,...
---------------------------------------------------------
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 27, 2008 at 8:32 am
ChrisPapps (10/26/2008)
---------------------------------------------------------
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 27, 2008 at 8:13 am
Stephanie J Brown (10/26/2008)
---------------------------------------------------------
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 27, 2008 at 8:12 am
John Rowan (10/21/2008)
---------------------------------------------------------
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 21, 2008 at 9:48 am
Andy Warren (10/20/2008)
No one going to pick on the violinist? Hard not to understand his point, but no points for gracefully accepting a little adulation.
lol good point, but what do...
---------------------------------------------------------
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 21, 2008 at 9:44 am
K. Brian Kelley (10/20/2008)
---------------------------------------------------------
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 21, 2008 at 9:41 am
Eric Klovning (10/19/2008)
http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/
From a technical standpoint it works well as a script distribution mechanism but I doubt we have realized much in...
---------------------------------------------------------
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 21, 2008 at 8:53 am
Not sure if this is going to be extremely helpful, but it might reduce your dataset a little. Rather than listing 401.1,401.2,401.3, etc as hypertension, just look at the...
---------------------------------------------------------
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 16, 2008 at 8:58 am
MrBaseball34 (10/15/2008)
jcrawf02 (10/15/2008)
Can you de-identify the data to meet HIPAA reqs? John/Jane Doe and scramble the id numbers or something?
I will try but there are 340,000 ptEncounter records, 610,000 ptDictation...
---------------------------------------------------------
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 15, 2008 at 4:13 pm
GSquared (10/15/2008)
Matt Miller (10/14/2008)
---------------------------------------------------------
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 15, 2008 at 1:34 pm
Can you de-identify the data to meet HIPAA reqs? John/Jane Doe and scramble the id numbers or something?
---------------------------------------------------------
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 15, 2008 at 12:14 pm
jpowers (10/15/2008)
Steve Jones - Editor (10/15/2008)
---------------------------------------------------------
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 15, 2008 at 10:17 am
Viewing 15 posts - 2,266 through 2,280 (of 2,443 total)