Update @TMP Set foo = (Select TOP 1 isNULL (bla)
                from @TMP T
                left join table1 tab1 on tab1.id = T.PF and tab1.value = 107
    where T.PF = @TMP.PF and T.TPB = @TMP.TPB)