search

dylangetssmart / NeedlesNeos-BrianWhite

0 stars 0 forks source link

Close case duplicate reason #7

Closed dylangetssmart closed 1 hour ago

dylangetssmart commented 3 hours ago

Update sma_TRN_Cases.CloseReason to null for all cases where it is 0

UPDATE stc
SET stc.CloseReason = null
FROM sma_TRN_Cases stc
where stc.CloseReason = 0
dylangetssmart commented 2 hours ago

update case close reason.xlsx