• What I mean is not a combination temp table and while loop but temp table with an bulk update statement with help of variable, is it the same as while loop?

    Because if I check the statistics io and the time needed to execute it is much2 lower io and faster.