sql server programming: Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are. Sample data is also a good idea, along with clear
specifications.

With a variable declared and its value found by a select statement

Say DECLARE @MyVar INT
Now find variable Myvar in MyTable based on a foreign key value for
instance
Select @Myvar = Myvar From MyTAble where ID = (select IDFK from deleted)

Now I want to assign @MyVar to a field in the current record being updated.
Whats the syntax for that?

I tried Update deleted set MyValue = @Myvar but I get an error when checking
the syntax. saying fields in deleted can not be updated.

Can anyone help?

Would be greatly appreciated.

Best regards,

RD