How To pass a resultset to a function

Hi,

I have a problem passing the resultset of a query to a function.

so I started like this:

DECLARE @idoc asint,@MyResultsetas?,@StartPathasnvarchar(50);

set @StartPath ='nodes/node'

EXECsp_xml_preparedocument @idocoutput,@XML_IN

set@MyResultset =(select*fromOPENXML(@idoc,@startpath,2))

select fn_myfunction(@MyResultset);-- get the recursive path for example

but this don't work.

Do i have to use a temporary table or is there any way to do it with parameters?

Thanks in advance

Raimund

[1814 byte] By [Raimund] at [2008-1-10]