AKM,

We have done exactly that. After toying around with different suggestions other people posted on different forums we came to the conclusion that it will never do what it should...

This is not the case, though, in .NET. Even when you destroy an object (by disposing it if it supports .Dispose, or setting it's value to Nothing) the object does...

Thanks so much for all of your replies.

I am going to try some of your suggestions, Goce, and see what happens.

Even changing it to UNION, it still takes 2-3 seconds to execute with only the UID field, the same as with the OR.

That is exactly what my query looks like, with the exception I am using "UNION ALL". In any case, it is doing 2 Index Seeks. Sorry for the misunderstanding saying...

It is now doing an Index Seek, and no Bookmark lookups anymore.

The web page doesn't use all 63k in its output. What this stored procedure does insert all of the...

Also, the query takes 8 seconds to run when I add the rest of the fields to it. Huge difference.

The UNION did nothing at all for performance -- exactly...

That is correct. I simplified the query for posting just to make it easier to read. There are about a dozen more fields that really get inserted into that tabla...

Thanks for the link, Frank.

leightonsimsaj - NewID() is a function, not a column name.

Thanks so much for the reply. Seems to work great. I had never even heard of SCOPE_IDENTITY.. Am now changing all of my stored procedures that use @@IDENTITY over to...

No.. not searching for that, a5xo3z1. Was hoping there would be a way to do it in the regular view. Would be nice for tables and such also and stored...