Vinit,

1st add a new column as ModifiedDate in your table and update all past records ModifiedDate values as you wants (Any Last date).

Then again come to design of ModifiedDate...

Abhijit,

just give a short explanation of your topic, so it will be more clear to all.

Cheers!

Sandy.

Nice...

Really helpful..

Good job..

Jeff,

you can achieve this by making a sub query followed to you another delete statement or same delete dml as per your requirements like this:

where MessageID

in

(select max(MessageID )...

Amy,

you can try this..

1- SELECT count('x') from ViewParameters where DVTFlag = 'Run'

2- SELECT count(*) from ViewParameters where DVTFlag = 'Run'

if you wants to count later then use this:

select @@rowcount

Cheers!

Sandy.

Ankit,

As far query concern your sql query is correct, what I feel just modify the comment line by using "--" instead of "//" and Comment the return statements too by...

what is your question?

Cheers!

Sandy.

ok,

Cheers!

Sandy.

Grant,

As you suggested to my topic that CLR is an option to achieve this, I do agree. But as per my concern, its not possible in TSQL even in SQL...

so, what you are trying to say??

Cheers!

Sandy.

Vikas,

what is your exact requirements....??

I would prefer to go with 1st option if the update statement doesn't require more condition wise update.

Cheers!

Sandy.

gail,

thats what i am trying to ask you, how to find out all these..

Cheers!

Sandy.

gail,

just few days back, I come across one query where i noticed the query is going for index scan when there is more result and same query also performing...

gail,

A hearty thanks to you, I just expected this answer, what you just now explained here. It may be possible in .NET integration(CLR) but seems not to do with SQL...