5 minutes ago, musicmaster said:You might consider to put all the employees in the employee table as "inactive".
Ok that is a great idea. But, I forgot to mention, I don't want to write script using sql like above because it has sensitive information about db login. I mean is there alternative way other than changing the database table ? If no way I think setting the employee table as inactive is the best idea.
.png.022b5452a8f28f552bc9430097a16da2.png)