Phil Parkin (1/27/2016)

---

Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros...

Just a guess but perhaps, before saving as Excel file, you could change:

<summary>Errors were detected in file 'C:\Users\\Desktop\WS_Print.xlsx'</summary>

To

<summary>Errors were detected in file ''C:\Users\\Desktop\WS_Print.xlsx''</summary>

Note the two single quotes instead of...

Can you explain what you mean by "line" and perhaps show us what the correct output would be for the sample data that you posted.

I don't fully get what you are trying to do here. Can you post some sample data that shows what the desired output looks like?

In the meantime, here's a...

Brandie Tarvin (1/26/2016)

---

TomThomson (1/25/2016)

---

I see the same. Plus in the EU it's probably illegal to host the...

ramana3327 (1/26/2016)

---

Hi,

We have an xml file in network share. I am not what are the columns in that xml files to insert into a table

SELECT * into XMLwithTest FROM OPENROWSET...

You did not attach anything. Can you attach the two versions of the query plans using just SSMS. I'm sure we can get to the bottom of this.

Ivanova (1/26/2016)

---

Sad to say, part of crafting a resumé which will pass the first stage of eliminations and get you in front of an interviewer may well be to omit...

No Namespace issues as far as I can tell. Here's a couple examples of how to parse your XML data:

DECLARE @xml XML =

'<xml xmlns:dt="urn:dt" xmlns:msxsl="urn:schemas-microsoft-com:xslt" dateofservice="1/1/2016 10:00" mmsid="201599999999" userid="dxxxxx9-xxx0-xxdb-xxx0-e8xxxxxxbcd" npid="dfxxxxx9-6xx0-xxxx-bxx0-exxxc1xxxxxd"...

Good editorial and good link to the StackOveeflow article.

I wonder how long resumes/CVs are going to be around. I could be wrong but kids in kindergarten today won't know...

Should I normalize the data and create a table for client, assessments, assessment data (joined by assesmentID and clientID foreign keys)? Or should I create a denormalized data warehouse?...

Expanding on what Eirikur put together, here's how you could do it against a table (note my comments).

-- Sample data

DECLARE @table TABLE(stringID int identity primary key, stringTxt NVARCHAR(4000));

INSERT @table(stringTxt)...

I am also a fan of Redgate, never had any problems with it (I also don't work for Redgate). It's been awhile since I last used it but ApexSQL Backup...

Eirikur Eiriksson (1/20/2016)

---

Alan.B (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue...

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for...