EXEC SP_RPT_NOE002_1 '01-0001451' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'NOE002' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'NOE002' ORDER BY Fr_ID EXEC SP_RPT_NOE002_2 '01-0001451' 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 = 'NOE002' 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 = 'ARACELI' 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 = 'NOE002' 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 DISTINCT Fr_Cve_Formato as CLAVE, Fr_Descripcion AS FORMATO FROM Formato WHERE Fr_Cve_Formato in('NOE002','NOGR03') 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 = 'ARACELI' 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 Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_RECIBO_NOMINA' SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'NOMINA' AND Clave = '01-0001457' and not imagen is null SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZCAOR7' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZCAOR7' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZCAOR7' ORDER BY Fr_ID EXEC SP_RPT_ZCAOR7_2 'NOMINA', '01-0001457', '03', '105' 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 = 'ZCAOR7' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZSDIG7' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZSDIG7' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZSDIG7' ORDER BY Fr_ID EXEC SP_RPT_ZSDIG7_2 'NOMINA', '01-0001457', '02', '130' 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 = 'ZSDIG7' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZSDIG7' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZSDIG7' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZSDIG7' ORDER BY Fr_ID EXEC SP_RPT_ZSDIG7_2 'NOMINA', '01-0001457', '01', '130' 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 = 'ZSDIG7' SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' EXEC SP_RPT_NOE002_3 '01-0001457' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'NOE002' ORDER BY Fr_ID EXEC SP_RPT_NOE002_1 '01-0001457' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'NOE002' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'NOE002' ORDER BY Fr_ID EXEC SP_RPT_NOE002_2 '01-0001457' 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 = 'NOE002' 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 = 'ARACELI' 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'