RE: Calling a Stored Procedure from a View

SSC Guru

Points: 323504

July 22, 2008 at 11:19 am

sounds like you want the results of sp_who in a view for example?

simply sp_helptext sp_XXX, and read the code....maybe you can simply lift the code, or maybe you can convert it to a function, so you can create a view of the function...it really depends...a lot of the sp_'s have cursors and otehr things that can make it difficult to do a view.

the code to call a stored proc and display it is already easily accomplished...so can you explain why you want to do this?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!