• No. You cannot use a Stored Procedure like a UDF.

    You can insert the results from a Stored Procedure into a temporary table and work on the temporary table further.


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/