Viewing 15 posts - 2,236 through 2,250 (of 2,443 total)
but at least it's semi-consistent.
Seth Phelabaum
--------------------------------------------------------------------------------
Consistency is only a virtue if you're not a screwup.
lmao, nice turn of phrase - forgot about your sig, didn't ya? 😛
---------------------------------------------------------
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 24, 2008 at 11:43 am
Jeff Moden (11/23/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."
November 24, 2008 at 10:01 am
Chris Morris (11/20/2008)
It works like this. For two equal strings, say @mcode= '0011246';
Split c.TheValues into chunks (tokens), and test each one to see if it appears anywhere in @mcode. 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."
November 20, 2008 at 7:54 am
Chris, not following the phrase 'token matching' - looks like you're calculating a percent match based on the values in the table versus your @mcode, so I can see four...
---------------------------------------------------------
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 20, 2008 at 7:27 am
David Reed (11/18/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."
November 18, 2008 at 11:54 am
Yes, it is missing stuff, I was considering only 'continuous enrollment' during the timeframe for which we had member experience, (i.e. the member's first enrollment to their last disenrollment, were...
---------------------------------------------------------
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 17, 2008 at 1:10 pm
Seth, finally had a moment to look this one over, and had a couple of questions/comments:
When I run it as posted, memID2 is not captured, but should be.
As I...
---------------------------------------------------------
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 17, 2008 at 11:53 am
more and more I think the way you present yourself, and your track record online, will have a huge impact on your changes of employment.
While I agree with you, and...
---------------------------------------------------------
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 17, 2008 at 10:01 am
jpowers (11/14/2008)
Anonymous post #1:
Hello Steve,
Let’s not forget that as “Knowledge Workers” – we carry our brains around (most of us anyways) 24-7.
That means that, when we are commuting,...
---------------------------------------------------------
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 14, 2008 at 10:46 am
Andy Warren (11/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."
November 14, 2008 at 6:28 am
please see the link below to help us figure out what's going on. Sample DDL and data will help us to solve your issues faster.
Thanks,
Jon
http://www.sqlservercentral.com/articles/Best+Practices/61537/
---------------------------------------------------------
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 14, 2008 at 6:19 am
I think you lost me here:
Here I am trying to achieve the same without storing data in temp./staging tables.
First I am creating a temp. table wih 2 rows
---------------------------------------------------------
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 14, 2008 at 6:00 am
Wow Seth, thanks. I'll have to puzzle over that for a bit, had to read it a couple of times. Updating a variable before you set it (in 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."
November 13, 2008 at 2:33 pm
Thanks Gail/Matt - now that I've read this thread, gotta go fix 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."
November 13, 2008 at 9:47 am
Ok, I'm not sure exactly what you mean when you state you are 'iterating over the temp table', so please correct me if I'm misinterpreting.
From what I understand,...
---------------------------------------------------------
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 13, 2008 at 9:44 am
Viewing 15 posts - 2,236 through 2,250 (of 2,443 total)