SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZTORET' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZTORET' ORDER BY Fr_ID EXEC SP_RPT_ZTORET_2 '98-0000079' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFARRE' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'ZTORET' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZDEFAG' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZDEFAG' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZDEFAG' ORDER BY Fr_ID EXEC SP_RPT_ZDEFAG_2 '98-0000079' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFARRE' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'ZDEFAG' SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' EXEC SP_RPT_ZFARRE_3 '98-0000079' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZFARRE' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CPDI33' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CPDI33' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CPDI33' ORDER BY Fr_ID EXEC SP_RPT_CPDI33_2 'FACTURA', '98-0000079', '0001' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFARRE' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'CPDI33' SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'zfac33' and not imagen is null EXEC SP_RPT_ZFARRE_1 '98-0000079' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZFARRE' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZFARRE' ORDER BY Fr_ID EXEC SP_RPT_ZFARRE_2 '98-0000079' SELECT TOP 1 Fr_Procedure1, Fr_Procedure2, Fr_Procedure3, Fr_LineasDetalle, Fr_Alto_Hoja, Fr_Ancho_Hoja, Fr_Horizontal, Fr_Caida_Libre FROM Formato WHERE Fr_Cve_Formato = 'ZFARRE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_MODO_LISTAR_IMPRESORAS' 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 = 'AVAZQUEZ' 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 Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFARRE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_PRINTER_ESC_P' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_REDIMENSIONAR_IMAGEN' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VISTA_PREVIA_IMPRESION_MULTIPLE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_USUARIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_SSL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_AUTENTICACION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_PASSWORD' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_FROM' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_NOMBRE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_USUARIO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_TIME_OUT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_PUERTO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'EMAIL_SERVIDOR' SELECT Sc_Formato_Factura FROM Sucursal WHERE Sc_Cve_Sucursal = '0098' SELECT Cl_Formato_Factura FROM Cliente WHERE Cl_Cve_Cliente = 'A05558' SELECT Pe_HTML AS Nombre FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = '' SELECT Pe_Texto FROM Plantilla_Email WHERE Pe_Cve_Plantilla_Email = ''