Akhter HUssain

Akhter HUssain

  • 1.2k
  • 702
  • 13.2k

Sql query need to develop

Jan 4 2019 12:44 AM

I have table in which INTIme and OUTTIme are coming in a column now I want procedure in which

I want that to separate INTIME and OutTime into separate columns then hours difference will come from INTIME and OUTTIME ,

Duty hours define in Employee table will pick from employee master file table.

Day will be calculated if Hours will be equal to Duty Hours and greater then duty hours ,day will be = 1 

OT Hours will come from Hours minus Duty Hours,

OT Amount will calculate, if Employee entitled for availing OT In employee master file then their amount will be calculated otherwise OT amount will not be calculated.

Answers (3)