Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: Calling a Stored procedure from a UDF

    Hi Everybody,

    I was wondering if it is possible to call a Stored Procedure from inside a UDF. Any help is appreciated.

    Thanks,
    Tarun

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I tried to create a function that called a stored procedure, it won't allow you @ execution time.

    Msg 557, Level 16, State 2, Server ATLAS, Procedure fnRevenue, Line 6
    Only functions and extended stored procedures can be executed from within a function.

Posting Permissions

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