Using the @Execute Function

Objective

After completing this lesson, you will be able to Use the @Execute Function.

The @Execute Function

The @Execute function allows you to reference a list of values in a SQL expression. It is designed to improve performance of SQL queries, especially when the list of values definition is a complex query.

Use the @Execute Function

You need to create a query filter using the @Execute function that the reporting users can use in any query to restrict their results to only those clients who have more than one sales ID.

Log in to track your progress & complete quizzes