Why would you need a cursor? It sounds like a simple INSERT... SELECT DISTINCT... will do the job nicely in a single step. Avoid cursors any where and every where.

Well, not to give competition to Steve... OK, it won't, but there is

http://www.sqldumbass.com

And that's why we've only had to do the FULL SCAN in a few places and on a somewhat irregular basis. Most indexes, most of the time, if they were...

Sweet. Nice security. No one will ever know that we're running everything off an Access DB

Now that I'm thinking about it (and I'm also asking around) unless the database is only a single filegroup, it's unlikely that it would show up as an actual locked...

Ooh. I hadn't thought of that.

It wouldn't show up as a database lock though, would it?

There you go...

I was at a meeting of our town Board of Health this week (they're trying to pass regulations on Outdoor Wood Furnaces). One...

Hrmmm...

Unless this is the only table in the database, I'd be really shocked to see a database lock based solely on inserts to a single table. I'm guessing there's a...

So I guess the guideline should be don't publish anything that can be linked to you that you wouldn't want published in the newspaper on the frontpage with your name...

If TypeID and LangCode are the PK's that are meant to be used to link to the Object table (parent to child), then the Object table needs to also have...

Last comment. If you google my name the first result is The Jack Corbett Guide to Topless Clubs, which is NOT me. You get me as the 5th...

Once you pass a certain number of rows, the engine has to lock the table to be effecient. There's no getting around that fact. So, instead, you have to look...

It's just a chapter out of a larger book. The information is likely to be good, but it could be pretty light.

I'm honestly mixed on this one. On the one hand, it's none of HR's or the company's business what I do in my off time. On the other hand, participating...

Hey Jack,

You know, I do forget about that threading thing. Holdover from the days of 2000. I will say, it still doesn't work quite like having multiple connections from multiple...