Subject Views vs. Stored Procedures
Author Steve Summers
I'm not sure if this is a quick question or not.

If I have a fairly complex select with multiple joins, is there an
advantage to creating a stored procedure to return its result set,
rather than just creating a view?