Viewing 5 posts - 1 through 5 (of 5 total)
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...
September 22, 2014 at 11:40 am
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...
August 19, 2008 at 3:45 pm
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...
February 29, 2008 at 12:37 pm
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...
February 29, 2008 at 11:07 am
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...
October 4, 2007 at 10:01 am
Viewing 5 posts - 1 through 5 (of 5 total)