Thanks. I am going to have to play around with this.

I am planning on using your suggestion. Frankly I don't know how I didn't see that in the first place.  Would this type of selection run efficiently? Am I better...

Thanks. I just replied to your initial post about a minute ago.

Thanks. Scott had a similar idea. It's one that I had never crossed my mind.

Yes. Everything is under my control.

Something about option 2 feels wrong. I suppose that comes from an old boss and a database seminar that I went to. They said that...

Let me answer your questions first. A vendor cannot be added. A task is considered incomplete until all vendors have updated the system to say that they are done.

Your approach...

I hear you Steve. I have always used the full address. In the case of the app that I am building. It will primarily run on a phone. Therefore I...

My thoughts as well. Since my app is going to be primarily on a phone and the address isn't used for anything other than an FYI and to make an...

Thanks for the advice.

Thanks for getting back to me. I had considered the points you are making. And for those reasons I normally do as you suggested. This is the one application that...

There are no indexes on either field. I am going to create a query plan to see the results. '

I originally asked the question because I have a vague recollection...

Thanks. I will do what you suggested.

Thanks Jeff. You are 100% correct. I always put an ID column on tables without giving it much thought. In this case I clearly don't need it.

Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I spoke...

That's a given. I always do as much work as I can on the server. The question is whether to have the stored procedure do a join to obtain all...