I finally succeed in this by using case statements.

Hi

I have faced a similar situation, it was solved when I reinstalled SP2 and restarted the system.

Hope this helps.

Thanks and regards,

Anbu

Hi

I think the following query should work. Try and let me know.

select * from customer_log where DATEDIFF(year, last_login_date, getdate()) > 1

I am not sure that this works, but anyhow, let...