How do you call a stored procedure with a scalar function as one of it's parameters in SQL?
Posted on 2012-04-11
How do you call a stored procedure, in SQL, when you need one of the parameters to be one of the built in SQL scalar functions? What I know doesn't work is this:
exec MyStoredProc 'Param1', ScalarFunction(value)
exec MyStoredProc 'Param1', dbo.ScalarFunction(value)
and neither of those work with tick marks around the call of the scalar function either.