SELECT TOP 100  
	Fc_Folio as FOLIO, 
	Fc_Fecha as FECHA, 
	Fc_Factura as FACTURA, 
	isnull(Condicion_Venta.Cv_Descripcion,'') as [CONDICION],
	Cl_Razon_Social_1 As CLIENTE,
	Vn_Descripcion as VENDEDOR,
	SUM(Factura.Fc_Precio_Neto_Importe) as IMPORTE,
	Factura.Es_Cve_Estado as ESTADO,
	Fc_Comentario as COMENTARIO
FROM	Factura 
	INNER JOIN Cliente ON Factura.Cl_Cve_Cliente = Cliente.Cl_Cve_Cliente 
	INNER JOIN Vendedor ON Factura.Vn_Cve_Vendedor = Vendedor.Vn_Cve_Vendedor
	INNER JOIN Sucursal ON Sucursal.Sc_Cve_Sucursal=Factura.Sc_Cve_Sucursal
	LEFT JOIN Condicion_Venta on Condicion_Venta.Cv_Cve_Condicion_Venta = Factura.Fc_Condicion_Venta 
WHERE 
(
	Cliente.Cl_Razon_Social_1 LIKE '%%' OR
	Factura.Fc_Comentario LIKE '%%' OR 
	Fc_Factura LIKE '%%' OR
	Vn_Descripcion LIKE '%%'
)
/*Date2 AND Fc_Fecha BETWEEN #Date1 AND #Date2 */
/*Empresa AND Sucursal.Em_Cve_Empresa = #Empresa */
/*Sucursal AND Factura.Sc_Cve_sucursal = #Sucursal */
/*Vendedor AND Factura.Vn_Cve_Vendedor = #Vendedor */
/*Cliente AND Factura.Cl_Cve_Cliente = #Cliente */
/*Producto AND Factura.Pr_Cve_Producto = #Producto */

GROUP BY
	Fc_Folio, 
	Fc_Fecha, 
	Fc_Credito,
	Fc_Factura,
	Cl_Razon_Social_1,
	Vn_Descripcion,
	Factura.Es_Cve_Estado,
	Fc_Comentario,
	Condicion_Venta.Cv_Descripcion 
ORDER BY 
	Fc_Fecha DESC,
	Fc_Folio DESC
SELECT SQL FROM EMPRESAS..Consultas WHERE Clave = 'FACTURA'
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 * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'RLCFDI' ORDER BY Fr_ID
EXEC SP_RPT_RLCFDI_2 '01-0000014'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'RLCFDI'
SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'FACTURA' AND Clave = '01-0000014' and not imagen is null  
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CAORGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CAORGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CAORGR' ORDER BY Fr_ID
EXEC SP_RPT_CAORGR_2 'FACTURA', '01-0000014', '03', '105'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'CAORGR'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
EXEC SP_RPT_SDIGGR_2 'FACTURA', '01-0000014', '02', '130'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'SDIGGR'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
EXEC SP_RPT_SDIGGR_2 'FACTURA', '01-0000014', '01', '130'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'SDIGGR'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'DEFAGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'DEFAGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DEFAGR' ORDER BY Fr_ID
EXEC SP_RPT_DEFAGR_2 '01-0000014'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'DEFAGR'
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
EXEC SP_RPT_CFDI40_3 '01-0000014'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CFDI40' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
EXEC SP_RPT_PROIMP_2 '01-0000014', '0002'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'PROIMP'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DESAFA' ORDER BY Fr_ID
EXEC SP_RPT_DESAFA_2 'FACTURA', '01-0000014', '0002'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'CFDI40'
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 = 'DESAFA'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID