I'm with you...

Not directly, as SL Server does not allow you to use a stored procedure like a table. You will need to load the output of the stored procedure into...

Actually, nothing to apologize for there. Sometimes that is how you get help for problems you are facing. Someone mentions something in a thread that triggers a request...

Thanks Jeff. I should have figured that one out, but then I only worked for a Conference Call company for 2 months (contract job) before getting the position I...

It could just be me, but the world is full of acronyms especially TLA's. What is CDR? Not the code, the acronym.

As I am not commuting between Colorado Springs and Denver anymore (did that for 15 years), most of my driving today is city based, so the hybrid would be useful...

The hybrids aren't necessarily that great. I had a 1990 Ford Fiestiva (4 cylinder engine) that got 50 mpg. I also had a 1993 Honda Civic (4 cylinder...

NEI (Not Enough Information). What differences are you looking for between the tables. To help you, we really need to have the DDL for your tables, some sample...

Jeff Moden (11/27/2007)

---

Jason Selburg (11/27/2007)

---

Lynn Pettis (11/27/2007)

---

Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse...

Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse to water...

😎

Maybe, but I also think it is a valid question. If asked for help in SQL 2005, why would I write something that would also work in SQL 2000...

Jeff,

Same here actually, but I'd work on one with test data in tabular format before one that has no test data at all.

I also go for the ones with "this...

My question to you is this, why are you looking at SQL 2005 solutions in SQL 2000? This doesn't make sense to me. If a person is using...

Having the test data in a ready to use format is great, but even if they provide it in a tabular format, it is better than nothing. I use...

Very good article Jeff. Unfortuately, as others have mentioned, those who really need to read it won't, and if they do, they probably will ignore the advice.

😎