Hi all,

I'm writing few pieces on XML operation's performance in SQL Server, both generating the XML, parsing it and operations on it and I'm wondering if anyone has any particularly...

Post the DDL (create table) script, sample data as an insert statement and the expected results.

😎

David Burrows (9/19/2016)

---

Ed Wagner (9/19/2016)

---

ChrisM@Work (9/19/2016)

---

You're going to need a pair of those. The OP (or should that be "perp"?) has been...

dimpythewimpy (9/19/2016)

---

Can someone suggest a workaround for this. I have researched online and tried inline function but,that didn't work as I am not returning a table here. It is just...

Now where is that crystal ball again?

😎

Here is a quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA_1818603') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA_1818603;

create table dbo.TBL_SAMPLE_DATA_1818603

(

dates datetime

,customer int

,ind_1 smallint

,ind_2 smallint

,ind_3 smallint

,ind_4 smallint

)

insert into dbo.TBL_SAMPLE_DATA_1818603

...

Quick question, why is the latest date in the sample set 2015-03-01? This means that the data is all excluded by the requirements.

😎

This weekend is the Open House weekend in London, just wondering if SSC is participating in something similar like Open Spam:pinch:

😎

sqlfriends (9/16/2016)

---

I have a developer wrote code using a lot of CTEs in a stored procedure.

Basically, one CTE call another CTE call another CTE.

CTE is sometimes easy to understand, but...

TomThomson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat...

Good job and thanks for...

Phil Parkin (9/16/2016)

---

Jacob Wilkins (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid...

Jacob Wilkins (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight...

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat more...

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more...