SQL Server Update Group by
Posted
by Gerardo Abdo
on Stack Overflow
See other posts from Stack Overflow
or by Gerardo Abdo
Published on 2010-05-17T22:41:41Z
Indexed on
2010/05/17
22:50 UTC
Read the original article
Hit count: 243
I'm trying to execute this on MS-SQL but returns me an error just at the Group by line
update #temp
Set Dos=Count(1)
From Temp_Table2010 s
where Id=s.Total and s.total in (Select Id from #temp)
group by s.Total
Do anyone knows how can I solve this problem having good performance.
© Stack Overflow or respective owner
