Нет описания

sql通话记录转值班电话修改20180907.sql 260B

1234567891011
  1. --转值班电话(呼叫状态,0:未接通电话1已接通电话)
  2. SELECT CallState,*
  3. FROM dbo.T_Call_CallRecords
  4. WHERE DealType = 3 AND CallState = 0
  5. ----未接通电话统一修改成已接通
  6. --UPDATE dbo.T_Call_CallRecords
  7. --SET CallState = 1
  8. --WHERE DealType = 3 AND CallState = 0