Hi All
I am facing problem is SQL Server 2000, with OPENXML.
I am having data which i receive from some other database in form of xml doc. Now I have to use this xml data as JOIN with MS SQL 2000 database table. But as everybody aware that using OPENXML directly in JOIN gives error sometimes (refer : http://support.microsoft.com/?kbid=279434 ) so I intend to use (local variable) Table datatype to get data from xml and then use this table as JOIN with my sql 2k tables. For this I am trying to write UserDefined function in sql 2k (for reusability purpose), however UDF is not allowing me play with OPENXML :(
Could anybody tell me how can i make reusable function for this?
Thanks
Makarand
