UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CO009.dll' AND        1 > 2) OR    ( FileName = 'CO009.dll' AND        Version < '8.0.0.10' ) OR    ( FileName = 'CO009.dll' AND        Version <> '8.0.0.10' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CO009' 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(    'CO009',    8,    '8.000.008',    '8.0.0.10',    'CO009.dll',    '',    '87KB',    'Cambios menores de interacción (Filas en blanco)',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CO008.dll' AND        1 > 2) OR    ( FileName = 'CO008.dll' AND        Version < '8.0.0.12' ) OR    ( FileName = 'CO008.dll' AND        Version <> '8.0.0.12' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CO008' 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(    'CO008',    8,    '8.000.008',    '8.0.0.12',    'CO008.dll',    '',    '51KB',    'Ajustes menores',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CO007.dll' AND        1 > 2) OR    ( FileName = 'CO007.dll' AND        Version < '8.0.0.9' ) OR    ( FileName = 'CO007.dll' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CO007' 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(    'CO007',    8,    '8.000.008',    '8.0.0.9',    'CO007.dll',    '',    '56KB',    'Cambios menores de interacción (Filas en blanco)',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CO006.dll' AND        1 > 2) OR    ( FileName = 'CO006.dll' AND        Version < '8.0.0.9' ) OR    ( FileName = 'CO006.dll' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CO006' 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(    'CO006',    8,    '8.000.008',    '8.0.0.9',    'CO006.dll',    '',    '60KB',    'Corrección al calcular el costo.',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CO002.dll' AND        1 > 2) OR    ( FileName = 'CO002.dll' AND        Version < '8.0.0.11' ) OR    ( FileName = 'CO002.dll' AND        Version <> '8.0.0.11' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CO002' 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(    'CO002',    8,    '8.000.008',    '8.0.0.11',    'CO002.dll',    '',    '131KB',    'Corrección al validar proyectos',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CO001.dll' AND        1 > 2) OR    ( FileName = 'CO001.dll' AND        Version < '8.0.0.14' ) OR    ( FileName = 'CO001.dll' AND        Version <> '8.0.0.14' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CO001' 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(    'CO001',    8,    '8.000.008',    '8.0.0.14',    'CO001.dll',    '',    '97KB',    'Corrección al validar proyectos',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CmdPrinter.exe' AND        2 > 2) OR    ( FileName = 'CmdPrinter.exe' AND        Version < '8.0.0.16' ) OR    ( FileName = 'CmdPrinter.exe' AND        Version <> '8.0.0.16' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CmdPrinter' 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(    'CmdPrinter',    8,    '8.000.008',    '8.0.0.16',    'CmdPrinter.exe',    '',    '76KB',    'Imprimir solo comandas de la caja selecionada',    2,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'cmdmonitorSite' 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(    'cmdmonitorSite',    8,    '8.000.008',    '8.000.014',    'cmdmonitorSite.zip',    '%ASP.PATH%\cmdmonitor\',    '18KB',    'Mejoras monitor web',    6,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CmdMonitor.exe' AND        2 > 2) OR    ( FileName = 'CmdMonitor.exe' AND        Version < '8.0.0.9' ) OR    ( FileName = 'CmdMonitor.exe' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CmdMonitor' 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(    'CmdMonitor',    8,    '8.000.008',    '8.0.0.9',    'CmdMonitor.exe',    '',    '130KB',    'Duplicado de cuentas corregido',    2,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CLN005.dll' AND        1 > 2) OR    ( FileName = 'CLN005.dll' AND        Version < '8.0.0.9' ) OR    ( FileName = 'CLN005.dll' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CLN005' 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(    'CLN005',    8,    '8.000.008',    '8.0.0.9',    'CLN005.dll',    '',    '42KB',    'Ajuste en generación de cita',    1,    'NO',    'SI',    'NO',    GETDATE(),    null )
*** BEGIN TRANSACION ***
*** COMMIT ***
UPDATE EMPRESAS..Ws_Bin SET    Actualizado = 'NO' WHERE    (FileName = 'CLN002.dll' AND        1 > 2) OR    ( FileName = 'CLN002.dll' AND        Version < '8.0.0.9' ) OR    ( FileName = 'CLN002.dll' AND        Version <> '8.0.0.9' AND        'NO' = 'SI') 
SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE    Transaccion = 'CLN002' AND    Major = 8 AND    Version_Instalador = '8.000.008'