if(diff= 08:00:00) Set status = 'p' else set status ='A' & inpunch= NULL,Outpunch = NULL
IF DATEDIFF(hh, @starttime, @endtime) = 8 BEGIN --true part END ELSE BEGIN --false part END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)