Re: Using Stored Procedure returned fields in another Stored Proc or Query

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 06/21/04


Date: Mon, 21 Jun 2004 20:30:12 +0200

On Sun, 20 Jun 2004 16:29:36 -0700, <anonymous@discussions.microsoft.com>
wrote:

>Thanks for the reply, Hari.
>
>Just the name seems to elude to an extremely advanced
>solution.
>
>Searched the MS Online Support for:
> Inline table valued User defined functions
>
>but found no related documents
>
>
>Searched google for same and found
>http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.
>htm
>would this be what you are suggesting?
>
>Thanks,
> Barry G. Sumpter

Hi Barry,

In Books Online, activate the Index tab, enter the keyword "user-defined
functions" (without the quotation marks) and select the sub-heading
"return a table".

Best, Hugo

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)