I'm sure that there's a more efficient solution in 2012 using LEAD() but I don't have access to a 2012 instance right now.

WITH wos AS(

SELECT Id,

...

Maybe something like this:

SELECT

,[DATE]

FROM [dbo].[DATA]

WHERE ( = '12345' OR = '67890')

GROUP BY , [DATE]

HAVING...

Did you leave something out of your post? There seems to be no reason to have the 3 left joins in that query as it is.

If your int looks like 20141022 (for today's date), you need to convert it to char(8) and then to date. If it's a numeric value representing the date as 41932...

I really feel bad for this guy. He keeps posting weird problems about SPs full of bad practices. I'm sure that he isn't the problem and the problem comes from...

Ed Wagner (10/22/2014)

---

Isn't it interesting how so...

Do you mean, something like Brent Ozar [/url] or Ola Hallengren[/url] scripts?

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food....

Eirikur Eiriksson (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

Luis Cazares (10/21/2014)

---

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a...

Do you have a BEGIN with no END?

Eirikur Eiriksson (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so now I'm...

Do you have something else in your code? Are you missing an end?

Your pivot statement is correct, your syntax error might be elsewhere.

I'm not sure that CONVERT alone can help.

Here's an example on how to group by weeks with unusual start days.

WITH E1(N) AS (

...

kd11 (10/21/2014)

---

I'm not clear on the last statement line From (Values........ Also if I use todays date and run the first three lines of code, the CorrectedVersion Date is...