title: How to use a view in a stored procedure
body: <p>How to use a view inside a stored procedure in sql server? I tried something like this and it says that object cannot be found</p>
  
  <pre><code>CREATE VIEW myview
  AS
    view code
  
  
  CREATE PROCEDURE myprocedure
  AS
    code using myview
  </code></pre>