UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'ACT_99.SQL' AND 3 > 2) OR ( FileName = 'ACT_99.SQL' AND Version < '6.000.070' ) OR ( FileName = 'ACT_99.SQL' AND Version <> '6.000.070' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'ACT_99' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'ACT_99', 6, '6.000.048', '6.000.070', 'ACT_99.SQL', '%APP.PATH%\Management Pro\SQL\UPD\', '105 KB', 'Nuevos campos para comprobante de pago (CFDI de pagos). Ampliación de campos Pago_Cxc y Cxp_Comprobante.', 3, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'XSD_PV' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'XSD' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'webPro' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN036' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN030' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN028' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN023' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN022' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN020' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN015' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN006' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN003' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'VN001' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'ventasPRO' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'variablesPRO' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'UT050' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'UT046' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'UT028' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'UT013' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'TS014' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'TS011' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'TS007' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'TRF01' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'transferenciaPRO' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'toolbarPRO' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'SR006' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'SR004' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'SR003' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'SQLPro' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RPVNA02' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RPVN002' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RPUT003' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RPIM002' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RPFA001' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RPAG013' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'RETAIL' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'ProGral' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PROADM' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PRO20' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PRO18' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PRO08' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PRO03' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PRO' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PRC002' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'PosTouch' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Version, Tipo FROM EMPRESAS..Update_Bin WHERE Transaccion = 'Plantillas' AND Major = 6 AND Version_Instalador = '6.000.048'