a_ud (3/19/2015)

---

Thanks for your help, Matt !

I take your advice on risk. However, the source being Pubmed, chances that the file is corrupt are tiny. In other words, you...

mister.magoo (3/19/2015)

---

Matt Miller (#4) (3/19/2015)

---

Keep in mind that in the definition of XML, those are NOT equal. In "strict" XML (per W3C), XML is consider to be a...

Brandie Tarvin (3/18/2015)

---

The sad thing is, almost every guy when offered this perspective, always replies "I don't think I'm like that." None of them every say "I'll pay attention when...

siggemannen (3/19/2015)

---

This is part of SQL Unit-tests, so need a TSQL solution :/

HASHBYTES will give different results for following two xmls:

<xml>

<attribute1>1/<attribute1>

<attribute2>2/<attribute2>

</xml>

<xml>

<attribute2>2/<attribute2>

...

So as far as I can tell from the XML snippet you posted - the line you're worried about would in fact return content and should return "D." (assuming there...

a_ud (3/11/2015)

---

Thanks Alan. I get you've got a much higher XML level, but I simply cannot to redesign the whole SP (lacking expertise on that !!). What I'd appreciate is...

JeeTee (3/9/2015)

---

Ill play around with that; thanks. Do you know if theres any way to do it all from one server? its not a huge pain but in a perfect...

--duplicate post--

Try "joining" the two. Easiest way is to cascade the cross apply statements, i.e.

SELECT

r.t.value('(.[1])/@CustomerId', 'bigint') as CustomerId,

b.value('.[1]','varchar(2000)')

FROM

...

One small-ish tidbit: you want to be VERY clear about what is expected when the sample set doesn't evenly divide into the chunks you've decided on. In your case...

Jeff Moden (3/3/2015)

---

Matt Miller (#4) (3/3/2015)

---

By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)

http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/%5B/url%5D

That said - you're...

Is there any chance you might be running up against the halloween problem?

http://en.wikipedia.org/wiki/Halloween_Problem

By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)

http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/%5B/url%5D

That said - you're still right - it wouild...

+1

that way you can include it in indexes...

Katerine459 (2/27/2015)

---

Thanks for the general info... I'll check it out. I don't know that I'll use it for this specific thread, though (I'm thinking of using Luis Cazares's solution, once...