It looks like some custom message generated via application.

Look at the error logs for actual error. Also, have you tried the user (your application user to connect directly to...

Perfect. Thank you very much. Looks good. These columns are part of a very big table but fortunately they are indexed.

I checked this in our DB and it took 6...

Yes.

I am very sorry. You are right . Client Id 1 qualifies all the criteria.

And thank you very much again for taking time on Saturday morning for helping me out..

I am very sorry, for not being clear.

Let me try again..

--All

insert into TestPurgeClient values(1,72, '2013-03-18 00:00:00.000')

insert into TestPurgeClient values(1,33, '2013-02-16 00:00:00.000')

insert into TestPurgeClient values(1,34,'2013-01-17 00:00:00.000')

-- 60 day + Current

insert...

Yes. The issue I am facing that one client may have multiple create date & multiple activities, and I have to check that even if client falls with in that...

Thank you very much for your kind response. For this case it is working fine. But in this SQL activity ID is not taken into consideration at all and that's...