updateBounty.sql

begin tran
if exists (select * from dbo.BountyfulUsers with (updlock,serializable) where dbo.BountyfulUsers.UserName = '#[payload.userId]')
begin
   update dbo.BountyfulUsers set BountiesCompleted += 1
   where dbo.BountyfulUsers.UserName = '#[payload.userId]'
end
else
begin
   insert into dbo.BountyfulUsers (UserName, BountiesCompleted)
   values ('#[payload.userId]', 1)
end
commit tran