Correct me if I'm wrong, but it sure looks like you answered your own question. Have you tried what you proposed and found that it doesn't work as desired?

The key to unit testing is to run some tests that should work, and then run some that probably shouldn't work.

For example, insert duplicate key values into a table by...

So far as I know, the difference is that OpenQuery will only connect to linked servers, while OpenRowset can connect to anything that ODBC can read, whether it's linked or...

I applied to join. Thanks.

What does sp_UpdateMailingList do? Quite possibly, the whole thing can be turned into a single command that doesn't require a cursor.

I plugged your error message into Google and what came up was a bunch of stuff about clustering. I didn't read much of it, but that might be a...

I'm pretty sure XP Home (or whatever the version of XP that isn't "XP Pro" is called - man it's been a long time since I used that, can't even...

Congrats!

Andrew Watson (4/7/2008)

---

I'm going to be self-conscious whenever I talk about work for the rest of the day :unsure:. I know I use both interchangeably, but I can't figure...

I checked over the weekend, and I don't currently have SSRS installed on my Vista machine (it's at home). If I remember correctly, even if you install IIS on...

Instead of concatenating them, do a left outer join on each column, and "where field is null" type statement in the Where clause.

Might look something like:

Update JV

Set Paid_Flag = 1...

I have to agree with SDM. Just because, in general, a clustered index on an alpha field (char, nchar, varchar, nvarchar) is usually a bad idea, doesn't mean it's...

People, don't worry about the points for it. You get just as many points (1) for joining the discussion to complain about the answer, as you would for getting...

Again with the sloppy question and answer????

The "dob" field is the wrong field. Might exist in this hypothetical database, but it'll give the wrong rows.

Also, I'd argue...

Trader Sam (4/4/2008)

---

Sequel for me too...sounds funny when I hear people say 'S-Q-L Server'.

In my experience it has been non-users that say it spelled out. Now you go and...