SQL Server Update Group by -

I'm trying to execute it on MS SQL, but gives me an error on the group in just one line < / P>

  update #temp set dos = Temp_Table2010 s from calculation (1) where in ID = s and in s.total (choose ID from # ID) group by S.  

Does anybody know how I can solve this problem that is performing well?

Try

 ; As calculated with the calculation (select the total, dos FROM temp_table2010 as COUNT (*) Calculate the total where in (select ID from #temp)) Update T set dos = # counts.dos from #temp T inner included .id = counts.total