>> I have two tables one is temporary and another is main dbo.employee <<

please, please, please read just one book on basic data modeling. A table models a set; a set is a collection and less you truly have only one employee. This name is totally wrong under ISO 11179 rules and common sense! I think you might have meant "Personnel"

>> In the main [sic] table I have added a column called fullamount. Basically this fullamount column is coming from different table dbo.Transfer( I want to split this full amount for all the participants for that transfer) <<

The rudeness of a total lack of DDL discourages us from even wanting to help you. Why is a column that shows a relationship between your personnel and something else (you never told us what) in the wrong table?

>> Being incredibly rude, or so stupid yes you were wrong 0

Expecting - I want to see the data in the full amount column under dbo.employee [sic: personel] based on taking from dbo.Transfer [this is verb!]

>> I am planning to implement the logic like this. Correct me if I am wrong plz. <<

Yes, you are wrong. Very very wrong. Please post real DDL and not a vague narrative. Please explain what you are trying to do.

I know the first few weeks of learning a language are very hard, but please read the forum rules about posting. I am sure by the time you been writing SQL or at least reading about it for one or two months you will do better.