SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_PRODUCTO' 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 = 'POS_VENTA_CLASIFICADOR_IMPRESION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_VENTA_CLASIFICADOR_POS' SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' EXEC SP_RPT_VNTK04_3 '01-0000029' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID EXEC SP_RPT_FTTK04_1 '0001' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID EXEC SP_RPT_FTTK04_2 '0001' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK04' 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 = 'FTTK04' SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'LOGO' and not imagen is null EXEC SP_RPT_VNTK04_1 '01-0000029' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID EXEC SP_RPT_VNTK04_2 '01-0000029' 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 = 'VNTK04' SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN' EXEC SP_RPT_VNTK04_3 '01-0000029' SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID EXEC SP_RPT_FTTK04_1 '0001' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'FTTK04' ORDER BY Fr_ID EXEC SP_RPT_FTTK04_2 '0001' SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK04' 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 = 'FTTK04' SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'LOGO' and not imagen is null EXEC SP_RPT_VNTK04_1 '01-0000029' SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'VNTK04' ORDER BY Fr_ID EXEC SP_RPT_VNTK04_2 '01-0000029' 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 = 'VNTK04' 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 = '0001' 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 = 'VNTK04' SELECT Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'VNTK04' SELECT Cj_Formato_Ticket as Formato FROM CAja WHERE Cj_Cve_Caja = '000001' SELECT Vn_Credito AS Nombre FROM Venta_Encabezado WHERE Vn_Folio = '01-0000029' SELECT Cl_Descripcion AS Nombre FROM CLIENTE WHERE Cl_Cve_cliente = '0000000001' *** COMMIT *** SELECT Obj.name AS Nombre, Obj.type AS Tipo, Obj.type_desc AS nTiop, Modu.definition AS Consulta FROM FARMACIA_CIRE.sys.objects Obj INNER JOIN FARMACIA_CIRE.sys.sql_modules Modu ON Obj.object_id = Modu.object_id WHERE (Obj.name IN (SELECT Ats_Sp FROM Afectar_Tabla_Sp WHERE At_Tabla = 'VENTA' AND Es_Cve_Estado <> 'BA') ) AND Obj.type = 'P' ORDER BY Obj.name ASC SELECT @@VERSION AS xVersion