Thank you Gail,

Wise words, always worth to stop and think before just start coding. Sometimes jumping to optimize is just a desperate measure caused by the pressure, but it...

Great Article! pivots are great because it exposes the same information in many ways very usefull ....

In your sample you build a pivot when you already now how many...

Thanks to all,

As some of you suggested, I been using a computed column for month and year and doing the queries over this columns, but I was looking for...

Hi,

First of all thank you, it's a good point to be considered. In fact, I use functions on the WHERE clause very often, specially when filtering dates ... how...

Wow! Thank you very much folks ...

Lowell, your approach does works but has the limit of two levels and I forgot to mention the account number format is variable, so...