The keywords you want to use to search for are either PIVOT or CROSSTAB. Either method will work for you.

Can we see the DDL for these tables, and if you have one available, the actual execution plan of what you've written up so far that's running poorly?

Do you have...

Luis Cazares (2/19/2014)

---

sql2k8 (2/19/2014)

---

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to rewrite the code...

Yeah, a smaller index. Also, you can't get...

Sorry, I should have been more clear. What's...

Tally Table is perfect for this. Hit the link in my signature on it.

Ah, that's a VERY different statement,...

Your problem is at the top of the stack.

There's something in the source...

You would do this in either...

elee1969 (2/19/2014)

---

Evil Kraig F (2/19/2014)

---

elee1969 (2/19/2014)

---

My first question is within the query it grabs data with a year date of 2015. Next july 1st the users would need it to...

Congratz Jason. May you have many more years of helping people here.

elee1969 (2/19/2014)

---

My first question is within the query it grabs data with a year date of 2015. Next july 1st the users would need it to change to 2016. ...

justin.jones 30639 (2/18/2014)

---

Not only is this to look for performance metrics, but also to look for data integrity issues.

Thank you for the quick response! I can definitely work through...

Just so you know, your data's a hair off, the start times seem a little out of sync (See rn #3 for 1439), but this is the basic gist:

/*

CREATE TABLE...

Right, so what's the problem? ...