blob: 40ff23ee0f7834a51953c1c7d8489ec9c64b5e51 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
IF EXISTS(SELECT 1 FROM [dbo].[vendedorparcela] WHERE [valortotal] = 0)
BEGIN
UPDATE vendedorparcela
SET valortotal =
CASE
WHEN ( d.ADINACOMIS = 1 ) THEN
( d.PR_LIQ + PR_ADIC ) * ( d.com01 * 0.01 ) * ( vrep * 0.01 ) ELSE d.PR_LIQ * ( d.com01 * 0.01 ) * ( vrep * 0.01 )
END
FROM
vendedorparcela vp
INNER JOIN documento d ON d.iddocumento = vp.iddocumento
WHERE
vp.valortotal = 0;
END
|
