exec in user-defined function

Hi,

How can I do dynamical exec to query in user-defined function? At the end I need to return the result.

Thank's
Alexei

You are not allowed. That's by design. Refer to BOL -> CREATE FUNCTION for more details.