Saludos nuevamente por aqui consultando a los maestros tengo un problema tengo una consulta muy grande lo habia solucionando llamadnola desde un procedimiento pero por cuestiones de modificacion necesito meterla completa en el codigo o en unboton en VB6 como pues meterla si la consulta es muy grande un ejemplo
SELECT b.comprobante, b.num_envase, d.total_deposito, d.cuenta, b.nombre_cliente, '5234',
ISNULL(SUM(a.Importe_1000),0) as B1000,
ISNULL(SUM(a.Importe_500),0) AS B500,
ISNULL(SUM(a.Importe_200),0) AS B200,
ISNULL(SUM(a.Importe_100),0) AS B100,
ISNULL(SUM(a.Importe_50), 0) AS B50,
ISNULL(SUM(a.Importe_20), 0) AS B20,
ISNULL(SUM(c.Importe_100_e), 0)AS M100,
ISNULL(SUM(c.Importe_20_e), 0) AS M20,
ISNULL(SUM(c.Importe_10_e), 0) AS M10,
ISNULL(SUM(c.Importe_5_e), 0) AS M5,
ISNULL(SUM(c.Importe_2_e), 0) AS M2,
ISNULL(SUM(c.Importe_1_e), 0) AS M1,
ISNULL(SUM(c.Importe_50c_e), 0) AS C50,
ISNULL(SUM(c.Importe_20c_e), 0) AS C20,
ISNULL(SUM(c.Importe_10c_e), 0) AS C10,
ISNULL(SUM(c.Importe_05c_e), 0) AS C5,
ISNULL(SUM(a.Importe_1000 +
a.Importe_500 +
a.Importe_200 +
a.Importe_100 +
a.Importe_50 +
a.Importe_20 +
c.Importe_100_e+
c.Importe_20_e +
c.Importe_10_e +
c.Importe_5_e +
c.Importe_2_e +
c.Importe_1_e +
c.Importe_50c_e +
c.Importe_20c_e +
c.Importe_10c_e +
c.Importe_05c_e), 0) AS SUBTOTAL,
ISNULL(SUM(d.total_deposito -
(a.Importe_1000 +
a.Importe_500 +
a.Importe_200 +
a.Importe_100 +
a.Importe_50 +
a.Importe_20 +
c.Importe_100_e+
c.Importe_20_e +
c.Importe_10_e +
c.Importe_5_e +
c.Importe_2_e +
c.Importe_1_e +
c.Importe_50c_e +
c.Importe_20c_e +
c.Importe_10c_e +
c.Importe_05c_e)), 0) AS DIFERENCIA
FROM Proceso_Efectivo_global_Billete a, vproceso b, proceso_efectivo_global_moneda c, proceso_ficha_deposito d
where (a.Numero_Control = b.numero and (a.numero_control = c.numero_control) and (a.numero_control = d.numero_proceso))
and ((b.fecha = '20050719' and convert(varchar,b.hora_inicial,108) > '18:00:00')
or (b.fecha = '20050720' and convert(varchar,b.hora_inicial,108) < '18:01:00'))
and b.clas_seccion = '16535'
and d.total_docto = 0
GROUP BY b.comprobante, b.num_envase, d.total_deposito, d.cuenta, b.nombre_cliente
