Update e
Set DivTotal = t.DivTotal from EventData ed
join (Select EventKey, SUM(EventPoints) as DivTotal
From EventData
Where eventcode = 'F'
Group by Eventkey) t
on ed.EventKey = t.EventKey
Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/