Thanks a lot for all the replies.

Hi RBarryYoung,

Thanks for replying. However I am aware of this solution.

Is there any other soln without the use of temp tables?

I mean, can I use the SP and pass...

Hello John,

Actually i was setting SET ARITHABORT ON before creating the UDF not in SP logic..

I did dat now and it is working perfectly..

Thanks a lot John.. 🙂

Hello John,

Thanks for ur suggestion.

Now i have the following UDF

CREATE FUNCTION dbo.fnIds

(

@ParmXML XML

)

RETURNS @Id table

(

TempId INT...

Hello John,

Thanks a lot for your suggestion..

I ll try using Query() method but not sure whether it will meet my requirements.

Thanks again.

Priyanka

Hi John,

Yes the code works as a regular SP.

Seraching on the net i found out that 'sp_xml_preparedocument' is an extended Stored Proc..

So ideally I shd be able to execute...