Brandie Tarvin (10/5/2016)

---

I'm trying to figure out how this works. Is the + the extra hair on one or more of the cats? (cause often I've brushed my...

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point so I did my...

It could be a language thing. As in the first comment they...

Oh Man!

I'm player down... Looks like a questionable Bryant is now out of the game on Sunday...

Rodders...

Hi Eirikur,

Looks good. Many thanks.

I've tested it with various permutations.

The person who passed it to me, has tested it, and is happy.

Now to run against the entire data set and...

Hi Eirikur,

I think I owe you a large drink next time I see you!

I had started working on the basis yesterday that you had to split the query in two...

Many thanks.

Let me know if you want the 13 person one uploaded. As the additional extras are all over the place in that one! But going to take a while...

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...