Sorry, I should have been more clear, as both run in under 1ms.

In regards to the cost versus quantity of use argument that you have presented, I agree, both need...

I think you'll find that the difference between 1ms and 1ms is pretty negligible. Feel free to test for yourself.

What boundary would you set for flexible coding versus running...

I think I have a different take on this situation.

In looking at the initial code presentation, well frankly, why loop if you don't have to? And if we can...

I don't know why I didn't think of this last week, but the problem (in my case) was in the database compatability level. I was working in an old...

I get the same error with an English install of 2005 Standard.

I have not been able to find anything on the problem...

@matt-2

I think you'll find that if you want to do a "true" (well not true, but closer than it was) "right sizing" of the comparison, then you'll need to make...

Hopefully this will be more helpful thank my silly reply earlier...

You'll need something like:

SELECT * FROM dbo.Users

WHERE Id NOT IN (

 SELECT DISTINCT U.Id

 FROM dbo.OrderItems OI

  INNER JOIN dbo.Orders O...

My apologies.  You are correct.  I responded too quickly and with out reading your second post well.

Unless I am missing something, the fix is simple to make.  Just move your NOT IN arguments into the JOIN clause.

Select * from sometable inner join sometable2 on 1.id =...

Stephen,

Looking at your search arguments, I find that you are going to get two types of return records:

(mb_member_type.mbt_code = N

"poser vault" ... LOL

Unfortunately, PowerVault can refer to a few different products.  The external, direct attached SCSI options can provide very good performance, but as with any direct attached you'll...

@DAB

The NAS of today is much better than the NAS of yesterday.  That may sound corny, but it is very true.  Like you, I have worked with SANs for some...

FAST_FORWARD is FORWARD_ONLY and READ_ONLY together.

All of this seems like a lot of work to replace a cursor in a row by row process is needed.

Why is it that people don't seem to understand that...

Glad that is working for you Hemant.  I must be honest though, I am suprised that inserting 10 records would take that long.

I would verify that you have appropriate indexing...