SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' 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 = 'CONFIG' 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 Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = 'MOSTRADOR' AND Es_Cve_Estado <> 'BA' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = 'MOSTRADOR' AND Es_Cve_Estado <> 'BA' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = 'MOSTRADOR' AND Es_Cve_Estado <> 'BA' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%ventas a mostrador%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%ventas a mostrador%' OR Cl_R_F_C LIKE '%ventas a mostrador%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' 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 = 'CONFIG' 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 Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' SELECT Cl_Descripcion FROM Cliente WHERE Sc_Cve_Sucursal = '0001' AND Cl_Cve_Cliente = '0000000001' AND Es_Cve_Estado <> 'BA' Select CL_CVE_CLIENTE AS CLAVE, Cl_Descripcion as DESCRIPCION, (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) AS [RAZON SOCIAL], Cl_R_F_C AS [R.F.C.], ES_CVE_ESTADO As ESTADO FROM CLIENTE WHERE ( CL_DESCRIPCION LIKE '%%' OR (CL_Razon_Social_1 + ' ' + CL_Razon_Social_2) LIKE '%%' OR Cl_R_F_C LIKE '%%') AND Tc_Cve_Tipo_Cliente = 'CL' AND Cliente.Sc_Cve_Sucursal = '0001' 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 = 'CONFIG' 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'