You are a database developer for a marketing firm. You have designed a quarterly sales view. This view
joins several tables and calculates aggregate information. You create a unique index on the view. You
want to provide a parameterised query to access the data contained in your indexed view. The output will
be used in other SELECT lists.
How should you accomplish this goal?

A. Use an ALTER VIEW statement to add the parameter value to the view definition

B. Create a stored procedure that accepts the parameter as input and returns a rowset with the result set

C. Create a scalar user-defined function that accepts the parameter as input

D. Create an inline user-defined function that accepts the parameter as input

Ответ C, т.к. SELECT list это все же SELECT list... Или я не прав и D?

Так ведь inline UDF нельзя использовать в SELECT lists.
SELECT lists - это то, что до FROM.

Да, вижу, что Inline UDF подходит больше.