Try this and tell me if it produces what you need!

SELECT feature_id, feature_text, feature_sequence, feature_date

FROM XYZ A

WHERE feature_date = (SELECT MAX(feature_date)

   FROM XYZ B

   WHERE A.feature_id = B.feature_id)

Thanks for that David and Mary. Both options work well.

Thank you.

I feel emabarassed! You know when you have been coding all day and your brain starts to slow down late in the afternoon? I get that often!

How big is the Table? How many Rows?

The query optimiser should choose to use an index for col_a. If there is no Index on col_b then obviously an Index cannot...

I believe what you are needing is the "SET TRANSACTION ISOLATION LEVEL SERIALIZABLE" at the beginning of your Stored Procedure. By doing it this way, you are preventing anyone from...

1) Have a look in BOL for an explanation under "Image data type\text, ntext, and image Data. This will give you an explanation as to how Image & Text fileds...

Ok. I understand now.

So would it be correct to say that operator precedence is never an issue until an OR condition is used?

You could just create a DTS package for it! In DTS you have the option of storing a result set to a text or csv file!

Please have a look in BOL under "WHERE clause, predicate". This is where I'm basing my info from.

My 1st option is doing BETWEEN, AND, NOT IN

My 2nd option is doing NOT...

I think I may steered everyone down the wrong path except for rhunt. I'm talking about opertaor precedence not perfromance!

BOL says that NOT comes first then AND followed by BETWEEN....

The data integrity in this Database is up to sh*t. That is why the StartDate potentially has a NULL value.

I have just tried your solution and it works.

Thanks.

My apologies, I was refering to dynamic sql!

Yes you can! Have a go and you will see!

PW,

You may have missed my question due to the amount of new threads. When you get a chance, could you please answer?

Let me get this right, for the following records below for ROODVELT, What your saying is that the t1 has the forst record with a sequenceid of 1 and the t2...