Thank you Drew, thank you DesNorton, I got it, it makes sense

thanks!

Thank you Koen

Question:

So let's say I have a default instance myServer of 2008R2 and its named instances

myServer\A

myServer\B

myServer\C

and now I want to side-by-side install 2014 having the same structure of A/B/C - do...

Thank you Kristen,

Not sure if deleting by FROM-TO is faster than by using TOP in my case...

Thanks All once again

Hi Lynn,

That's probably the case... so, basically there is no way to avoid it, except for such common sense things like keeping transactions short, read uncommitted, update statistics, right? No...

sgmunson (11/20/2014)

---

I'm pretty sure Mr. Magoo has your answer, but the bigger and maybe more important question, is why leave code hanging around that is formatted that way, when there...

Thank you Sir!

I felt so happy until I read

:hehe:

is it a typo or am I lost even more than I...

Thanks again for following it, and sorry if I'm still not making sense:-)

Let me try to start from the beginning:

- There is a table, Table1 in my example, that has...

"data" here is an xml field of Table 1, sorry I did not mentioned it initially

Thanks!

This is how original code looks like:

SELECT

CASE WHEN F1.value('...') IS NOT NULL THEN F1.value('...')

ELSE F2.value('...') END

FROM

...

sgmunson (11/19/2014)

---

I don't know the direct answer, but why place the ON clause for that LEFT JOIN in a position AFTER the CROSS APPLY unless you intended that CROSS APPLY...

Ok, getting there:-)

works fine, thank you once again

Journey goes on...

Now, what if I have two records and need something like

<instances>

<instance instanceCode1="Rec1_Code1" instanceCode2="Rec1_Code2">

....<CustomInformation>

........<ColumnValue name="Field1">11</ColumnValue>

........<ColumnValue name="Field2">22</ColumnValue>

........<ColumnValue name="Field3">33</ColumnValue>

....</CustomInformation>

</instance>

<instance instanceCode1="Rec2_Code1" instanceCode2="Rec2_Code2">

....<CustomInformation>

........<ColumnValue name="Field1">1111</ColumnValue>

........<ColumnValue name="Field2">2222</ColumnValue>

........<ColumnValue name="Field3">3333</ColumnValue>

....</CustomInformation>

</instance>

</instances>

?

I figured the external <instances>, the internal...