Do you mean a solution similar to what David is suggeting above?

Thanks Craig.

This looks interesting; will explore further more.

Thanks for the response.

Thanks for the response David.

But I don't really need the MAX value. Instead, what I am looking for is to get the most recent value of any of the properties.

"OOOOOPS"!...

Provide the following:

1. object creation scripts

2. sample data

SELECT *

FROM @sample s

WHERE s.ADM = @adm

AND ((s.RAD IS NULL AND @RAD IS NULL) OR (s.RAD =

[Quote]

you need to be very thorough

[/Quote]

You got to be kidding, right?

This is a very generic, open-ended question; pretty hard to make any reasonable suggestions with so few details.

Having said that, here...

If you haven't already looked into it, you may want to take a look at CTEs. The following may work for you - check it out:

select *

from #locations;

with x(locationid, location,...

Absolutely!!! The operation was successful, but the patient died!

You can do this in SQL Server BI Dev Studio for certain; haven't done it in SSMS (don't think it is possible in SSMS).

1. Can you post the resultset for this?

2. From...

Fair enough; perhaps with 500,000?

BTW, I think I can visualize why the quircky update is the best - although I would like to dig deeper into this one...

Thanks for measuring...

If you have not done it already, I think you should kill my query without the index; we have established that it is not the best way to do things...

I completely agree with your assesment of my query. I thought I had made that some what clear myself when I said "with the sample dataset"; but I should've been...

How long does it take before it times out?

Can you try this:

1. Start two sessions from SMSS (record both the spids)

2. In the first session execute the DELETE statement

3. Is...