lmao, nice turn of phrase - forgot about your sig, didn't ya? 😛

Jeff Moden (11/23/2008)

---

Man, I'm with Jack... use 2 or 3 part naming in the FROM clause, add aliases, and then use the aliases everywhere else. Done properly, it makes...

Chris Morris (11/20/2008)

---

Hi

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...

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...

David Reed (11/18/2008)

---

Speaking from experience, it can be tough to fight off the whispered self-justifications for unethical behavior, especially when you feel taken advantage of by management or the company...

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...

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...

While I agree with you, and...

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,...

Andy Warren (11/14/2008)

---

It's easy as an employee to say that you don't want to be measure on hours of productivity but only on tasks completed. The problem with that is...

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/

I think you lost me here:

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...

Thanks Gail/Matt - now that I've read this thread, gotta go fix something . . .

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,...