If by "quirky update" you...

It's difficult to understand what you have problem with when you only describe the query rather than showing the code.

But the query you posted can be simplified by adding another...

I assume that you mean set-based iteration. That is by no...

Unfortunately, this is one of the drawbacks with working set-based. If you insert rows one a time, finding the bad data is trivial. But that is of course far less...

Visit the persons and interview them to...

You are at a site which is devoted to SQL Server, but it is not apparent where SQL Server comes into play here. Maybe it is a Sharepoint forum you...

My head spins...

If I understand it correctly, you have a table with bit values and you want to make some sort of comparison, and you think that a varbinary(MAX) is...

When I said INSERT statements, I did mean INSERT statements. That would have given you a tested solution. This is an untested solution to what I think (i.e. guess) what...

Kind of? One thing is for sure. If you don't know what you want, chances that we will know are slim.

In any case, please post the CREATE TABLE statement for...

dwain.c (9/2/2013)

---

I managed a way around the missing triggers but I did not notice that INDEXes were not included. I didn't see any dialog that would have allowed selection...

There is a wee bit too much information missing in your post. I don't even see where the trigger would come into play.

As a start can you post the CREATE...

Assuming that there are tables defineing the Categories and AreaCodes, you can do this:

CREATE TABLE #teammap (Category char(1) NOT NULL,

...

Either you specify the password at the prompt, or you use the -P option.

Not sure what you mean. When I run the batch you posted and my query, I do get the same results from both queries, no matter whether @match is 0...

I don't know your application, so I can only make speculations. Nor do I know why think you actually think this is a problem. That is, my assumption is that...