Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Deve roda Script no banco de dados para correção de Views
- / Object: VIEW [dbo].[vw_estoque_normal] Script DATE: 01/09/2014 09:58:28 /
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- CREATE VIEW [dbo].[vw_estoque_normal]
- (CODIGO,
- EST_TOTAL
- )
- AS
- SELECT CODIGO,
- CASE
- WHEN EXISTS (
- SELECT V.PRODUTO
- FROM PCP_PRODUTO_LOTE v
- LEFT JOIN GER_SET_EMP AS s
- ON s.CODSETOR = v.COD_S_ATUAL
- WHERE v.PRODUTO = CODIGO)
- THEN (
- SELECT isnull(SUM(v.SALDO_QUANT),0)
- FROM PCP_PRODUTO_LOTE v
- LEFT JOIN GER_SET_EMP AS s
- ON s.CODSETOR = v.COD_S_ATUAL
- WHERE v.PRODUTO = CODIGO AND s.NAO_SOMAR_EST = 0
- GROUP BY v.PRODUTO)
- ELSE isnull(SUM(EST_TOTAL),0) END AS ESTOQUE
- FROM vw_mov_estoque
- GROUP BY CODIGO
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement