Sunday, March 11, 2012

Calling a Stored procedure from a UDF

Hi Everybody,
I was wondering if it is possible to call a Stored Procedure from inside a UDF. Any help is appreciated.
Thanks,
TarunI tried to create a function that called a stored procedure, it won't allow you @. execution time.

Msg 557, Level 16, State 2, Server ATLAS, Procedure fnRevenue, Line 6
Only functions and extended stored procedures can be executed from within a function.

No comments:

Post a Comment