Advertisement
Guest User

Untitled

a guest
Mar 30th, 2015
243
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. declare
  2. @final int,
  3. @hrs time,
  4. @late_time int;
  5.  
  6. SELECT @late_time = (SUM(Break_TB.Break_Time)+SUM(Break_TB.Late_time)) from Break_TB where User_Id='NSK-1007' and Status = 'Approved';
  7. 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