Ma bad... must have been a little accident !!!

Hollly crap, that's funny!!! :w00t:

Looks like a world guiness long distance throw to me!!

Thanks for the info.

Is it the same performance than using inline code? I ask because in MS Access, that can really hurt you (not always)... same thing with a functino in t-sql.

What happened to those threads??? I can only find 2 refferences to them and there's no navigation to see the rest of the posts...

has it been rounded down to reduce...

208 posts on this one??? is that getting close to a new record or something?

I know... untill you start using sps that do DML, then you canget seriously screwed if you're not carefull... unsupported, I find another way!

Or another one :

SELECT Sex, COUNT(*) as Total FROM (SELECT Id, Sex FROM dbo.Table GROUP BY Id, Sex) dtName GROUP By Sex

--ORDER BY Total DESC

I just had the same problem... SSRS doesn't short-curcuit the IIF... meaning it evaluate everything regardless if the results (even that is inconsistant!!).

So you need the put the IIF again...

I'm just guessing here... but aren't #temp table transaction NOT logged?

One way to use your idea would be to create a db just to hold those results and put the...

WayneS (12/9/2008)

---

DiverKas (12/9/2008)

---

A better solution would be to use Crystal, ActiveReports or any other tool that does not require Excel, to export and format the data in an Excel format....

Just to put some oil on the fire... I just started working with SSRS and it beats the crap out of manually making excel files. Since it does not...

Thanks, and I also found later that under the group option in the general tab, there's a checkbox at the bottom that roughly says (translating from french) : Group Headers...

Thanks, sounds like a plan, let me test that on a backup copy of the rdl ;).

Still no info on the 2008/2005 test, I haven't had time to perform it...