Basically, you cannot convert it into true setbased code. Sure, you can probably get rid of all the looping by concatenating all of the commands into one huge variable...

Thanks for the feedback, Kevin... and thanks for the code you posted. There are only a few people who will take the time to actually do performance tests never...

I'd pretty much agree depending on...

Ok... lemme demonstrate a couple of things... first, we need some data that everyone

can use and we need lot's of it because these tests run so darned fast. ...

Well, welcome aboard, Kevin! "Set-based" is nothing more than processing sets of information instead of processing "Row By Agonizing Row" (other wise known as "RBAR"... see my tag line...

Outstanding, Kevin! Thanks for posting the code.

Yep, Matt was right... One test is worth a thousand words... let the "test off" begin. To make it easier for...

Only if you want to save the big pieces... 😀

Yep... getting ready to launch some pork chops! 😉

Kevin Rathgeber (6/13/2008)

---

Good point on the SQL 2000 vs SQL 2005. My first attempt was against 2005. I tried again against a sql 2000 database and came out...

Jim Russell (6/13/2008)

---

I was getting worried when I got through 5 or 6 pages of this thread and hadn't seen Jeff Moden jumping in to point out that different types...

sharma (6/13/2008)

---

Thanks for ur reply..

You had changed 1,2,14,37,44 as 1,2,3,4,5

But it is host file field order only.

I have to specify sequence order? Because

i am selecting 1,2,14,37,44 filed from table (file)...

... to bring your server right to it's knee's. It took over 10 minutes to find and delete a lousy 156 rows from...

seenu_61281 (6/13/2008)

---

thanks madam..i will try this..

one more doubt..

i am using sql 2005 express.i need to insert data from a grid control in vb 6.0. The entries are being done by...

Now, I agree with THAT! That's my favorite format because it puts all of the aliases in the same position horizontally speaking AND it's the same format required by...

Bobbie Shrivastav (6/13/2008)

---

I was able to utilize the proc. This is GREAT. The only thing I had to change was to use a coalesce rather than isnull....