![]() |
| ||
| 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