当我试图执行此查询时 [英] When I Am Trying To Execute This Query

问题描述

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'

当我尝试执行此查询时，状态仅更新ELSE条件（DEFAULT）

任何人都可以帮我解决此问题




@Pdate datetime

@In_Punch datetime

@Out_Punch datetime

when i am trying to execute this query, Status is updated only ELSE Condition(DEFAULT)
Can anyone help me to solve this problem


@PDate datetime
@In_Punch datetime
@Out_Punch datetime

推荐答案

您没有在此代码中为PDate设置值。因此，它是null。这是你的其他情况。

You are not setting a value for PDate in this code. Therefore, it is null. Which is your else case.

这篇关于当我试图执行此查询时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！