CH-328334 (4/5/2016)

---

Hi,

I have an xml file ,which contains multiple namespaces and are having difficulty shredding it to obtain the values.

Here is the xml

<CommonApiResponseOfSuccessObjDataMR1gN5bk xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ProductionModels">

<Data xmlns:d2p1="http://schemas.datacontract.org/2004/07/ProductionModels.Shared">

...

drew.allen (4/4/2016)

---

No, the OP is...

Jeff Moden (4/4/2016)

---

coolchaitu (4/4/2016)

---

Job failed last night due to temp log consuming full disk space. Could you please advise on fixing this. Heard,Shrinking tempdb log file is not a good...

Jeff Moden (4/4/2016)

---

Eirikur Eiriksson (4/4/2016)

---

Jeff Moden (4/4/2016)

---

If all the rows were identical, then...

drew.allen (4/4/2016)

---

Eirikur Eiriksson (4/4/2016)

---

Here is a quick suggestion towards a solution, let us know if you need more assistance.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @XQUERY_STR NVARCHAR(MAX) = N'';

DECLARE @PARAM_STR NVARCHAR(MAX) =...

Jeff Moden (4/4/2016)

---

If all the rows were identical, then stats will only have...

Brandie Tarvin (4/4/2016)

---

At 11:55 p.m., my boss asked me if there was anything else he could do. At that point it was a one person job which I was working...

Quick question,...

TheSQLGuru (4/4/2016)

---

First and by FAR the most important let me say that this should be done OUTSIDE of SQL Server (unless you are going to be using the set in...

Here is a quick suggestion towards a solution, let us know if you need more assistance.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @XQUERY_STR NVARCHAR(MAX) = N'';

DECLARE @PARAM_STR NVARCHAR(MAX) = N'@TXML1 XML';

DECLARE @TXML1...

JKSQL (3/30/2016)

---

I have created code similar to below. This is slow since this is a very large table. Is there a way to make this into one call?

UPDATE...

Sachin Nandanwar (3/31/2016)

---

Why would you want to do string processing using TSQL ? Please see the attached image. I wrote this in C# in less than 20 minutes.It can be...

WhiteLotus (3/29/2016)

---

Hi All ,

I have just moved the databases from 1 server to another server (I performed Attach detach method for user databases )

When I checked in SQL error log...

Alan.B (3/25/2016)

---

Anyone want to take a stab at this. Essentially the OP needs a csv splitter that handles text qualifiers; Eirikur Eiriksson's RFC-4180 compliant splitter from this article: This article[/url]...

Hugo Kornelis (3/29/2016)

---

Eirikur Eiriksson (3/29/2016)

---

Quick thought, the first (union) query will use two index seek operators (if the correct indices are in place) while the latter does a single scan....