SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE FileName = 'XSD.zip' AND Major = 6 AND Version_Instalador = '6.000.048' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_DIRECTORIO_REPORTES_ASP' 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 = 'MPROSRV' 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 = 'MPROSRV' AND FileName = 'XSD_PV.zip' UPDATE EMPRESAS..Ws_Bin SET Apply = 'SI' WHERE NombrePC = 'MPROSRV' AND FileName = 'XSD.zip' 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 = 'MPROSRV' 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 = 'MPROSRV' 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 = 'MPROSRV' 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 = 'MPROSRV' 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 = 'MPROSRV' 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 = 'MPROSRV' AND Ws_Bin.Version = '' *** COMMIT *** INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'MPROSRV' , 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 = 'MPROSRV' ) AND Tipo <= 2 AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Ws_Bin ( NombrePc , FileName , FilePath , Version , Actualizado , Apply ) SELECT 'MPROSRV' , 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 = 'MPROSRV' ) 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 = 'MPROSRV') = 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 = 'MPROSRV' *** BEGIN TRANSACION *** SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_WEBSERVICE_UPDATE_BASE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_WEBSERVICE_UPDATE_URL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_VERSION' SELECT Al_Controlar_Serie as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Controlar_Lote as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Controlar_Color as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Controlar_Talla as bRes FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Al_Descripcion FROM Almacen WHERE Sc_Cve_Sucursal = '0002' AND Al_Cve_Almacen = '0021' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0002' SELECT Em_Cve_Empresa AS Nombre FROM Sucursal WHERE Sc_Cve_Sucursal = '0002' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0002' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '000' AND Menu = 'TRF01' AND Restriccion = 'CHFECHA' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHFECHA' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '000' AND Menu = 'TRF01' AND Restriccion = 'OCOSTO' SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'OCOSTO' SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_LECTURA_VISIBLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_ACTIVO_FIJO_OBLIGATORIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_ACTIVO_FIJO_VISIBLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_UEN_OBLIGATORIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_UEN_VISIBLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_CENTRO_COSTO_OBLIGATORIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_CENTRO_COSTO_VISIBLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_PROYECTO_OBLIGATORIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'MOV_PROYECTO_VISIBLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_ACTIVO_FIJO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_UNIDAD_ESTRATEGICA_NEGOCIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_PROYECTO'