Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare
- @final int,
- @hrs time,
- @late_time int;
- SELECT @late_time = (SUM(Break_TB.Break_Time)+SUM(Break_TB.Late_time)) from Break_TB where User_Id='NSK-1007' and Status = 'Approved';
- SELECT @hrs = convert(varchar(8),dateadd(ms,datediff(ms,log_tb.First_Login,Logout),8),114) from Log_TB where User_Id='NSK-1007';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement