EXEC SP_RPT_ZVNTKC_3 '01-0000015'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZVNTKC' 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 = 'ZVNTKC'
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_ZVNTKC_1 '01-0000015'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZVNTKC' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZVNTKC' ORDER BY Fr_ID
EXEC SP_RPT_ZVNTKC_2 '01-0000015'
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 = 'ZVNTKC'
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 = '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 Fr_Grafico AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZVNTKC'
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    syscolumns.Name as Columna,    systypes.name as Tipo From sysobjects    inner join syscolumns on syscolumns.id = sysobjects.id    inner join systypes on systypes.xusertype = syscolumns.xtype Where sysobjects.type ='p' and sysobjects.category <> 2 and sysobjects.name = 'SP_RPT_ZVNTKC_1' order by colorder 
SELECT TOP 1 * FROM Formato WHERE Fr_Cve_Formato = 'ZVNTKC' 
SELECT TOP 1 Vn_Comentario FROM Venta WHERE Vn_Folio = '01-0000015'
SELECT TOP 1 Vn_Comentario FROM Venta WHERE Vn_Folio = '01-0000015'
SELECT TOP 100   
	Vn_Folio as FOLIO, 
	Vn_Fecha as FECHA, 
	Vn_Referencia as REFERENCIA, 
	Cl_Razon_Social_1 As CLIENTE,
	SUM(Venta.Vn_Precio_Neto_Importe) as TOTAL,
	Venta.Es_Cve_Estado as ESTADO,
	Vn_Aplicado as APLICADO,
	CASE WHEN Vn_Credito = 'SI' THEN 'CREDITO' ELSE 'CONTADO' END as TIPO,
	Vn_Comentario as COMENTARIO,
	Rt_Cve_Ruta as RUTA,
	Vn_Descripcion as VENDEDOR
 FROM  	Venta 
	INNER JOIN Cliente ON Venta.Cl_Cve_Cliente = Cliente.Cl_Cve_Cliente 
	INNER JOIN Vendedor ON Venta.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor
	INNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal=Venta.Sc_Cve_Sucursal
WHERE
( 
	Cl_Descripcion LIKE '%%' OR
	Cl_Razon_Social_1 LIKE '%%' OR
	Cl_R_F_C LIKE '%%' OR
	Vn_Comentario LIKE '%%' OR
	Vn_Referencia LIKE '%%' OR 
	Vn_Descripcion LIKE '%%' OR
	Rt_Cve_Ruta IN (SELECT Rt_Cve_Ruta  FROM  Ruta WHERE Rt_Descripcion LIKE '%%')
)
/*Date2 AND Vn_Fecha BETWEEN #Date1 AND #Date2 */
/*Empresa AND Sucursal.Em_Cve_Empresa = #Empresa */
/*Sucursal AND Venta.Sc_Cve_sucursal = #Sucursal */
/*Vendedor AND Venta.Vn_Cve_Vendedor = #Vendedor */
/*Cliente AND Venta.Cl_Cve_Cliente = #Cliente */
/*Producto AND Venta.Pr_Cve_Producto = #Producto */
	
GROUP BY
	Vn_Folio, 
	Vn_Fecha, 
	Vn_Referencia, 
	Cl_Razon_Social_1,
    	Venta.Es_Cve_Estado,
	Vn_Aplicado,
	Vn_Credito,
	Vn_Comentario,
	Rt_Cve_Ruta,
	Vn_Descripcion
ORDER BY 
	Vn_Fecha DESC,
	Vn_Folio DESC
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'VENTA'
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_MODO_CONSULTA'
SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_Max_RegistrosConsulta'
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = 'UT002' 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 DISTINCT    syscolumns.ColID,    syscolumns.Name as Columna,    systypes.name as Tipo,    isnull(Pa_Nombre_Campo,syscolumns.Name) as Campo,    cast(isnull(Pa_SQL_Descripcion,'') as nvarchar(2000)) as SQL,    isnull(Pa_ID_Consulta,'') as Consulta,    isnull(Pa_Formato,'') as Formato From sysobjects    inner join syscolumns on syscolumns.id = sysobjects.id    inner join systypes on systypes.xusertype = syscolumns.xtype    left join parametros on parametros.Pa_Parametro = syscolumns.Name Where    sysobjects.type ='p' and sysobjects.category <> 2 and    sysobjects.name in('SP_RPT_ZVNTKC_1','SP_RPT_ZVNTKC_2','SP_RPT_ZVNTKC_3' ) ORDER BY    syscolumns.ColID 
SELECT TOP 1 *  FROM Formato WHERE Fr_Cve_Formato = 'ZVNTKC' 
SELECT DISTINCT Texto,ID,Transaccion from  Configuracion_Etiqueta where (Transaccion = 'UT002' 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 DISTINCT    syscolumns.ColID,    syscolumns.Name as Columna,    systypes.name as Tipo,    isnull(Pa_Nombre_Campo,syscolumns.Name) as Campo,    cast(isnull(Pa_SQL_Descripcion,'') as nvarchar(2000)) as SQL,    isnull(Pa_ID_Consulta,'') as Consulta,    isnull(Pa_Formato,'') as Formato From sysobjects    inner join syscolumns on syscolumns.id = sysobjects.id    inner join systypes on systypes.xusertype = syscolumns.xtype    left join parametros on parametros.Pa_Parametro = syscolumns.Name Where    sysobjects.type ='p' and sysobjects.category <> 2 and    sysobjects.name in('SP_RPT_ZVNTKC_1','SP_RPT_ZVNTKC_2','SP_RPT_ZVNTKC_3' ) ORDER BY    syscolumns.ColID 
SELECT TOP 1 *  FROM Formato WHERE Fr_Cve_Formato = 'ZVNTKC' 
SELECT TOP 100  Fr_Cve_Formato AS  CLAVE, Fr_Descripcion AS DESCRIOCION, Fr_Grafico AS GRAFICO FROM Formato WHERE (Fr_Cve_Formato LIKE '%vntk%' Or Fr_Descripcion LIKE '%vntk%' )GROUP BY Fr_Cve_Formato, Fr_Descripcion, Fr_Grafico ORDER BY Fr_Cve_Formato