Stored Procedure inside a Function

cossy74 used Ask the Experts™
Is there anyway to exec a stored procedure inside a Table Function?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

i guess you cant

Only functions and some extended stored procedures can be executed from within a function.
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
not that I know of ... except via a query over linked server ... (openquery), but then, without hardcoded parameters ...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial