I found a solution I believe to work provided by Hilaire, but I am unsure of how to get the results. The solution I found is here: http://www.experts-exchange.com/Database/Miscellaneous/Q_21390833.html?sfQueryTermInfo=1+openxml
. I was able to create the stored procedure but when I run that last bit of code to work the magic I get 0 results. I did change the path to a valid XML file located locally.
I am trying to read a very large XML file in SQL so that I may query it and put certain records in an existing database.