Here is my statement:
DELETE FROM table1 OUTPUT deleted.col1, deleted.col2 INTO view1;
It gives me this error:
The target 'view1' of the OUTPUT INTO clause cannot be a view or common table expression.
The view is simple and updatable. Why can I not insert into an updatable view using the OUTPUT clause?