I'll try to explain what I want to do.


I have to get the first and the last loggin for each day, this is because I have want to know the time when the user arrives and leaves to the job. I think to do it, creating an stored procedure to evaluate the first loggin and the last and save into a new table, and my new stored procedure must be called at the Login's storedprocedure, but the problem is that I don't know which is the stored procedure to validate the login.


If someone knows it, or if someones know a better way to do what I'm trying to do, please tell me.

Many thanks in advance