UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'FA008.dll' AND        1 > 2) OR    ( FileName = 'FA008.dll' AND        Version < '8.0.0.13' ) OR    ( FileName = 'FA008.dll' AND        Version <> '8.0.0.13' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'FA008' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'FA008',    8,    '8.000.008',    '8.0.0.13',    'FA008.dll',    '',    '62KB',    'Mejoras para filtrar formas de pago',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'FA007.dll' AND        1 > 2) OR    ( FileName = 'FA007.dll' AND        Version < '8.0.0.12' ) OR    ( FileName = 'FA007.dll' AND        Version <> '8.0.0.12' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'FA007' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'FA007',    8,    '8.000.008',    '8.0.0.12',    'FA007.dll',    '',    '50KB',    'Corrección en ventas con unidades diferentes Venta, control1 y control2',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'FA006.dll' AND        1 > 2) OR    ( FileName = 'FA006.dll' AND        Version < '8.0.0.10' ) OR    ( FileName = 'FA006.dll' AND        Version <> '8.0.0.10' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'FA006' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'FA006',    8,    '8.000.008',    '8.0.0.10',    'FA006.dll',    '',    '53KB',    'Corrección al consultar documentos con filas en blanco',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'FA005.dll' AND        1 > 2) OR    ( FileName = 'FA005.dll' AND        Version < '8.0.0.9' ) OR    ( FileName = 'FA005.dll' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'FA005' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'FA005',    8,    '8.000.008',    '8.0.0.9',    'FA005.dll',    '',    '69KB',    'Corrección al consultar documentos con filas en blanco',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'FA003.dll' AND        1 > 2) OR    ( FileName = 'FA003.dll' AND        Version < '8.0.0.10' ) OR    ( FileName = 'FA003.dll' AND        Version <> '8.0.0.10' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'FA003' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'FA003',    8,    '8.000.008',    '8.0.0.10',    'FA003.dll',    '',    '73KB',    'Corrección al consultar documentos con filas en blanco',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'FA001.dll' AND        1 > 2) OR    ( FileName = 'FA001.dll' AND        Version < '8.0.0.12' ) OR    ( FileName = 'FA001.dll' AND        Version <> '8.0.0.12' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'FA001' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'FA001',    8,    '8.000.008',    '8.0.0.12',    'FA001.dll',    '',    '114KB',    'Mejoras para facturas con opciones de exportación.',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'entregaProLV.ocx' AND        0 > 2) OR    ( FileName = 'entregaProLV.ocx' AND        Version < '8.0.0.9' ) OR    ( FileName = 'entregaProLV.ocx' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'entregaProLV' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'entregaProLV',    8,    '8.000.008',    '8.0.0.9',    'entregaProLV.ocx',    '',    '31KB',    'Ajuste en baja y reactivación de dirección',    0,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'entregaPRO.dll' AND        0 > 2) OR    ( FileName = 'entregaPRO.dll' AND        Version < '8.0.0.9' ) OR    ( FileName = 'entregaPRO.dll' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'entregaPRO' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'entregaPRO',    8,    '8.000.008',    '8.0.0.9',    'entregaPRO.dll',    '',    '72KB',    'Ajuste en longitud de captura de municipio y ciudad',    0,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'EMP_99.SQL' AND        4 > 2) OR    ( FileName = 'EMP_99.SQL' AND        Version < '8.000.023' ) OR    ( FileName = 'EMP_99.SQL' AND        Version <> '8.000.023' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'EMP_99' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'EMP_99',    8,    '8.000.008',    '8.000.023',    'EMP_99.SQL',    '%APP.PATH%\Management Pro\SQL\UPD\',    '7KB',    'Consultas, campos nuevos, etc. en la base de seguridad.',    4,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'efacturaPRO.dll' AND        0 > 2) OR    ( FileName = 'efacturaPRO.dll' AND        Version < '8.0.0.24' ) OR    ( FileName = 'efacturaPRO.dll' AND        Version <> '8.0.0.24' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'efacturaPRO' AND    Major = 8 AND    Version_Instalador = '8.000.008' 
INSERT INTO EMPRESAS..Update_Bin (   Transaccion,    Major,    Version_Instalador,    Version,    FileName,    FilePath,    FileSize,    Memo,    Tipo,    Opcional,    Ejecutar,    Sobreescribir,    Fecha_Ult_Modif,    Up_Binary  )VALUES(    'efacturaPRO',    8,    '8.000.008',    '8.0.0.24',    'efacturaPRO.dll',    '',    '226KB',    'Ajustes para facturas con opciones de exportación y comercio exterior.',    0,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***