Jes Sie

Jes Sie

  • 698
  • 1.2k
  • 262.6k

SQL Server Automatic Update

May 16 2018 11:28 PM
I have several online registered users in my web application but only less than 20% of them uses the system. 
 
My question is, how to query in SQL Server that will automatically update the value from active to inactive if the last login of the user is 3 months ago or none at all?
 
Thanks for your help. 

Answers (1)