SELECT 'SI' as col  FROM EMPRESAS..sysobjects sysobjects  INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.NAME = 'empresas' AND  syscolumns.NAME = 'Version'
SELECT    Pn_Cve_Plantilla_Notificacion,    Pn_Descripcion,    Pn_Proximo_Envio,    Pn_Repetir_Tipo,    Pn_Repetir_Valor FROM Plantilla_Notificacion WHERE Pn_Proximo_Envio <= GetDate() AND    Es_Cve_Estado = 'AC'    AND ((( Pn_Aplica_Domingo = 'SI'    OR Pn_Aplica_Lunes = 'SI'    OR Pn_Aplica_Martes = 'SI'    OR Pn_Aplica_Miercoles = 'SI'    OR Pn_Aplica_Jueves = 'SI'    OR Pn_Aplica_Viernes = 'SI'    OR Pn_Aplica_Sabado = 'SI')    AND Pn_Repetir_Tipo IN ('dd','mi','hh')   ) OR Pn_Repetir_Tipo IN ('ww','mm')) 
Select top 25     Modulos.Clave,     Modulos.Descripcion,     Menus.EasyAccess,     EasyAccess.Transaccion,     EasyAccess.Accesos FROM     EMPRESAS..EasyAccess EasyAccess     INNER JOIN EMPRESAS..Operadores Operadores ON EasyAccess.Operador = Operadores.Operador     INNER JOIN EMPRESAS..Permisos Permisos ON EasyAccess.Empresa = Permisos.Empresa AND EasyAccess.Transaccion = Permisos.Menu AND Operadores.Perfil = Permisos.Perfil AND Permisos.Estado = 'AC'     INNER JOIN EMPRESAS..Menus Menus ON EasyAccess.Transaccion = Menus.Clave     INNER JOIN EMPRESAS..Modulos Modulos ON Menus.Modulo = Modulos.Clave WHERE     EasyAccess.Personalizado = 'SI' AND     EasyAccess.Bloqueado = 'NO' AND     EasyAccess.Operador = 'GINA' AND     EasyAccess.Empresa = '01' ORDER BY     EasyAccess.Accesos Desc 
SELECT    Pn_Cve_Plantilla_Notificacion,    Pn_Descripcion,    Pn_Proximo_Envio,    Pn_Repetir_Tipo,    Pn_Repetir_Valor FROM Plantilla_Notificacion WHERE Pn_Proximo_Envio <= GetDate() AND    Es_Cve_Estado = 'AC'    AND ((( Pn_Aplica_Domingo = 'SI'    OR Pn_Aplica_Lunes = 'SI'    OR Pn_Aplica_Martes = 'SI'    OR Pn_Aplica_Miercoles = 'SI'    OR Pn_Aplica_Jueves = 'SI'    OR Pn_Aplica_Viernes = 'SI'    OR Pn_Aplica_Sabado = 'SI')    AND Pn_Repetir_Tipo IN ('dd','mi','hh')   ) OR Pn_Repetir_Tipo IN ('ww','mm')) 
SELECT DISTINCT 
	Cotizacion.Ct_Folio AS FOLIO, 
	Sc_Descripcion as SUCURSAL,
	Vn_Descripcion as VENDEDOR,
	Cliente.Cl_Descripcion AS DESCRIPCON,
	Ct_Atencion as ATENCION,
	Cotizacion.Ct_Comentario AS COMENTARIO,
	SUM(Cotizacion.Ct_Precio_Neto_Importe) AS IMPORTE
 FROM  Cotizacion 
	INNER JOIN Cliente ON Cotizacion.Cl_Cve_Cliente = dbo.Cliente.Cl_Cve_Cliente
	INNER JOIN Sucursal ON Cotizacion.Sc_Cve_Sucursal = Sucursal.Sc_Cve_Sucursal
	INNER JOIN Vendedor ON Cotizacion.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor
WHERE 
	Ct_Folio LIKE '%pure%' OR Cl_Descripcion LIKE '%pure%' OR Vn_Descripcion LIKE '%pure%'
	/*Date2 AND Ct_Fecha  BETWEEN #Date1 AND #Date2 */
/*Empresa AND Sucursal.Em_Cve_Empresa = #Empresa */
/*Sucursal AND Cotizacion.Sc_Cve_Sucursal = #Sucursal */
/*Vendedor AND Cotizacion.Vn_Cve_Vendedor = #Vendedor */
/*Cliente AND Cotizacion.Cl_Cve_Cliente = #Cliente */
/*Producto AND Cotizacion.Pr_Cve_Producto = #Producto */
GROUP BY 
	Ct_Folio, 
	Sc_Descripcion,
	Vn_Descripcion,
	Cl_Descripcion, 
	Ct_Atencion,
	Ct_Comentario 
ORDER BY 
	Ct_Folio DESC
SELECT DISTINCT 
	Cotizacion.Ct_Folio AS FOLIO, 
	Sc_Descripcion as SUCURSAL,
	Vn_Descripcion as VENDEDOR,
	Cliente.Cl_Descripcion AS DESCRIPCON,
	Ct_Atencion as ATENCION,
	Cotizacion.Ct_Comentario AS COMENTARIO,
	SUM(Cotizacion.Ct_Precio_Neto_Importe) AS IMPORTE
 FROM  Cotizacion 
	INNER JOIN Cliente ON Cotizacion.Cl_Cve_Cliente = dbo.Cliente.Cl_Cve_Cliente
	INNER JOIN Sucursal ON Cotizacion.Sc_Cve_Sucursal = Sucursal.Sc_Cve_Sucursal
	INNER JOIN Vendedor ON Cotizacion.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor
WHERE 
	Ct_Folio LIKE '%pure%' OR Cl_Descripcion LIKE '%pure%' OR Vn_Descripcion LIKE '%pure%'
	/*Date2 AND Ct_Fecha  BETWEEN #Date1 AND #Date2 */
/*Empresa AND Sucursal.Em_Cve_Empresa = #Empresa */
/*Sucursal AND Cotizacion.Sc_Cve_Sucursal = #Sucursal */
/*Vendedor AND Cotizacion.Vn_Cve_Vendedor = #Vendedor */
/*Cliente AND Cotizacion.Cl_Cve_Cliente = #Cliente */
/*Producto AND Cotizacion.Pr_Cve_Producto = #Producto */
GROUP BY 
	Ct_Folio, 
	Sc_Descripcion,
	Vn_Descripcion,
	Cl_Descripcion, 
	Ct_Atencion,
	Ct_Comentario 
ORDER BY 
	Ct_Folio DESC
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'COTIZACION'
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA'
SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'GINA'
SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' 
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_MODO_VISOR_WEB'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_VALIDAR_COLONIA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_GRUPO_IMPUESTO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'CAT_DIRECCION_ENTREGA_SIMPLE'
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_DESCUENTO_GLOBAL'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHDG01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDG01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'VNDISP'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'VNDISP'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'VN001R2'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'VN001R2'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'VN001R1'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'VN001R1'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'VASUC'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'VASUC'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHVN001'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHVN001'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' 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 = '001' AND Menu = 'VN001' AND Restriccion = 'KEYF2'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'KEYF2'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHTC01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHTC01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHDM01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDM01'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_SUGERIR_DESCUENTO'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHDS01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDS01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHPR03'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHPR03'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'CHPR01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHPR01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '01' AND Perfil = '001' AND Menu = 'VN001' AND Restriccion = 'PMINIMO'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'PMINIMO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_VALIDAR_PRECIO_MINIMO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MOSTRAR_NUMERO_PARTE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'COT_CAMBIAR_ESTADO_OPORTUNIDAD'