Moved to http://beyondrelational.com/blogs/jacob/archive/2007/12/09/passing-a-data-table-to-a-sql-server-2005-stored-procedure.aspx
Hello, I am trying your code and I get the following error message. Can you help?Msg 170, Level 15, State 1 Incorrect syntax near '.'.When I double click on the error is highlights FROM @data.nodes('/NewDataSet/Table') as x(d)
I am also getting the same error..How do we solve this?I know this is an old post.. But since I am getting the error I figured I would ask.Thanks!
This is nice sample code. I've used it and it works without any error.Indra Bisen
I see two comments that mention an error. I could not figure out what is the problem. The script runs correctly on a few computers I tested.If you have any issues with this code, contact me at jacob[dot]reliancesp[at]gmail[dot]com and I will help you to fix it.
Posts
Hello, I am trying your code and I get the following error message. Can you help?
ReplyDeleteMsg 170, Level 15, State 1 Incorrect syntax near '.'.
When I double click on the error is highlights FROM @data.nodes('/NewDataSet/Table') as x(d)
I am also getting the same error..
ReplyDeleteHow do we solve this?
I know this is an old post.. But since I am getting the error I figured I would ask.
Thanks!
This is nice sample code. I've used it and it works without any error.
ReplyDeleteIndra Bisen
I see two comments that mention an error. I could not figure out what is the problem. The script runs correctly on a few computers I tested.
ReplyDeleteIf you have any issues with this code, contact me at jacob[dot]reliancesp[at]gmail[dot]com and I will help you to fix it.