Q: Trigger - Reference To Fields In Inserted ?

Hi all,

I have a ranking system where I wish to update the ranking every time a result is reported. Performance is no issue what-so-ever. More specifically, two players are to devide their points after each series of games to reflect the fraction of over-all games that each player have won. 

I've written the trigger below, but Visual Web Developer 2005 Express (SQL Server 2005 Express) complains about the references to the 'inserted'-table.

I find it very difficult to transform the code below to something that looks like the examples found in documentation.

Could someone get me started in the right direction?

Thanks in advance,

Anders

create trigger result_insert on result

after insert as

begin

declare @won1 as int

declare @won2 as int

declare @oldRank1 as float

declare @oldRank2 as float

declare @oldranksum as float



select @won1 = sum(wongames1) from result where player1 = inserted.player1 and player2=inserted.player2

select @won2 = sum(wongames2) from result where player1 = inserted.player1 and player2=inserted.player2



select @oldrank1 = Rank from RankingInfo where memberid = inserted.playerid1

select @oldrank2 = Rank from RankingInfo where memberid = inserted.playerid2



set @oldranksum = @oldrank1 + @oldrank2



update rankingInfo set Rank = @won1 / ( @won1+@won2) * @oldranksum where memberid = inserted.player1

update rankingInfo set Rank = @won2 / ( @won1+@won2) * @oldranksum where memberid = inserted.player2



end