Just a quick FYI -- avoid using pie charts as a visual means to display data; better to use bar charts. Here's a link to an excellent article on Stephen...

Thanks Steve. That was my interpretation as well that the pipe indicates "or" -- I just needed confirmation.

So, they were making you volunteer?

Granted, it's hard to demand payment from friends & family, but if offering...

JJ B -- Thanks for beating the drum a tad louder about the definition of volunteering: no one gets paid to volunteer.

Getting back to Phil's emotional state (and perhaps the...

peter-757102 (9/13/2010)

---

Why would charity be totally unpaid for, isn't that unrealistic?

I can accept it will be a bare minimum if its true charity and not one of those big aid...

There's a Chinese proverb I've always liked for my own self-censorship:

"You want no one to know it?... Then don't do it."

My "aha" moments don't usually come from my colleagues, but rather from various gurus out here in internet-land: Itzik Ben-Gan, Peter Larsson ("Peso"), Sean McCown, Joe Celko, Barry Young, Jeff...

Dom:

Interesting solution -- is your problem situation based on a local (development) setup (IE8, SSRS, and AVG all on the same box)?

In my case, I have to connect to a...

Soon after posting my question, I stumbled upon the following links that may provide a solution:

http://www.julian-kuiters.id.au/article.php/ssis-lookup-with-range

http://blogs.msdn.com/mattm/archive/2008/11/25/lookup-pattern-range-lookups.aspx

If anyone has additional suggestions, please feel free to share.

Thanks for the best practices link!

My boss isn't against Execute SQL tasks, but merely a proponent of using SSIS as an ETL tool where data manipulation is fairly visible/obvious, rather...

Thanks for the quick replies. I kinda guessed that Aggregate could serve the purpose, but will go with SQL nonetheless.

I'm developing a dimensional data warehouse and my boss prefers that...

Dom,

I don't have an answer for you. I just wanted to chime in that I've been experiencing plenty of sporadic problems with IE8 and Report Manager as well (on Windows...

Gianluca, this is great.

I was just starting to draft a script using Cross Apply when I noticed I'd received a response to my post in my email. You beat...

Sasidhar Pulivarthi (3/29/2010)

---

For Cross tab reports you should go for Matrix Reports.

Ex: Ths student attendance report

take the date attribute as cross tab and Student name as Row wise.

...

Great idea -- sounds like a plan.

Thanks,

Pete