I'd say the proc isn't holding the value of the tab correctly. I've seen that kind of thing happen. You might try replacing the input value with the...

You're welcome. Let us know how it works out, okay?

This requires a Numbers table. If you don't have one, you can either look up how to create one, or just ask and I'll add that to it.

create table...

Mangal, the only reason yours shows as 1% is because it's estimating that it will only return 2 rows. It's like a UDF, SQL doesn't know what it's going...

Use "In" instead of "=".

Update person

SET Town = 'TLI'

Where Extension in ('7854121', '7856121', '020523')

Does that help?

jcrawf02 (3/6/2009)

---

To you, Chris, or to someone who knows that they're doing. ...

Your connection string can either have a specific username and password in it, or it can use integrated security (Windows security). I haven't set one up in a while,...

I answer a lot of basic questions pretty much every day. Honestly, those are what most people need most of the time. And search (Google or otherwise) is...

Raising the post count, quicker to...

On the subject of unions, and to hit the cheese quota for the day and copy everyone else, just remember the performance difference between Union and Union All.

I think a...

Hans Munkwitz (3/6/2009)

---

[font="Arial"][/font]

My wish would be to have SQLServerCentral discontinue the practice of having to login when one wants read some of your articles. Having been in the computer industry...

It's going to depend almost completely on what kind of service you are providing with that.

For example, it's a big difference if most of those 1500-2000 concurrent users are constantly...

You should be able to get a Dev copy of SQL 2000 that you could use to build DTS packages for deployment on your production server. That's going to...

sql-oholic (3/6/2009)

---

FYI,

I figured out lots of things in my code.

I have created proper indexes in my tables which has reduced the execution time.

BTW,Isn't there a way to delete...

If you have two tables that you want to compare, you can join them and have the computer compare them very, very fast. Much faster than a cursor.