SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'Empresa' AND Clave = '0001' AND Id = '0000' 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 = 'CA171') 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 = 'CA171') SELECT * FROM Empresa WHERE Em_Cve_Empresa = '0001' SELECT GetDate() as Fecha SELECT GetDate() as Fecha SELECT TOP 100 Em_Cve_Empresa as CLAVE, Em_Descripcion as NOMBRE, Es_Cve_Estado as ESTADO FROM EmpresaWHERE Em_Descripcion LIKE '%HAPP%' ORDER BY Em_Cve_Empresa SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'EMPRESA' 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 GetDate() as Fecha SELECT GetDate() as Fecha SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REGISTRAR_ALTA_LOG' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REGISTRAR_ALTA_LOG' SELECT Ad_ID, Ad_File_Name, Ad_File_Size, Ad_Descripcion,Oper_Alta,Fecha_Alta,'' FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' DELETE FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT ISNULL(Ad_Comprobante,'') AS Comprobante FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT ISNULL(Ad_Comprobante,'') AS Comprobante FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT Ad_Binary, Ad_File_Name FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT ISNULL(Ad_Comprobante,'') AS Comprobante FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT ISNULL(Ad_Comprobante,'') AS Comprobante FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT Ad_ID, Ad_File_Name, Ad_File_Size, Ad_Descripcion,Oper_Alta,Fecha_Alta,'' FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_PROVEEDOR_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_PERMITIR_MULTISELECCION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_MODIFICA_TIEMPO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_PERMITIR_EDITAR' 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 Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_XML_CON_ESQUEMAS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_RECEPTOR_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_EMISOR_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_BASE_SAT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_COMPROBANTE_UNICO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_PROVEEDOR_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_LIMITE_KB' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTAR_COMPROBANTE_AL_GUARDAR' SELECT Ad_Binary, Ad_File_Name FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT ISNULL(Ad_Comprobante,'') AS Comprobante FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT ISNULL(Ad_Comprobante,'') AS Comprobante FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' AND Ad_ID = '0001' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REGISTRAR_ALTA_LOG' SELECT Ad_ID, Ad_File_Name, Ad_File_Size, Ad_Descripcion,Oper_Alta,Fecha_Alta,'' FROM Adjunto WHERE Ad_Tabla = 'Empresa' AND Ad_Documento = '0001' *** COMMIT ***