Home All Groups Group Topic Archive Search About

SQL Help: Updating aggregate table

Author
29 Jul 2005 3:56 PM
Onnuri
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

Author
29 Jul 2005 4:34 PM
David Portas
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.

--
David Portas
SQL Server MVP
--

AddThis Social Bookmark Button