Tag Archives: xml

Loading XML Data–CONVERT Option 2

Posted on August 6, 2015 by way0utwest

I was playing around with some XML lately, and had to load a file that looked like this:: I ran a simple query, one that used the OPENROWSET and a CONVERT to load the data. WITH XmlFile (Contents) AS ( … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Parsing SQL Saturday Data – Getting Titles from the XML document

Posted on February 25, 2015 by way0utwest

I’m continuing on with my project to grab SQL Saturday data and automatically insert it into a SQL Server database. In this piece, I’m picking up from the last one where I had a loop to load all XML documents … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Parsing SQL Saturday Data – Getting Titles from the XML document

Parsing SQL Saturday Data – Looping Through And Loading All XML Files

Posted on February 18, 2015 by way0utwest

After my last post on parsing the XML, I decided to continue forward and get ready to put the data in a database. For that, I’m really looking for this data: event ID session title With this, I can easily … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Parsing SQL Saturday Data – Looping Through And Loading All XML Files

Parsing SQL Saturday Data – Getting the Titles

Posted on February 2, 2015 by way0utwest

I wrote about downloading the SQL Saturday data with Powershell, and that has worked well. However, I also need to parse this data. You can look at a sample XML file from the site with this link, and examine the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Parsing SQL Saturday Data – Getting the Titles