Forum Discussion
Skip parsing blank XML
Thanks, but your example assumes reading the XML from a file. My XML is in a SQL Server database column.
I'm guessing what I want to do isn't really doable given the complexity and volume of data.
I would go back to SQL views that parse the XML directly, and I would do separate views that focus on the individual parts. Then you can use Power BI to bring at least some resemblance of a data model into play.
I started out trying to do all this in SQL using XQUERY but got nowhere at all. I was actually able to use string functions in my SQL to parse out the pieces, and it works fine, but the performance is horrendous.
What's the "make and model" of your SQL Server? Do you know the db admin?
And SSMS v20.
SQL Server 2012 ? I'm impressed that this thing is still alive. See if you can negotiate an update to something a little more contemporary - newer version have much better XML support.
I'm just a contractor for Commonwealth of Massachusetts; there's no way I can make that happen.
I figured as much. Make sure to manage your client's expectations.
Greetings from around the block.
Thanks so much!
Hi johnjbolduc
Did the solution lbendlin offered help you solve the problem, if it helps you can consider to acceot it as a solutio so that more user can refer to.
Best Regards!
Yolo Zhu
Unfortunately, no. My XML is much too complicated for anything offered here.