Parallel UDR in the select list

If you use a UDR in the select list and do not specify a WHERE clause, the UDR can execute in parallel if any of the following conditions are true:

• The GROUP BY clause is specified in the query.
• The ORDER BY clause is specified in the query.
• An aggregate such as MIN, MAX, AVG is specified in the query.
• The query is a parallel INSERT...SELECT statement.
• The query is a SELECT...INTO statement.