SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'CA072') SELECT * FROM Factura_Serie_Digital WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' order by Fsd_Folio_Final asc SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001' AND Es_Cve_Estado <> 'BA' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'CA072') SELECT * FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'CA072') SELECT * FROM Factura_Serie_Digital WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' order by Fsd_Folio_Final asc SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001' AND Es_Cve_Estado <> 'BA' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'CA072') SELECT * FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT TOP 100 Factura_Serie.Fs_Cve_Factura_Serie AS CLAVE, Factura_Serie.Fs_Descripcion AS DESCRIPCION, Fs_Sucursal AS SUCURSAL, CASE Fs_Tipo WHEN '01' THEN 'FACTURA' WHEN '02' THEN 'NOTA DE CREDITO' WHEN '03' THEN 'CFD' WHEN '04' THEN 'CFDI' WHEN '05' THEN 'CBB' ELSE '' END as TIPO, CAST(Factura_Serie.Fs_Folio as nvarchar(10)) as [SIGUIENTE FOLIO], Factura_Serie.Es_Cve_Estado as ESTADO, ''FROM Factura_SerieWHERE Fs_Descripcion LIKE '%%' AND ((Factura_Serie.Fs_Tipo = '04'))ORDER BY Factura_Serie.Fs_Cve_Factura_Serie SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'FACTURA_SERIE' 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 = 'DIRECCION' 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 GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT Fs_Descripcion AS Nombre FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' SELECT Fs_Descripcion AS Nombre FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' SELECT Fs_Descripcion AS Nombre FROM Factura_Serie WHERE Fs_Cve_Factura_Serie = 'M' AND Fs_Tipo = '04' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001' AND Es_Cve_Estado <> 'BA' SELECT Sc_Descripcion FROM Sucursal WHERE Sc_Cve_Sucursal = '0001' AND Es_Cve_Estado <> 'BA' SELECT TOP 100 Sucursal.Sc_Cve_Sucursal as CLAVE, Sucursal.Sc_Descripcion as DESCRIPCION, Empresa.Em_Razon_Social as EMPRESA, Sucursal.Sc_Centro_Costo as [CENTRO DE COSTO], Sucursal.Sc_Cuenta_Contable as [CUENTA_CONTABLE], Sucursal.Es_Cve_Estado as ESTADO, Zona.Zn_Descripcion as ZONA, ''FROM Sucursal INNER JOIN Empresa ON Sucursal.Em_Cve_Empresa = Empresa.Em_Cve_Empresa INNER JOIN Zona ON Sucursal.Zn_Cve_Zona = Zona.Zn_Cve_ZonaWHERE Sucursal.Sc_Descripcion LIKE '%%' OR Empresa.Em_Descripcion LIKE '%%' OR Empresa.Em_Razon_Social LIKE '%%' OR Zona.Zn_Descripcion LIKE '%%'ORDER BY Sucursal.Sc_Cve_Sucursal SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'SUCURSAL' 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 = 'DIRECCION' 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 TOP 100 Factura_Serie.Fs_Cve_Factura_Serie AS CLAVE, Factura_Serie.Fs_Descripcion AS DESCRIPCION, Fs_Sucursal AS SUCURSAL, CASE Fs_Tipo WHEN '01' THEN 'FACTURA' WHEN '02' THEN 'NOTA DE CREDITO' WHEN '03' THEN 'CFD' WHEN '04' THEN 'CFDI' WHEN '05' THEN 'CBB' ELSE '' END as TIPO, CAST(Factura_Serie.Fs_Folio as nvarchar(10)) as [SIGUIENTE FOLIO], Factura_Serie.Es_Cve_Estado as ESTADO, ''FROM Factura_SerieWHERE Fs_Descripcion LIKE '%%' AND ((Factura_Serie.Fs_Tipo = '04'))ORDER BY Factura_Serie.Fs_Cve_Factura_Serie