DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   MS SQL (http://www.daniweb.com/forums/forum127.html)
-   -   Problem with OPENXML in UDF (http://www.daniweb.com/forums/thread19584.html)

Makarand_Keer Mar 4th, 2005 4:42 am
Problem with OPENXML in UDF
 
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


All times are GMT -4. The time now is 2:34 am.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC