>select a.EDPNo, b.PVC, a.EachWeight, > c.VendNo, c.TermsPct, c.FrtCharge, c.FreeFrt, c.FrtAsPct, c.FrtChargePct, > --c.FreeFrt = 1 > (b.PVC - (b.PVC * (c.TermsPct / 100))) as Calc1, > --c.FrtAsPct = 1 > (b.PVC + (b.PVC * (c.FrtChargePct / 100))) - (b.PVC * (c.TermsPct / 100)) as Calc2, > --c.FreeFrt = 0 & c.FrtAsPct = 0 > (b.PVC + (c.FrtCharge * a.EachWeight)) - (b.PVC * (c.TermsPct / 100)) as Calc3 >from DS1.dbo.ItemMst a join DS1.dbo.PItems b on a.EDPNo = b.EDPNo > inner join DS1.dbo.VendorMst c on a.VendNo = c.VendNo >>
select a.EDPNo, b.PVC, a.EachWeight, c.VendNo, c.TermsPct, c.FrtCharge, c.FreeFrt, c.FrtAsPct, c.FrtChargePct, CASE WHEN c.FreeFrt = 1 then (b.PVC - (b.PVC * (c.TermsPct / 100))) CASE WHEN c.FrtAsPct = 1 THEN (b.PVC + (b.PVC * (c.FrtChargePct / 100))) - (b.PVC * (c.TermsPct / 100)) CASE WHEN c.FreeFrt = 0 AND c.FrtAsPct = 0 THEN (b.PVC + (c.FrtCharge * a.EachWeight)) - (b.PVC * (c.TermsPct / 100)) END as Calc from DS1.dbo.ItemMst a join DS1.dbo.PItems b on a.EDPNo = b.EDPNo inner join DS1.dbo.VendorMst c on a.VendNo = c.VendNo