to update the sbuid by the number of times bp, seq and type has occured in the table you may use the following statement.

update #tmp

set #tmp.sbuid = #tmp2.sbuid

from #tmp

inner...