Restrictions on Columns in the View
The columns that can be in the SELECT list or WHERE clause
of an indexed view are restricted. There are two possibilities based on the
query: GROUP BY or no GROUP BY. If there is no group by, the columns may not
contain expressions. However, they can contain computed fields in base tables
and user-defined functions. On the other hand, if there is a GROUP BY clause,
the following restrictions...