SELECT Descripcion FROM EMPRESAS..Empresas SELECT COUNT(*) as Total FROM EMPRESAS..Ws_Bin WHERE FileName = 'ACT_99.SQL' AND Actualizado = 'SI' SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE FileName = 'ACT_99.SQL' 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 = 'SERVERCICLO' 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)ORDER BY Update_Bin.Tipo UPDATE EMPRESAS..Ws_Bin SET Apply = 'NO' WHERE NombrePC = 'SERVERCICLO' AND FileName = 'SQLPro.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'SERVERCICLO' AND FileName = 'ACT_99.SQL' 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 = 'SERVERCICLO' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Tipo NOT IN (7,8)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 = 'SERVERCICLO' 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 = 'SERVERCICLO' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Tipo NOT IN (7,8) 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 = 'SERVERCICLO' 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 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 = 'SERVERCICLO' 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 = 'SERVERCICLO' AND Ws_Bin.Version = '' *** COMMIT *** INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'SERVERCICLO' , 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 = 'SERVERCICLO' ) AND Tipo <= 2 AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'SERVERCICLO' , 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 = 'SERVERCICLO' ) 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 = 'SERVERCICLO') = 0 AND Tipo > 2 AND Tipo <> 13 AND Major = 6 AND Version_Instalador = '6.000.048' SELECT NombrePc, Fecha, GETDATE() as Fecha_Actual, Actualizado FROM EMPRESAS..Ws WHERE NombrePC = 'SERVERCICLO' *** BEGIN TRANSACION *** SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL_UPDATE_WS' SELECT COUNT(Transaccion) AS t, ISNULL(SUM(CASE Update_Bin.Opcional WHEN 'NO' THEN 1 ELSE 0 END ),0) AS Importantes, ISNULL(SUM(CASE Update_Bin.Opcional WHEN 'SI' THEN 1 ELSE 0 END ),0) AS Opcionales FROM EMPRESAS..Update_Bin Update_Bin WHERE Version_Instalador = '6.000.048' AND Tipo NOT IN (7,8) SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT Descripcion FROM EMPRESAS..Empresas SELECT COUNT(*) as Total FROM EMPRESAS..Ws_Bin WHERE FileName = 'ACT_99.SQL' AND Actualizado = 'SI' SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE FileName = 'ACT_99.SQL' 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 = 'SERVERCICLO' 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)ORDER BY Update_Bin.Tipo UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'SERVERCICLO' AND FileName = 'SQLPro.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'SERVERCICLO' AND FileName = 'ACT_99.SQL' 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 = 'SERVERCICLO' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Tipo NOT IN (7,8)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 = 'SERVERCICLO' 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 = 'SERVERCICLO' AND Update_Bin.Major = 6 AND Update_Bin.Version_Instalador = '6.000.048' AND Ws_Bin.Actualizado = 'NO' AND Tipo NOT IN (7,8) 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 = 'SERVERCICLO' 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 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 = 'SERVERCICLO' 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 = 'SERVERCICLO' AND Ws_Bin.Version = '' *** COMMIT *** INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'SERVERCICLO' , 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 = 'SERVERCICLO' ) AND Tipo <= 2 AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'SERVERCICLO' , 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 = 'SERVERCICLO' ) 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 = 'SERVERCICLO') = 0 AND Tipo > 2 AND Tipo <> 13 AND Major = 6 AND Version_Instalador = '6.000.048' SELECT NombrePc, Fecha, GETDATE() as Fecha_Actual, Actualizado FROM EMPRESAS..Ws WHERE NombrePC = 'SERVERCICLO' *** BEGIN TRANSACION *** SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL_UPDATE_WS' SELECT COUNT(Transaccion) AS t, ISNULL(SUM(CASE Update_Bin.Opcional WHEN 'NO' THEN 1 ELSE 0 END ),0) AS Importantes, ISNULL(SUM(CASE Update_Bin.Opcional WHEN 'SI' THEN 1 ELSE 0 END ),0) AS Opcionales FROM EMPRESAS..Update_Bin Update_Bin WHERE Version_Instalador = '6.000.048' AND Tipo NOT IN (7,8) SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT FontSize AS Nombre FROM EMPRESAS..Operadores WHERE Operador = 'AMARTIN' SELECT GetDate() as Fecha SELECT @@SPID as ID, Op.Email, Op.Nombre, Op.Empresa, Pf.Clave, Pf.Nombre as Perfil FROM EMPRESAS..Operadores Op INNER JOIN EMPRESAS..Perfiles Pf ON Pf.Clave = Op.Perfil WHERE Op.Operador = 'AMARTIN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMP_RFC'