J Livingston SQL (7/11/2016)

---

ChrisM@Work (7/11/2016)

---

Following on from this, I had a few hours to spare on Saturday morning to spend on JLS' test harness.

IBG's first query looks like this:

SELECT...

Jeff Moden (7/7/2016)

---

ChrisM@Work (7/7/2016)

---

You might find this version a little easier to follow than the IBG original and it only reads the data once, so it's quite a bit quicker:

;WITH...

Following on from this, I had a few hours to spare on Saturday morning to spend on JLS' test harness.

IBG's first query looks like this:

SELECT code, startdate AS ts,...

Raghavender (7/8/2016)

---

ChrisM@Work (7/7/2016)

---

Raghavender (7/7/2016)

---

in the stored procedure if we change the substring in condition to like its working if we set the compatibility level to 120, where as with substring...

That's awesome G - I've been in and out of meetings all day so haven't had a chance to play yet, but I bet there's some tweaking potential!

Sangeeth878787 (7/8/2016)

---

Hi,

I am trying to load select output result into variable, but I am not able to achieve either using SET or Select method.

Eg @

declare @v-2 varchar(max) =...

Luis Cazares (7/7/2016)

---

Nice Chris, I hope that this helps Eliseo.

I think that I understand what you're saying about the TOP filtering before the aggregate, even if the execution plan indicates...

Raghavender (7/7/2016)

---

in the stored procedure if we change the substring in condition to like its working if we set the compatibility level to 120, where as with substring in condition...

It is compatible. Can you tell us more about the issue you have with it?

After a bit more fiddling with this, I can get stable and predictable behaviour using an index tailored for my specific query. Adjusting it for the OP's environment yields this:

CREATE...

This was using local data but I could share actual plans with you privately?

That was my first thought too Luis so I set up a...

You might find this version a little easier to follow than the IBG original and it only reads the data once, so it's quite a bit quicker:

;WITH DateSequence AS (

SELECT...

BWFC (7/6/2016)

---

ChrisM@Work (7/6/2016)

---

BWFC (7/6/2016)

---

Phil Parkin (7/5/2016)

---

tindog (7/5/2016)

---

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We...

So your range might be several days long, capturing...