Hi,
I need an SQL statement help.  I am trying to UPDATE a View table, and this
is the error message:
"Derived Table '________' is not updatable because it contains aggregates."

Is there a way to update the table with aggregates?

Onnuri

An aggregated view is not updatable. You would need to update the base table
instead. Alternatively, you could create an INSTEAD OF trigger on the view
to update the base table whenever you attempt to update the view.

Alter table / update... set - strange problem
Newbee question about permissions and sp_OACreate
Stored Procs vs VIEWS: Seeking Comparison
How to find gaps in sequential key
boolean programming