Dynamic calls to Stored Procedures or Table-Valued Functions

Parameters can be used as arguments to Stored Procedures or Table-Valued Functions : when the Parameter changes, the Stored Procedure or Table-Valued Function is called again with the new values as arguments.

For more information, see in chapter Stored Procedures.