Came across an interesting piece of information about views and using them in Stored Procedures. According to Greg Low and a post on the subject view inside stored procedures can lead to performance issues. Now the example that Greg gives is quite extreme never the less it sounds like it is something he found in the wild.
If you were an experienced developer and it was done as an exception you aren’t going to cause yourself any grief. The problem with this sort of practice is that is it is the norm that you can quickly get in a situation where multiple view are accessing each other and the resulting query is messy but also inefficient.
So bottom line, best practice is not to use views in Stored Procedures.
Tags: Best Practice