SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005

28/04/2004 - 15:56 por pablo | Informe spam
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
 

Leer las respuestas

#1 Gustavo Larriera [MVP SQL]
28/04/2004 - 16:07 | Informe spam
Ya has instalado el Service Pack 3 ?

Gustavo Larriera, MVP-SQL, MCSE
Uruguay LatAm
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and confers
no rights.
"pablo" wrote in message
news:570e01c42d28$8d739300$
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

Preguntas similares