IF (EXISTS(Select * from sys.systrigger where LCase(trigger_name) = LCase('TrigSpaOtchetiUpd')))
THEN Drop trigger TrigSpaOtchetiUpd
END IF

GO

create trigger TrigSpaOtchetiUpd after insert,update order 1 on
DBA.SpaOtcheti
referencing new as OtchetiNew
for each row
begin
  update SpaOtcheti set OtchetDateDt = FloatToDate(OtchetDate) where
    OtchetNo = OtchetiNew.OtchetNo
end