SQL Server Update Group by - Stack Overflow

In MSSQL you can do aggregation in an update query you just have to do it in a subquery and then join it on the table you want to update. update #temp Set Dos=Cnt From #temp inner join (select total, count(*) as Cnt from Temp_Table2010 group by Total) s o

stackoverflow.com