SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005

This is que query tah produce the error:

any help?


DECLARE @TablaTmpProd TABLE(valor VARCHAR(18) COLLATE
Modern_Spanish_CI_AS )

insert into @TablaTmpProd values('000000000010038166')
insert into @TablaTmpProd values('000000000010049734')
insert into @TablaTmpProd values('000000000010038034')


SELECT r.id_vendedor,
(
sum(acumulado) +
sum(bonificaciones) -
sum(devoluciones)
) as acumulado
FROM RESUMEN_R r
inner join vw_vendedor vv
on r.id_vendedor = vv.id_vendedor
AND VV.ID_SALA_VENTAS = 36
right join VW_MATERIALES_X_OF_VENTAS a
on ( a.id_material = r.id_material
and a.id_material in (select * from
@TablaTmpProd )
and r.fecha between '2004-04-01'
and '2004-04-26'
and a.id_oficina_ventas > vv.id_oficina_ventas
)
inner join tipo_producto t on (a.id_tipo_producto > t.id_tipo_producto )
inner join marca_producto m on (t.id_marca > m.id_marca )
inner join bandera b on (b.id_bandera > m.id_bandera )
inner join sector_producto s on
(s.id_sector_producto > b.id_sector_producto )
GROUP BY r.id_vendedor

Ya has instalado el Service Pack 3 ?

Gustavo Larriera, MVP-SQL, MCSE
Uruguay LatAm
Este mensaje se proporciona "COMO ESTA" sin garantias y

derecho / This posting is provided "AS IS" with no

no rights.
"pablo" wrote in

news:570e01c42d28$8d739300$
Mostrar la cita

This is que query tah produce the error:

any help?


DECLARE @TablaTmpProd TABLE(valor VARCHAR(18) COLLATE
Modern_Spanish_CI_AS )

insert into @TablaTmpProd values('000000000010038166')
insert into @TablaTmpProd values('000000000010049734')
insert into @TablaTmpProd values('000000000010038034')


SELECT r.id_vendedor,
(
sum(acumulado) +
sum(bonificaciones) -
sum(devoluciones)
) as acumulado
FROM RESUMEN_R r
inner join vw_vendedor vv
on r.id_vendedor = vv.id_vendedor
AND VV.ID_SALA_VENTAS = 36
right join VW_MATERIALES_X_OF_VENTAS a
on ( a.id_material = r.id_material
and a.id_material in (select * from
@TablaTmpProd )
and r.fecha between '2004-04-01'
and '2004-04-26'
and a.id_oficina_ventas >> vv.id_oficina_ventas
)
inner join tipo_producto t on (a.id_tipo_producto >> t.id_tipo_producto )
inner join marca_producto m on (t.id_marca >> m.id_marca )
inner join bandera b on (b.id_bandera >> m.id_bandera )
inner join sector_producto s on
(s.id_sector_producto >> b.id_sector_producto )
GROUP BY r.id_vendedor

.