Passing parameters to query without TVFs

This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.

Table-Valued Parameters