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.

ExerciseStart Exercise

Next lesson