SQL – An aggregate may not appear in the set list of an UPDATE statement

Applications

I have a Project table that contains a couple of fields used for reporting and metrics called FirstActivity, LastActivity, and TotalHours. I created the following SQL query to update those fields based on some aggregated results from the ProjectHours table: UPDATE     [dbo].[Project] SET     FirstActivity = MIN(ProjectHours.[EntryDate])     , FirstActivity = MAX(ProjectHours.[EntryDate])     , TotalHours = SUM(ProjectHours.[TotalHours]) FROM…

SQL – An aggregate may not appear in the set list of an UPDATE statement

Applications

I have a Project table that contains a couple of fields used for reporting and metrics called FirstActivity, LastActivity, and TotalHours. I created the following SQL query to update those fields based on some aggregated results from the ProjectHours table: UPDATE     [dbo].[Project] SET     FirstActivity = MIN(ProjectHours.[EntryDate])     , FirstActivity = MAX(ProjectHours.[EntryDate])     , TotalHours = SUM(ProjectHours.[TotalHours]) FROM     [dbo].[Project]     INNER JOIN [ProjectHours] ON [Project].[ProjectId]…

Autoscaling, Azure, WAP and System Center

infrastructure

The term autoscaling can have several meanings including scaling out (adding additional instance), scaling up (adding more resources to an existing instance) and scaling down (removing resources from an existing instance). In Azure this is explained at http://msdn.microsoft.com/en-us/library/hh680945(v=PandP.50).aspx. In this three part blog post series, my goal is to explain what the current state for…