Trigger in SQL

[leojunes]

CREATE TRIGGER ImGeniousL on [LeftGroup]
for UPDATE
as

declare @vId varchar(20)


select @vid = memberid from updated
insert into leftgroup
select me_memberid ,
me_level, 0
from member
where me_uplineid = @vid


Im having problem on the "updated"
I just want to select the particular row
that was updated

[Cakkie]

Updated does not exist, but both inserted and deleted are available in an update trigger

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook