SELECT * FROM Cotizacion WHERE Ct_Folio = '01-0010327' AND    (Es_Cve_Estado = 'AC' OR Es_Cve_Estado = 'AU') and    Sc_Cve_Sucursal like '%%' ORDER BY Ct_ID ASC 
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 '%%' OR Cl_Descripcion LIKE '%%' OR Vn_Descripcion LIKE '%%'
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 '%%' OR Cl_Descripcion LIKE '%%' OR Vn_Descripcion LIKE '%%'
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 = 'VTAS MOSTRADOR'
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_MODO_CONSULTA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta'
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 * FROM Cotizacion WHERE Ct_Folio = '' AND    (Es_Cve_Estado = 'AC' OR Es_Cve_Estado = 'AU') and    Sc_Cve_Sucursal like '%%' ORDER BY Ct_ID ASC 
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'COTIZACION'
SELECT * FROM Cotizacion WHERE Ct_Folio = '' AND    (Es_Cve_Estado = 'AC' OR Es_Cve_Estado = 'AU') and    Sc_Cve_Sucursal like '%%' ORDER BY Ct_ID ASC 
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 = 'VTAS MOSTRADOR'
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_MODO_CONSULTA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta'
SELECT GetDate() as Fecha
SELECT Tc_Tipo_Cambio FROM Tipo_Cambio WHERE Mn_Cve_Moneda = '' AND    Tc_Fecha = '2026-07-13'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MODO_OBTENER_TIPO_CAMBIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FIN_MONEDA_LOCAL'
SELECT GetDate() as Fecha
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_LECTURA_VISIBLE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_ACTIVO_FIJO_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_ACTIVO_FIJO_VISIBLE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_UEN_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_UEN_VISIBLE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_CENTRO_COSTO_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_CENTRO_COSTO_VISIBLE'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_PROYECTO_OBLIGATORIO'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'VEN_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'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_CENTRO_COSTO'
SELECT GetDate() as Fecha
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '04' AND Perfil = '005' AND Menu = 'FA003' AND Restriccion = 'CHDG01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDG01'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '04' AND Perfil = '005' AND Menu = 'FA003' AND Restriccion = 'KEYF2'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'KEYF2'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '04' AND Perfil = '005' AND Menu = 'FA003' AND Restriccion = 'CHDEAM'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'CHDEAM'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '04' AND Perfil = '005' AND Menu = 'FA003' AND Restriccion = 'VASUC'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'VASUC'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '04' AND Perfil = '005' AND Menu = 'FA003' AND Restriccion = 'RSFA001'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones WHERE Clave = 'RSFA001'
SELECT COUNT(*) as Total FROM EMPRESAS..Restricciones_Permisos WHERE Empresa = '04' AND Perfil = '005' AND Menu = 'FA003' AND Restriccion = 'CHFECHA'