DELETE FROM `acl` WHERE ((`clcodcn` = ?) AND ((? = 1 AND `clragd` IS NULL) OR (`clragd` = ?)) AND ((? = 1 AND `cl_flcanc` IS NULL) OR (`cl_flcanc` = ?)) AND ((? = 1 AND `clcod` IS NULL) OR (`clcod` = ?)) AND ((? = 1 AND `clcdpiva` IS NULL) OR (`clcdpiva` = ?)) AND ((? = 1 AND `clindi` IS NULL) OR (`clindi` = ?)) AND ((? = 1 AND `clloca` IS NULL) OR (`clloca` = ?)) AND ((? = 1 AND `clcapo` IS NULL) OR (`clcapo` = ?)) AND ((? = 1 AND `clprov` IS NULL) OR (`clprov` = ?)) AND ((? = 1 AND `cldist` IS NULL) OR (`cldist` = ?)) AND ((? = 1 AND `clstat` IS NULL) OR (`clstat` = ?)) AND ((? = 1 AND `clstatiso` IS NULL) OR (`clstatiso` = ?)) AND ((? = 1 AND `clcdfi` IS NULL) OR (`clcdfi` = ?)) AND ((? = 1 AND `clindidomfisc` IS NULL) OR (`clindidomfisc` = ?)) AND ((? = 1 AND `cllocadomfisc` IS NULL) OR (`cllocadomfisc` = ?)) AND ((? = 1 AND `clcapodomfisc` IS NULL) OR (`clcapodomfisc` = ?)) AND ((? = 1 AND `clprovdomfisc` IS NULL) OR (`clprovdomfisc` = ?)) AND ((? = 1 AND `cldistdomfisc` IS NULL) OR (`cldistdomfisc` = ?)) AND ((? = 1 AND `clstatdomfisc` IS NULL) OR (`clstatdomfisc` = ?)) AND ((? = 1 AND `clstatisodomfisc` IS NULL) OR (`clstatisodomfisc` = ?)) AND ((? = 1 AND `clalle` IS NULL) OR (`clalle` = ?)) AND ((? = 1 AND `clfldi` IS NULL) OR (`clfldi` = ?)) AND ((? = 1 AND `clcognom` IS NULL) OR (`clcognom` = ?)) AND ((? = 1 AND `clnome` IS NULL) OR (`clnome` = ?)) AND ((? = 1 AND `cldtna` IS NULL) OR (`cldtna` = ?)) AND ((? = 1 AND `clcona` IS NULL) OR (`clcona` = ?)) AND ((? = 1 AND `clprna` IS NULL) OR (`clprna` = ?)) AND ((? = 1 AND `cluscn` IS NULL) OR (`cluscn` = ?)) AND ((? = 1 AND `clstna` IS NULL) OR (`clstna` = ?)) AND ((? = 1 AND `clsess` IS NULL) OR (`clsess` = ?)) AND ((? = 1 AND `clrita` IS NULL) OR (`clrita` = ?)) AND ((? = 1 AND `cl_zona` IS NULL) OR (`cl_zona` = ?)) AND ((? = 1 AND `clcategoria` IS NULL) OR (`clcategoria` = ?)) AND ((? = 1 AND `clcategoria2` IS NULL) OR (`clcategoria2` = ?)) AND ((? = 1 AND `cl_sett_att1` IS NULL) OR (`cl_sett_att1` = ?)) AND ((? = 1 AND `cl_sett_att2` IS NULL) OR (`cl_sett_att2` = ?)) AND ((? = 1 AND `cl_categco` IS NULL) OR (`cl_categco` = ?)) AND ((? = 1 AND `cl_ling` IS NULL) OR (`cl_ling` = ?)) AND ((? = 1 AND `cl_filiale` IS NULL) OR (`cl_filiale` = ?)) AND ((? = 1 AND `cl_cod_old` IS NULL) OR (`cl_cod_old` = ?)) AND ((? = 1 AND `cl_cod_gruppo` IS NULL) OR (`cl_cod_gruppo` = ?)) AND ((? = 1 AND `cl_vt1` IS NULL) OR (`cl_vt1` = ?)) AND ((? = 1 AND `cl_vt2` IS NULL) OR (`cl_vt2` = ?)) AND ((? = 1 AND `cl_vt3` IS NULL) OR (`cl_vt3` = ?)) AND ((? = 1 AND `cl_vt4` IS NULL) OR (`cl_vt4` = ?)) AND ((? = 1 AND `abc_pa_sol_csolv_ID` IS NULL) OR (`abc_pa_sol_csolv_ID` = ?)) AND ((? = 1 AND `cl_solv_dtupd` IS NULL) OR (`cl_solv_dtupd` = ?)) AND ((? = 1 AND `cldtfineutil` IS NULL) OR (`cldtfineutil` = ?)) AND ((? = 1 AND `cl_fl_decod_anag` IS NULL) OR (`cl_fl_decod_anag` = ?)) AND ((? = 1 AND `clindirec` IS NULL) OR (`clindirec` = ?)) AND ((? = 1 AND `cllocarec` IS NULL) OR (`cllocarec` = ?)) AND ((? = 1 AND `clcaporec` IS NULL) OR (`clcaporec` = ?)) AND ((? = 1 AND `clprovrec` IS NULL) OR (`clprovrec` = ?)) AND ((? = 1 AND `clnfaxrec` IS NULL) OR (`clnfaxrec` = ?)) AND ((? = 1 AND `cltelerec` IS NULL) OR (`cltelerec` = ?)) AND ((? = 1 AND `clprcinps` IS NULL) OR (`clprcinps` = ?)) AND ((? = 1 AND `clsuffreplica` IS NULL) OR (`clsuffreplica` = ?)) AND ((? = 1 AND `cldtins` IS NULL) OR (`cldtins` = ?)) AND ((? = 1 AND `cldtvalidini` IS NULL) OR (`cldtvalidini` = ?)) AND ((? = 1 AND `clcdaccisa` IS NULL) OR (`clcdaccisa` = ?)) AND ((? = 1 AND `clnicciaa` IS NULL) OR (`clnicciaa` = ?)) AND ((? = 1 AND `clnregimp` IS NULL) OR (`clnregimp` = ?)) AND ((? = 1 AND `clcod_estero` IS NULL) OR (`clcod_estero` = ?)) AND ((? = 1 AND `clemail` IS NULL) OR (`clemail` = ?)) AND ((? = 1 AND `clwww` IS NULL) OR (`clwww` = ?)) AND ((? = 1 AND `clctrib` IS NULL) OR (`clctrib` = ?)) AND ((? = 1 AND `clCodCausRit` IS NULL) OR (`clCodCausRit` = ?)) AND ((? = 1 AND `clQuadro` IS NULL) OR (`clQuadro` = ?)) AND ((? = 1 AND `cl_destStampe` IS NULL) OR (`cl_destStampe` = ?)) AND ((? = 1 AND `clragd_n` IS NULL) OR (`clragd_n` = ?)) AND ((? = 1 AND `clindi_n` IS NULL) OR (`clindi_n` = ?)) AND ((? = 1 AND `clloca_n` IS NULL) OR (`clloca_n` = ?)) AND ((? = 1 AND `clindidomfisc_n` IS NULL) OR (`clindidomfisc_n` = ?)) AND ((? = 1 AND `cllocadomfisc_n` IS NULL) OR (`cllocadomfisc_n` = ?)) AND ((? = 1 AND `clindirec_n` IS NULL) OR (`clindirec_n` = ?)) AND ((? = 1 AND `cllocarec_n` IS NULL) OR (`cllocarec_n` = ?))) INSERT INTO `acl` (`clcodcn`, `clragd`, `cl_flcanc`, `clcod`, `clcdpiva`, `clindi`, `clloca`, `clcapo`, `clprov`, `cldist`, `clstat`, `clstatiso`, `clcdfi`, `cltele`, `clnfax`, `clindidomfisc`, `cllocadomfisc`, `clcapodomfisc`, `clprovdomfisc`, `cldistdomfisc`, `clstatdomfisc`, `clstatisodomfisc`, `clteledomfisc`, `clnfaxdomfisc`, `clalle`, `clfldi`, `clcognom`, `clnome`, `cldtna`, `clcona`, `clprna`, `cluscn`, `clstna`, `clsess`, `clrita`, `clannot1`, `clannot2`, `cl_zona`, `clcategoria`, `clcategoria2`, `cl_sett_att1`, `cl_sett_att2`, `clnote`, `cl_categco`, `cl_ling`, `cl_filiale`, `cl_cod_old`, `cl_cod_gruppo`, `cl_vt1`, `cl_vt2`, `cl_vt3`, `cl_vt4`, `abc_pa_sol_csolv_ID`, `cl_solv_dtupd`, `cldtfineutil`, `cl_fl_decod_anag`, `clindirec`, `cllocarec`, `clcaporec`, `clprovrec`, `clnfaxrec`, `cltelerec`, `clprcinps`, `clsuffreplica`, `cldtins`, `cldtvalidini`, `clcdaccisa`, `clnicciaa`, `clnregimp`, `clcod_estero`, `clemail`, `clwww`, `clctrib`, `clCodCausRit`, `clQuadro`, `cl_destStampe`, `clragd_n`, `clindi_n`, `clloca_n`, `clindidomfisc_n`, `cllocadomfisc_n`, `clindirec_n`, `cllocarec_n`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT clcodcn, clragd, cl_flcanc, clcod, clcdpiva, clindi, clloca, clcapo, clprov, cldist, clstat, clstatiso, clcdfi, cltele, clnfax, clindidomfisc, cllocadomfisc, clcapodomfisc, clprovdomfisc, cldistdomfisc, clstatdomfisc, clstatisodomfisc, clteledomfisc, clnfaxdomfisc, clalle, clfldi, clcognom, clnome, cldtna, clcona, clprna, cluscn, clstna, clsess, clrita, clannot1, clannot2, cl_zona, clcategoria, clcategoria2, cl_sett_att1, cl_sett_att2, clnote, cl_categco, cl_ling, cl_filiale, cl_cod_old, cl_cod_gruppo, cl_vt1, cl_vt2, cl_vt3, cl_vt4, abc_pa_sol_csolv_ID, cl_solv_dtupd, cldtfineutil, cl_fl_decod_anag, clindirec, cllocarec, clcaporec, clprovrec, clnfaxrec, cltelerec, clprcinps, clsuffreplica, cldtins, cldtvalidini, clcdaccisa, clnicciaa, clnregimp, clcod_estero, clemail, clwww, clctrib, clCodCausRit, clQuadro, cl_destStampe, clragd_n, clindi_n, clloca_n, clindidomfisc_n, cllocadomfisc_n, clindirec_n, cllocarec_n FROM acl UPDATE `acl` SET `clcodcn` = ?, `clragd` = ?, `cl_flcanc` = ?, `clcod` = ?, `clcdpiva` = ?, `clindi` = ?, `clloca` = ?, `clcapo` = ?, `clprov` = ?, `cldist` = ?, `clstat` = ?, `clstatiso` = ?, `clcdfi` = ?, `cltele` = ?, `clnfax` = ?, `clindidomfisc` = ?, `cllocadomfisc` = ?, `clcapodomfisc` = ?, `clprovdomfisc` = ?, `cldistdomfisc` = ?, `clstatdomfisc` = ?, `clstatisodomfisc` = ?, `clteledomfisc` = ?, `clnfaxdomfisc` = ?, `clalle` = ?, `clfldi` = ?, `clcognom` = ?, `clnome` = ?, `cldtna` = ?, `clcona` = ?, `clprna` = ?, `cluscn` = ?, `clstna` = ?, `clsess` = ?, `clrita` = ?, `clannot1` = ?, `clannot2` = ?, `cl_zona` = ?, `clcategoria` = ?, `clcategoria2` = ?, `cl_sett_att1` = ?, `cl_sett_att2` = ?, `clnote` = ?, `cl_categco` = ?, `cl_ling` = ?, `cl_filiale` = ?, `cl_cod_old` = ?, `cl_cod_gruppo` = ?, `cl_vt1` = ?, `cl_vt2` = ?, `cl_vt3` = ?, `cl_vt4` = ?, `abc_pa_sol_csolv_ID` = ?, `cl_solv_dtupd` = ?, `cldtfineutil` = ?, `cl_fl_decod_anag` = ?, `clindirec` = ?, `cllocarec` = ?, `clcaporec` = ?, `clprovrec` = ?, `clnfaxrec` = ?, `cltelerec` = ?, `clprcinps` = ?, `clsuffreplica` = ?, `cldtins` = ?, `cldtvalidini` = ?, `clcdaccisa` = ?, `clnicciaa` = ?, `clnregimp` = ?, `clcod_estero` = ?, `clemail` = ?, `clwww` = ?, `clctrib` = ?, `clCodCausRit` = ?, `clQuadro` = ?, `cl_destStampe` = ?, `clragd_n` = ?, `clindi_n` = ?, `clloca_n` = ?, `clindidomfisc_n` = ?, `cllocadomfisc_n` = ?, `clindirec_n` = ?, `cllocarec_n` = ? WHERE ((`clcodcn` = ?) AND ((? = 1 AND `clragd` IS NULL) OR (`clragd` = ?)) AND ((? = 1 AND `cl_flcanc` IS NULL) OR (`cl_flcanc` = ?)) AND ((? = 1 AND `clcod` IS NULL) OR (`clcod` = ?)) AND ((? = 1 AND `clcdpiva` IS NULL) OR (`clcdpiva` = ?)) AND ((? = 1 AND `clindi` IS NULL) OR (`clindi` = ?)) AND ((? = 1 AND `clloca` IS NULL) OR (`clloca` = ?)) AND ((? = 1 AND `clcapo` IS NULL) OR (`clcapo` = ?)) AND ((? = 1 AND `clprov` IS NULL) OR (`clprov` = ?)) AND ((? = 1 AND `cldist` IS NULL) OR (`cldist` = ?)) AND ((? = 1 AND `clstat` IS NULL) OR (`clstat` = ?)) AND ((? = 1 AND `clstatiso` IS NULL) OR (`clstatiso` = ?)) AND ((? = 1 AND `clcdfi` IS NULL) OR (`clcdfi` = ?)) AND ((? = 1 AND `clindidomfisc` IS NULL) OR (`clindidomfisc` = ?)) AND ((? = 1 AND `cllocadomfisc` IS NULL) OR (`cllocadomfisc` = ?)) AND ((? = 1 AND `clcapodomfisc` IS NULL) OR (`clcapodomfisc` = ?)) AND ((? = 1 AND `clprovdomfisc` IS NULL) OR (`clprovdomfisc` = ?)) AND ((? = 1 AND `cldistdomfisc` IS NULL) OR (`cldistdomfisc` = ?)) AND ((? = 1 AND `clstatdomfisc` IS NULL) OR (`clstatdomfisc` = ?)) AND ((? = 1 AND `clstatisodomfisc` IS NULL) OR (`clstatisodomfisc` = ?)) AND ((? = 1 AND `clalle` IS NULL) OR (`clalle` = ?)) AND ((? = 1 AND `clfldi` IS NULL) OR (`clfldi` = ?)) AND ((? = 1 AND `clcognom` IS NULL) OR (`clcognom` = ?)) AND ((? = 1 AND `clnome` IS NULL) OR (`clnome` = ?)) AND ((? = 1 AND `cldtna` IS NULL) OR (`cldtna` = ?)) AND ((? = 1 AND `clcona` IS NULL) OR (`clcona` = ?)) AND ((? = 1 AND `clprna` IS NULL) OR (`clprna` = ?)) AND ((? = 1 AND `cluscn` IS NULL) OR (`cluscn` = ?)) AND ((? = 1 AND `clstna` IS NULL) OR (`clstna` = ?)) AND ((? = 1 AND `clsess` IS NULL) OR (`clsess` = ?)) AND ((? = 1 AND `clrita` IS NULL) OR (`clrita` = ?)) AND ((? = 1 AND `cl_zona` IS NULL) OR (`cl_zona` = ?)) AND ((? = 1 AND `clcategoria` IS NULL) OR (`clcategoria` = ?)) AND ((? = 1 AND `clcategoria2` IS NULL) OR (`clcategoria2` = ?)) AND ((? = 1 AND `cl_sett_att1` IS NULL) OR (`cl_sett_att1` = ?)) AND ((? = 1 AND `cl_sett_att2` IS NULL) OR (`cl_sett_att2` = ?)) AND ((? = 1 AND `cl_categco` IS NULL) OR (`cl_categco` = ?)) AND ((? = 1 AND `cl_ling` IS NULL) OR (`cl_ling` = ?)) AND ((? = 1 AND `cl_filiale` IS NULL) OR (`cl_filiale` = ?)) AND ((? = 1 AND `cl_cod_old` IS NULL) OR (`cl_cod_old` = ?)) AND ((? = 1 AND `cl_cod_gruppo` IS NULL) OR (`cl_cod_gruppo` = ?)) AND ((? = 1 AND `cl_vt1` IS NULL) OR (`cl_vt1` = ?)) AND ((? = 1 AND `cl_vt2` IS NULL) OR (`cl_vt2` = ?)) AND ((? = 1 AND `cl_vt3` IS NULL) OR (`cl_vt3` = ?)) AND ((? = 1 AND `cl_vt4` IS NULL) OR (`cl_vt4` = ?)) AND ((? = 1 AND `abc_pa_sol_csolv_ID` IS NULL) OR (`abc_pa_sol_csolv_ID` = ?)) AND ((? = 1 AND `cl_solv_dtupd` IS NULL) OR (`cl_solv_dtupd` = ?)) AND ((? = 1 AND `cldtfineutil` IS NULL) OR (`cldtfineutil` = ?)) AND ((? = 1 AND `cl_fl_decod_anag` IS NULL) OR (`cl_fl_decod_anag` = ?)) AND ((? = 1 AND `clindirec` IS NULL) OR (`clindirec` = ?)) AND ((? = 1 AND `cllocarec` IS NULL) OR (`cllocarec` = ?)) AND ((? = 1 AND `clcaporec` IS NULL) OR (`clcaporec` = ?)) AND ((? = 1 AND `clprovrec` IS NULL) OR (`clprovrec` = ?)) AND ((? = 1 AND `clnfaxrec` IS NULL) OR (`clnfaxrec` = ?)) AND ((? = 1 AND `cltelerec` IS NULL) OR (`cltelerec` = ?)) AND ((? = 1 AND `clprcinps` IS NULL) OR (`clprcinps` = ?)) AND ((? = 1 AND `clsuffreplica` IS NULL) OR (`clsuffreplica` = ?)) AND ((? = 1 AND `cldtins` IS NULL) OR (`cldtins` = ?)) AND ((? = 1 AND `cldtvalidini` IS NULL) OR (`cldtvalidini` = ?)) AND ((? = 1 AND `clcdaccisa` IS NULL) OR (`clcdaccisa` = ?)) AND ((? = 1 AND `clnicciaa` IS NULL) OR (`clnicciaa` = ?)) AND ((? = 1 AND `clnregimp` IS NULL) OR (`clnregimp` = ?)) AND ((? = 1 AND `clcod_estero` IS NULL) OR (`clcod_estero` = ?)) AND ((? = 1 AND `clemail` IS NULL) OR (`clemail` = ?)) AND ((? = 1 AND `clwww` IS NULL) OR (`clwww` = ?)) AND ((? = 1 AND `clctrib` IS NULL) OR (`clctrib` = ?)) AND ((? = 1 AND `clCodCausRit` IS NULL) OR (`clCodCausRit` = ?)) AND ((? = 1 AND `clQuadro` IS NULL) OR (`clQuadro` = ?)) AND ((? = 1 AND `cl_destStampe` IS NULL) OR (`cl_destStampe` = ?)) AND ((? = 1 AND `clragd_n` IS NULL) OR (`clragd_n` = ?)) AND ((? = 1 AND `clindi_n` IS NULL) OR (`clindi_n` = ?)) AND ((? = 1 AND `clloca_n` IS NULL) OR (`clloca_n` = ?)) AND ((? = 1 AND `clindidomfisc_n` IS NULL) OR (`clindidomfisc_n` = ?)) AND ((? = 1 AND `cllocadomfisc_n` IS NULL) OR (`cllocadomfisc_n` = ?)) AND ((? = 1 AND `clindirec_n` IS NULL) OR (`clindirec_n` = ?)) AND ((? = 1 AND `cllocarec_n` IS NULL) OR (`cllocarec_n` = ?))) dbo.stp_CaricaAnagCliSwing