Let me start off by saying, I agree that temp tables are much more efficient that variable tables; and try to exclusively use temp tables. That said, you cannot...

SELECT 'January', 1

UNION ALL

SELECT 'February', 1....

I could be wrong here, but this probably would do the same thing with a lot less processing since you don't call and functions....cheers

Although I agree with you in keeping the script simple, I don't agree with the dynamic vs static. Month is one of those things you can garentee to be...

Users generally want to see it this way. Remember, we get it, but they generally do not!! 😛

That's assuming you have an order for each month. Additionally, his solution could perform faster depending on the number of rows in the "order" table.

The only thing I...