>I have a SQL Scalar-Valued function I'd like to call via SQL Pass Through and return the results. Is the possible? If so should I be using SQLEXEC( )?
>
>TIA
>Jeff
Sure it's possible:
Use
lnRetVal = sqlexec(lnConn, [select * from dbo.myUserFunction('SomeValue')], 'csrResults')
If it's not broken, fix it until it is.
My Blog