Call a Stored Proc from a View

• Carol Adams

  SSCrazy

  Points: 2320

  More actions

  June 16, 2005 at 8:09 am

  #164025

  I am a newbie so be gentle...I was wondering if it was possible to call a stored procedure from a view.

  And if so, can you give me an example on how.

   

  Thx

   

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 16, 2005 at 8:18 am

  #566115

  Not possible.

  If you need a parametered module to send a select that can be used in a join or a view, you have to make it as a table function.

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 17, 2005 at 9:06 am

  #566444

  Agree. Not possible.

  You could go for the other approach, select from a view (or many) inside a Stored Procedure...