Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- ipv.ProdCodEstr 'CÓDIGO DO PRODUTO',
- p.ProdNome as 'NOME PRODUTO',
- SUM (CAST(ipv.ItPedVendaQtd AS REAL)) as 'QTD PEDIDO',
- 'total por produto' as 'local 1',
- 'total por produto' as 'local 2',
- 'total por produto' as 'local 3'
- from PED_VENDA pv with (nolock),
- STAT_PED_VENDA spv with (nolock),
- ITEM_PED_VENDA ipv with (nolock) left join ESTQ_LOC_ARMAZ EstLoc with (nolock) on ( EstLoc.ProdCodEstr = ipv.ProdCodEstr)
- left join PRODUTO p on(p.ProdCodEstr = ipv.ProdCodEstr)
- where
- ipv.PedVendaNum = pv.PedVendaNum AND
- p.ProdCodEstr = ipv.ProdCodEstr AND
- ipv.ItPedVendaServ like 'Não' AND
- spv.StatPedVendaCod Not In ('08','10','11','12','13','14','15','16') AND
- pv.PedVendaData between
- '2017-01-01' AND -- Data iinicial
- '2017-12-01' -- Data final
- group by ipv.ProdCodEstr,p.ProdNome
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement