SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE FileName = 'funcionesPRO.dll' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT d.name FROM sys.databases d WHERE d.name NOT IN ('master','tempdb','model','msdb') SELECT Update_Bin.FileName, Update_Bin.FilePath, Update_Bin.Version, Ws_Bin.FilePath as FilePathWs, Update_Bin.Tipo, Update_Bin.Ejecutar FROM EMPRESAS..Update_Bin Update_Bin INNER JOIN EMPRESAS..Ws_Bin Ws_Bin ON Update_Bin.FileName = Ws_Bin.FileName WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Ws_Bin.Apply = 'SI' AND Update_Bin.Tipo NOT IN(7,8) AND Update_Bin.Tipo NOT IN(9,10,11,12)ORDER BY Update_Bin.Tipo UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'SQLPro.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'Plantillas.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'Membrete.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'COMPLEMENTOS.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'FTO.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'EMP_99.SQL' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'ACT_99.SQL' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'DESKTOP-ILCB01L' AND FileName = 'funcionesPRO.dll' SELECT Update_Bin.FileName, Update_Bin.Memo, Ws_Bin.Version as Anterior, Update_Bin.Version, Update_Bin.FileSize, Ws_Bin.Apply, Update_Bin.Tipo, (CASE Update_Bin.Tipo WHEN 0 THEN 'Componente' WHEN 1 THEN 'Pantalla' WHEN 2 THEN 'Ejecutable Mpro' WHEN 3 THEN 'SQL Operativo' WHEN 4 THEN 'SQL Seguridad' WHEN 5 THEN 'Zip' WHEN 6 THEN 'Reporte' WHEN 7 THEN 'Pantalla personalizada' WHEN 8 THEN 'Reporte personalizado' WHEN 9 THEN 'Componente (Servidor)' WHEN 10 THEN 'Pantalla (Servidor)' WHEN 11 THEN 'Ejecutable (Servidor)' WHEN 12 THEN 'Zip (Servidor)' WHEN 13 THEN 'Librerķa System32' Else 'Desconocido' end) AS TipoDesc, Update_Bin.Opcional, (CASE Update_Bin.Tipo WHEN 7 THEN 1 WHEN 9 THEN 0 WHEN 10 THEN 1 WHEN 13 THEN 0 ELSE Update_Bin.Tipo END ) T2 FROM EMPRESAS..Update_Bin Update_Bin INNER JOIN EMPRESAS..Ws_Bin Ws_Bin ON Update_Bin.FileName = Ws_Bin.FileName WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Tipo NOT IN (7,8) AND Update_Bin.Tipo NOT IN(9,10,11,12)ORDER BY T2 SELECT SUM(CASE Update_Bin.Opcional WHEN 'NO' THEN 1 ELSE 0 END ) AS Importantes, SUM(CASE Update_Bin.Opcional WHEN 'SI' THEN 1 ELSE 0 END ) AS Opcionales, (SELECT TOP 1 Fecha FROM EMPRESAS..Ws WHERE NombrePc = 'DESKTOP-ILCB01L' ORDER BY Fecha DESC ) AS Fecha FROM EMPRESAS..Update_Bin Update_Bin INNER JOIN EMPRESAS..Ws_Bin Ws_Bin ON Update_Bin.FileName = Ws_Bin.FileName WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Tipo NOT IN (7,8) AND Update_Bin.Tipo NOT IN(9,10,11,12) SELECT COUNT(*) as Total FROM EMPRESAS..Update_Bin Update_Bin INNER JOIN EMPRESAS..Ws_Bin Ws_Bin ON Update_Bin.FileName = Ws_Bin.FileName WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Update_Bin.Tipo NOT IN(7,8) UPDATE Ws_Bin SET Ws_Bin.Actualizado = 'SI' FROM EMPRESAS..Ws_Bin Ws_Bin INNER JOIN EMPRESAS..Update_Bin Update_Bin ON Ws_Bin.FileName = Update_Bin.FileName WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Update_Bin.Tipo = 6 UPDATE EMPRESAS..Ws_Bin SET Ws_Bin.Actualizado = 'NO' FROM EMPRESAS..Ws_Bin Ws_Bin INNER JOIN EMPRESAS..Update_Bin Update_Bin ON Ws_Bin.FileName = Update_Bin.FileName WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND (CASE WHEN Update_Bin.Tipo > 2 THEN (SELECT COUNT(*) FROM EMPRESAS..Ws_Bin B2 WHERE B2.FileName = Update_Bin.FileName AND B2.Actualizado = 'SI') ELSE 0 END) = 0 AND ( CAST(REPLACE(Ws_Bin.Version,'.','') AS DECIMAL(18,0)) < CAST(REPLACE(Update_Bin.Version,'.','') AS DECIMAL(18,0)) OR (CAST(REPLACE(Ws_Bin.Version,'.','') AS DECIMAL(18,0)) <> CAST(REPLACE(Update_Bin.Version,'.','') AS DECIMAL(18,0)) AND Update_Bin.Sobreescribir = 'SI') ) UPDATE EMPRESAS..Update_Bin SET Update_Bin.Version = '6.000.048' FROM EMPRESAS..Update_Bin Update_Bin WHERE Update_Bin.Version = '' AND Version_Instalador = '6.000.048' UPDATE EMPRESAS..Ws_Bin SET Ws_Bin.Version = '6.000.048' FROM EMPRESAS..Ws_Bin Ws_Bin WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' AND Ws_Bin.Version = '' *** COMMIT *** INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'DESKTOP-ILCB01L' , FileName , Case Tipo WHEN 0 THEN 'C:\Program Files (x86)\mproerp\Management Pro\Core' WHEN 1 THEN 'C:\Program Files (x86)\mproerp\Management Pro\Bin' WHEN 2 THEN 'C:\Program Files (x86)\mproerp\Management Pro' Else 'C:\Program Files (x86)\mproerp\Management Pro' END, Version, 'NO', 'SI' FROM EMPRESAS..Update_Bin Update_Bin WHERE Filename NOT IN ( SELECT FileName FROM EMPRESAS..Ws_Bin Ws_Bin WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' ) AND Tipo <= 2 AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'DESKTOP-ILCB01L' , FileName , FilePath , Version , 'NO' , 'SI' FROM EMPRESAS..Update_Bin Update_Bin WHERE Filename NOT IN ( SELECT FileName FROM EMPRESAS..Ws_Bin Ws_Bin WHERE Ws_Bin.NombrePC = 'DESKTOP-ILCB01L' ) AND ( SELECT COUNT(*) FROM EMPRESAS..Ws_Bin Ws_Bin WHERE Ws_Bin.FileName = Update_Bin.FileName AND Ws_Bin.Actualizado = 'SI' AND Ws_Bin.NombrePC = 'DESKTOP-ILCB01L') = 0 AND Tipo > 2 AND Tipo <> 13 AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'webPro.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.53', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'w7botonPro.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'ventasPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.53', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'variablesPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.57', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'utilPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'userdefPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'updownPro.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'updatePRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.49', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'UFScanner.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '3.4.0.0', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'UFMatcher.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '3.4.0.0', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'traspasoPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'transferenciaPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.49', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'toolbarPRO.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.49', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'titlebarPro.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'textoPRO.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'textomPRO.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'tesoreriaPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.49', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'TecladoPro.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'tabladinamicaPRO.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'ssTabPro.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'sfacPRO.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'serviciosPro.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'seriePRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'saludPro.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'remisionesPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'promocionesPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'progressbarPro.ocx', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'produccionPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI') INSERT INTO EMPRESAS..WS_Bin ( NombrePC, FileName, FilePath, Version, Apply ) VALUES ( 'DESKTOP-ILCB01L', 'prepagoPRO.dll', 'C:\Program Files (x86)\mproerp\Management Pro\Core', '6.0.0.48', 'SI')