Hi,

i have a xml file c:\abcd.xml in my local filesystem.. i just want to
take the path as in parameter for a stored procedure and insert the values
into a table type variable

execute usp_xx (@xmlpath='c:\abcd.xml')
-- inside the sp i would like to read the xml file and insert the same
into a table type variable..

Can anyone tell me the idea..


nsr

--
Message posted via http://www.sqlmonster.com

You should read the file on the mid-tier/client and send the data as a
stored proc parameter value in SQL Server 2000. SQL Server 2005 will have a
way to read from files...

Best regards
Michael

"narasimha rao chandramouli via SQLMonster.com"
<forum (AT) nospam (DOT) SQLMonster.com> wrote