Nisha, it depends... is the code for high hit ratio GUI code or is it for batch code that runs every once in a while?

SELECT/INTO hauls butt in any DB but it runs like an ape that sat on a hot coal if you use it on a database that is setup for anything...

Heh... WELLLLLLLLLLL!!!!!!

I'm pretty sure all you need is one select per column per table. It there where some rhyme or reason to the table names you

wanted to attack, we...

Ummm... I gotta say, "Not always". I've used temp...

Nicely done... there are a couple of things I do exactly the opposite of you, but if I were working in your shop, the rules you wrote are pretty easy...

Ok...when a shopper logs in, what are the key field(s) that are looked at in the "old" table? Also, how long is it currently taking to validate the shopper?

Thats one of the better ideas, Ralph. It takes 25 ms duration, 15 ms CPU time, and 214 logical reads.

The update method I showed, as long as it looks,...

My thoughts, exactly... next question would be... when is VARCHAR(MAX) in an "in row" condition? I'm thinking the answer, unlike the TEXT datatype can be forced to be, is...

Well... maybe a little evil 🙂 It is a good "tie breaker" question.

That's what "index tuning" is all about... getting the columns in the correct order to produce an Index Seek. Nice job.

You would use a cursor and while loop instead of a set based solution?

Whew. Ok... just wanted to make sure.

Mr. Corbett... keep that up an I may have to find some...

Heh... maybe so but I like that attitude. Why is there always enough time to do it again but never enough time to do it right the first time?...

newbie (3/5/2008)

---

i've got the bracket or end-of-file issue resolved, however now I have this issue:

As stated previously, my bulk insert sp inserts records into a table from a txt file....