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 as int, @MyResultset as ????,@StartPath as nvarchar(50);

set @StartPath ='nodes/node'


EXEC sp_xml_preparedocument @idoc output,@XML_IN

set @MyResultset =(select * from OPENXML(@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