DECLARE @PDate datetime UPDATE MASTERPROCESSDAILYDATA SET Status = CASE WHEN CAST(@PDate AS TIME ) BETWEEN CAST ('08:00' AS TIME) AND CAST('09:30' AS TIME) THEN 'P' WHEN CAST(@PDate AS TIME ) BETWEEN CAST ('16:00' AS TIME) AND CAST('17:30' AS TIME) THEN 'P' WHEN CAST(@PDate AS TIME ) BETWEEN CAST ('09:31' AS TIME) AND CAST('15:59' AS TIME) THEN 'HL' ELSE 'A' END SELECT *FROM MASTERPROCESSDAILYDATA where PDate ='02-1-13'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)