CREATE TRIGGER Trp_SlipDetails
ON tbl_SlipDetails
FOR INSERT,UPDATE
AS
BEGIN 

UPDATE s 
set s.Winnings = s.Stake * s.Odds
from tbl_Slip as s
inner join inserted as i
on i.SlipId = s.Id
where i.IsWinning = 1

END

quote:

---

Originally posted by programer

I tried to use your code but not works.

My result is:
2 10,00 15,00 150,00 Calculated IsWinning=1x. This is wrong.

Stake*Odds calculated if are completed all conditions.

In my case are completed all conditions when I updated:
tbl_SlipDetails:
ID SlipId IsWinning
1 1 0
2 2 0
3 2 0

To:

tbl_SlipDetails:
ID SlipId IsWinning
1 1 0
2 2 1
3 2 1

If is
tbl_SlipDetails:
ID SlipId IsWinning
1 1 0
2 2 1
3 2 0

not calculated because IsWinning = 1 and 0.

---

CREATE TRIGGER Trp_SlipDetails
ON tbl_SlipDetails
FOR INSERT,UPDATE
AS
BEGIN 

UPDATE s 
set s.Winnings = s.Stake * s.Odds
from tbl_Slip as s
inner join (SELECT i1.SlipId
            FROM inserted i1
            INNER JOIN tbl_SlipDetails sd
            ON i1.SlipId = sd.SlipId
            GROUP BY i1.SlipId
            HAVING SUM(CASE WHEN sd.IsWinning = 0 THEN 1 ELSE 0 END) = 0
            )as i
on i.SlipId = s.Id

END

quote:

---

Originally posted by visakh16

Your explanation is still not clear to me. You would be better illustrating with some sample data clearly if my below guess doesnt work

CREATE TRIGGER Trp_SlipDetails
ON tbl_SlipDetails
FOR INSERT,UPDATE
AS
BEGIN 

UPDATE s 
set s.Winnings = s.Stake * s.Odds
from tbl_Slip as s
inner join (SELECT i1.SlipId
            FROM inserted i1
            INNER JOIN tbl_SlipDetails sd
            ON i1.SlipId = sd.SlipId
            GROUP BY i1.SlipId
            HAVING SUM(CASE WHEN sd.IsWinning = 0 THEN 1 ELSE 0 END) = 0
            )as i
on i.SlipId = s.Id

END

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

---