Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    54

    Unanswered: exec in a function

    I am creating a dynamic query and using exec to execute it inside of a function. This query will return only one value. How can I get the value the query returns into a variable?

    Functions can not call stored procedures, and they can not use temporary tables.

    Thanks much

  2. #2
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    I don't think you can do Dynamic SQL in a user defined fuction.

    Tim S

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •