Thanks Keith. If I understand you correctly, I create one view for each combinaison of joins possible and don't filter the data in the view. I will filter the data in the business layer. That's what you mean?

What is the difference between a stored procedure that return a table and a view?

>Don't use a single stored procedure with many different criteria possibilities. The performance can possibly be worse by a factor of 10 or more and you will have no control over it.
>
>If you have the storage space, consider creating an indexed view for each possible join structure and query it dynamically from the business layer. This will simplify the execution plans (SQL Server will spend less time analyzing the SQL before running it).