I was doing another internal intro to DB maintenance session with the DevOps here.

And I used the GUI to create a backup script and scripted it out to a query...

OK so using the same test policy I've tried the following;

DECLARE @TXML XML = N'<?xml version="1.0" encoding="utf-16"?>

<AnswersDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Version>

<VersionNumber>100</VersionNumber>

</Version>

<HD key="HiddenRuntimeData">

...

Hi Eirikur,

After some more testing its not producing the desired results. I'm in the process of finding a couple of examples and anonymising the xml etc.

Cheers,

Rodney

Sequelsurfer (9/27/2016)

---

And then there was one.

Yup that's right, the one across the pond 😀 (or one of them, got a...

Eirikur Eiriksson (9/27/2016)

---

I'm just to lazy to write "(SELECT NULL)" when @@VERSION does the same thing, that is tells the...

Well my unbeaten run has come to an end then.

But hey I beat Steve last week, that makes my year! 😀

Rodders...

Hi Eirikur,

Thanks for your help. Much appreciated.

Oh and you can ignore the Tag_ID - its the primary key from another table. I shouldn't have included it in the results. Sorry.

Also...

Hi Eirikur,

Thanks for replying.

I'm actually on my way home.

I'll check when I get in.

I had to anonomise the data manually so I may have messed up something. Both the source...

Oh and a couple of other things. The non repeating tags (header and footer in my head) are counted as rank 1, along with the first repeating group. Its for...

Oh well, I've being going around in circles with a XML query problem for a couple of days.

XML not even next to the ball park of stuff I am comfortable...

Brandie Tarvin (9/19/2016)

---

I HAVE THE POWER!!!!

Someone at work gave me permission to start opening up software ticket requests (as in "we have this project" or "we need a bug fix")....

Steve Jones - SSC Editor (9/15/2016)

---

Hugo Kornelis (9/15/2016)

---

Anyone here planning to (or thinking about) going to Live! 360 Orlando?

As a speaker, I have been given a special registration code that...

Most people in the office are in a meeting. Just...

Talking of the crystal ball...

Yesterday, I had an email from the BI / DWH manager asking me to join the meeting... I looked in my calendar knowing that there wasn't...

Jeff Moden (9/13/2016)

---

BLOB_EATER (9/13/2016)

---

Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)

I have received 1000 views within the past 6 months which is...