Hi,

Thank u 🙂

i think i will go with below query :

DELETE TOP (10000)

FROM Test_sprt_chat_log_archive

WHERE DATEDIFF(Day, logged, getdate() ) > '365'

and schedule job for this query.it will be more efficient...

thank u for your reply 🙂

i have written another logic to purge data from two table at each execution of job.

query written as follows :

Declare @cutOff datetime

select @cutOff...

Thank you all for your reply..

but as the table which i want to purge contains 2 million records ,the procedure which i written taking so much time.. and face...