While I remember my own phone number, it's surprising how many others I don't know. Most of my friends are in the phone and I have no idea of what...

I'd use two different versions of the script, one for each SQL Server version, especially as the 2000 one might not work in 2008. Just return the same values so...

http://www.sqlservercentral.com/articles/Integration+Services/61619/

We don't have that, but we do have "Recent Post" above and "Active Threads" that show you what's changed since your last visit. With that you could log on, then...

William, not right now, but I'm considering turning the forum search back on.

If you pick the Active Threads on the left, that will get posts since your last visit. I usually scan for those with 0 or 1 response.

You can also pick...

Chris,

I can do that. We're in the midst of sorting the feeds out, so I've been waiting for that to change before I move things around, but I can easily...

OK, bring the ice back, clear, preferably Vodka ice and not black ice, and we'll trade!

Barely got out the driveway, so my prayers for the day were answered by 4L

PK doesn't do either. It doesn't help with speed or with inegrity. It tells you which column identifies data. You can set your unique index column to be the PK...

Do both people share the same employeeID? If so, then something's wrong. If not, then the WHERE clause is filtering it out.

The left join returns something like this:

1 ...

It sounds like corruption or perhaps a problem with the syscomments table.

My guess is DF_Serial_HQID" is a default on the table. If you check the table in SSMS, look for...

That could be it and if so, that's definitely a bug.

I'll try to check. I'm here so often, I've never paid attention.

Thanks for the visits, though 🙂

You need to better frame the question. What exactly about job opportunities are you asking?

My computer, Properties. Should give you the CPU type. Google that.

Hey, could make sense for consistency, all xxID columns as PKs.

I'd agree it's a waste of space, but you'd tinyint the StateID and it's not that much space, 50 bytes....