Home Forums SQL Server 2008 SQL Server 2008 - General Use SUM function inside Update Statement RE: Use SUM function inside Update Statement
Koen Verbeeck
SSC Guru
Points: 259085
More actions
October 25, 2012 at 1:51 am
#1552545
For starters you'll need to include a GROUP BY on every column in the SELECT list that is not aggregated.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP