Thanks rookie

There is as such no criteria in our case to decide which one to delete or which one to keep having say empid 2, what we want there will...

Thanks for your reply

I know the 1st delete query you have written to delete last two rows... actually my question was not clear I have just given an example of...

It returns yyyy-mm-dd hh:mi:ss(24h) format

2005-08-18 00:00:00 formdate  2005-09-19 00:00:00 todate

I have posted a part of sp here and there are other clauses as well so I need to make...

When I modify this as above it gives me following error

"The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."

I need to...