@nigelrivett: thanks for that. But in my environment i can not use this solution, because we are using a dynamic TSQL generator and there we can not add this kind of "work around". So, it seems that there's no way to pass a function as a parameter to a sp?
thanks as well for the hint with the...
Hi there,
is it possible to call a procedure with a function as an inbound parameter like following:
exec sp_test dbo.fn_read_value()
this results in an error!
is there a way to pass the return value from the function to the inbound parameter of the stored procedure?
thanx in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.