Calling a stored procedure

[bertrandkis]

Does any one knows how to call a stored procedure from a view? Is this possible?

 

[donutman]

No...you can't.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[JohnDTampaBay]

You could create a user-defined function that returns a table, but you still can't EXECute a stored procedure. You would have to duplicate the stored procedure code inside the function. A sticky solution, but maybe possible.

Another way that might work is using OPENQUERY to call the procedure as a pass-through query back to the same SQL Server you are running on. Another sticky possibility. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[donutman]

You may want to just avoid using the View and use a SP instead. That would be much better than using a UDF inside the view.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]