Yes

I want it all in 1 stored procedure. The base view is also used for other things so it the bas was changed it would affect the other views.