i have INTIME and OUTTIME of employee , INPUT EmpID IN TIME OUTTIME 2000092 2018-05-24 09:20 2018-05-24 21:00 2000090 2018-05-21 08:00 2018-05-21 20:00 OutPut Hours(A) Starndard Hour(B) (C) Over Time(A-B) OT Rate(D) OT Amount(C*D) 11 8 3 100 300 12 8 4 100 400 i want this output in same table by sql query...Kindly guide

refer this link https://www.sitepoint.com/forums/showthread.php?644910-How-to-calculate-the-total-working-hours-of-an-employee-from-a-set-or-records https://stackoverflow.com/questions/35907459/how-to-get-the-total-working-hours-for-employees-with-sql-server https://www.sqlteam.com/articles/working-with-time-spans-and-durations-in-sql-server https://dba.stackexchange.com/questions/14661/do-you-know-an-easy-way-to-generate-one-record-for-each-hour-of-the-past-12-hour