Thanx for the info.

Would you care to answer my previous questions as they will help me point you out to the best possible solution instead of listing 'em all.

Also does...

How much data is there in the table?

How much do you plan to delete/keep (pourcent (%))?

Do you have a window to do this?

What position did you interview for?

http://www.connectionstrings.com/?carrier=sqlserver

Next question was how can I do this.  But expected answer is you can't unless you are a moderator or admin .

Thanx for the...

All this code is accessible only from inside a trigger

Select * FROM Inserted >> new data (inserted or updated)

Select * FROM Deleted >> old date (updated or deleted)

Will this post be a permanent warning or will it fade off like any other posts?

Ya there are loads of faster way to make this convert, I would choose of of those VS reply 1.  Not that it's wrong but I feel it's just too...

Replace the double quotes with single quotes.

Or do it in a trigger.  That way you can send a more detailed error message.

Alright, I guess this one is somewhat out of our hands !

Thanx for the feedback, but don't you mean this :

SELECT 

  s.Key

 FROM Sub s inner join Main m on m.key = s.key

 WHERE  s.key IN

    (Select Key from Sub where Closed = 0 group...

Can't say I have any other ideas... What else did he propose?. Let us know how that turns out.

Using the ors, the server has to assume that all rows may have to be returned.  The fastest way to do this is using a index scan.  When using dynamic...

, can't believe I missed it too... I guess it's been too long since I wrote this kind of code manually.  Looks like I...