thanks for the legwork, Antares!

regards,

SteveR

hmmm....  well, it *was* a while ago, sometime in latter part of 2005, I thought...

Google's cache shows the main page as being retrieved March 26, 2006, and most of the...

Thank you Steve, Andy, Brian, and all the others who make this site possible. I have found it to be an amazing resource over the past several years.

Congratulations,

SteveR

QA for sure, and I agree with jwainz that PromptSQL is a fantastic and "life-simplifying" tool - I appreciate having found it right here at SQLServerCentral.com

Here's another simple tool that...

Steve - could you elaborate on your "I hate temp tables" statement? ... is it because of problems with locking, or are there other reasons?

Thanks!

SteveR

Thanks Mike!

If every article was as well-written and had as good examles as yours, I'd be an expert on everything.

Seriously, you took an important topic and shed more light on...

THANKS!!! to both PW and alzdba for your suggestions! (and overnight, while I was sleeping, no less! 🙂  )

I tried two things that both worked:

 1. I created the temp table...

There's an interesting blog at http://www.rightwingnews.com that's a bit too, well, right-wing for me - but I check it every once in a while because the blogger, John Hawkins,...

Well, I've been using Query Analyzer since 1998 and never knew this trick, so I'm very happy!

Things like this can be extraordinarily useful to people who aren't aware of them....

"...Just wanted to see if anyone considered using ms access pass through queries to eliminate the translation overhead caused by access odbc to sql server?  I would recommend this method...

Good article, as always, Andy!

Since Access 2000, I've been a big proponent of using Access Data Projects (adp's) when possible - there's less "plumbing" between the query designer/form/report and SQL...

>>and suddenly seeing everyone carrying a Nintendo box home around Christmas....<<

Sorry - it was the Atari VCS - my brain somehow skipped about a decade and a half! The Atari...

I'm too old (and too uncoordinated anyway) to have grown up with video games - I remember working in Manhattan in the early 80's - my early 30's, and suddenly...

Good on ya, Steve! I agree heartily with your positive image of BillG. So much so, that I wrote this blog post last year:

http://therosenblog.blogspot.com/2004/10/happy-birthday-billg.html

BillG will turn 50 years old on...

Thanks!  I probably shouldn't admit this, but a few years ago, my wife & kids bought me a karoke machine. Some time later, I got a CD-G with "Secret Agent...