Problem with OPENXML in UDF

Expand Post »

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

Similar Threads

SQL Question in MS SQL
'CITY' is not a recognized optimizer lock hints option in MS SQL
Problem with Windows Update and WinXP in Web Browsers
Problem stopping thread (I think) in Mobile Development
UDF in MySQL in MySQL

Makarand_Keer

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Mar 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: MSDE help needed

Next Thread in MS SQL Forum Timeline: vBulletin email notifications not working

DaniWeb Message

Cancel Changes

User Name
Password