Added the Union All to the test harness

😎

USE TEEST;

GO

SET NOCOUNT ON;

--http://www.sqlservercentral.com/Forums/FindPost1817858.aspx

-- TEST HARNESS

DECLARE @timer TABLE (

T_TXT VARCHAR(50) NOT NULL

...

Here is a simple test harness which you can use

😎

USE TEEST;

GO

SET NOCOUNT ON;

-- TEST HARNESS

DECLARE @timer TABLE (

T_TXT VARCHAR(50) ...

Jeff Moden (9/14/2016)

---

Eirikur Eiriksson (9/14/2016)

---

Jeff Moden (9/14/2016)

---

Not guaranteed to be true, though. Because of...

Almost there, just needed a little adjustment 😉

😎

SELECT

ACC.AccountUID AS 'AccountUID'

,ACC.AccountID AS 'AccountID'

,(SELECT

...

Phil Parkin (9/14/2016)

---

I try...

Not only is it more contorted but also...

:pinch: Memory failure :pinch:

The cross apply will produce...

mahi123 (9/14/2016)

---

Thanks for your help..

But requirement is need to generate XML in one folder , and whenever i open the XML XML need to have a header with <?xml version="1.0"...

Hi Phil,

are you running the latest version with the latest updates? Had this problem few updates ago and after one update it went away.

😎

drew.allen (9/14/2016)

---

I was actually wondering whether it would be more efficient to sum before the CROSS APPLY or after. I ran a simple test, but it was impossible to...

Jeff Moden (9/14/2016)

---

Not guaranteed to be true, though. Because of the translations, as unlikely...

Makes you wonder what the purpose is and English certainly not being OP's...

ChrisM@Work (9/14/2016)

---

It's the Right Stuff:-D

😎

Quick suggestion

😎

BTW DON'T USE the FORMAT function!

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @LINE_TEMPLATE VARCHAR(50) = '000000000 ...

Jeff Moden (9/14/2016)

---

Although that's great use of the CROSS APPLY trick to unpivot, the output isn't the same as the requested output, which appears to be a sum for each...