Member Avatar for Makarand_Keer
Makarand_Keer 0 Newbie Poster

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

  • 1 Contributor
  • 0 Replies
  • 62 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.