You're welcome Stan.

While I'm at it, anything (whether the R2 feature or any other technique) that has to deal with Excel tab names dynamically also should deal with...

habk24 (3/30/2012)

---

The issue in not how do I rename the tab in Excel after it has been created. When setting up subscriptions in SSRS, it would extremely difficult to...

Actually there is such a method -- and I've shown it here -- http://spacefold.com/lisa/post/2007/10/03/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx -- and there are lots of followup posts on my blog because people seem very interested...

To the OP: You can't use the code you originally supplied, I think for several reasons:

* it will go out to the network versus looking at the local machine

*...

>>God Lord Celko

Good Freudian typo, dude 😉

Actually, Jeff, in this case, I look at it as "put up...

charles.southey (3/23/2012)

---

Yes - it's relevant to the article and provides a possible solution for those grappling with the problem under discussion that they may be looking for. We would never...

Exactly the same thing as what's wrong with mine (I used TOP <expr> rather than a WHERE clause): we're not limiting...

This is exactly what was meant Lisa - however, when you look at the EP, how many rows are actually generated? This may well be the maximum amount, which is...

Hi Jeff, I'll have to look into it at home - this gig is 2k5 only 🙁

I did a lot of work on exactly this subject, attempting to limit the...

Regarding the display order of months, I was trying to say that the original spec was (IMHO) really flawed.

Regarding the language thing... while it wasn't a flaw in the...

Phil Factor (3/13/2012)

---

The original code that was presented will work for any language setting. That's important. Scooping out the contents of sys.syslanguages will only work if you do it according...

Antares686 (3/13/2012)

---

Just because I was in the mood for a little fun but another option is to use the syslanguages table to get the information like you want. There is...

Hi and congrats, but......

jcb (3/8/2012)

---

Anyway is how to implement where lies the solutions in many cases (considering its a valid requirement).

So the questions are:

1. What you do when you get a bizarre job?

2....