You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
ITD_track/reset_manual_cycle_closes.sql

6 lines
311 B
SQL

-- Нулиране на всички служебни изходи (нулиране на sl_close, dat_close, cycle_closed_at в ITD_Cards).
UPDATE dbo.ITD_Cards
SET sl_close = NULL, dat_close = NULL, cycle_closed_at = NULL
WHERE sl_close IS NOT NULL OR dat_close IS NOT NULL OR cycle_closed_at IS NOT NULL;