Heh... I wonder if the use of UNPIVOT constitutes cheating too much in this case?

Still, some awesome code... Thanks Jeff W and Peter. I really didn't think it could...

Haven't checked it for accuracy, but that's more like it... getting real close to the Cross Tab version of the code for performance. Thanks, Peter.

jcrawf02 (6/23/2008)

---

Nothing is new under the sun, Jeff. Experts are expert by being able to concisely compile information and explain something, not necessarily make it up.

I'd buy the...

Nah... I knew great minds like yours would eventually show up... Besides... I didn't want to get one...

Anirban Paul (6/23/2008)

---

Jeff I believe you are tired of getting words like 'Excellent', 'Awesome', 'Great', etc for your. So I will suggest you this time one thing. Start writing books...

Jeffrey Williams (6/22/2008)

---

Okay, it can be done in a single pivot - but I had to cheat and performance will probably suffer. As far as I have been able...

rbarryyoung (6/22/2008)

---

Heh. What were we saying just yesterday about posters and their...

Jeffrey Williams (6/22/2008)

---

I don't think it is possible - and, you have to use the derived table (or a CTE) or you get some very interesting results. Try to...

Thanks, Jeff! Great example of how to do it with 2 derived tables... 🙂

Does anyone know how to do it using a single pivot or are we relegated to...

Heh... in this situation, you're rebuilding the view! It's gonna recompile no matter what... 😉 Works fine in production code especially in 2k where there's no such thing...

Just in case someone wants to "play", here's the Cross Tab code I'm trying to duplicate with a single pivot...

SELECT Company,

Year,

...

You want sample code? Then provide some sample data. Please see, read, understand, and follow the article in the link in my...

venki (6/22/2008)

---

Do we have for loop or for each statement in SQL Server?

I tried to use the for loop in my stored procedure but I haven't found it's working and...

Whether you use SELECT * or not, if you want to see the table changes in a view, you have to recompile the view. Like Barry said, this is...

Save us all some time... post the stored procedure that you're trying to convert into a view.