SQL behind Business Intelligence
TSQL Challenge #13
My previous post was a very long one and it took me several hours just to write it properly, plus many hours to do the findings (which was a part of my day job, but most of the tests were done at home).
Having zero comment is a little frustrating to be honest, I [...]
TSQL Challenge #12
I’m a bit late on this one !
The last submition date for TSQL Challenge #12 was yesterday !
But I had some holidays and the weather was sunny so I spend less time on my computer !
I couldn’t use (nor understand) the arithmetics Pacmann used in the comments of the previous blog entrie.
He managed [...]
NoCOUG Challenge
After many months, Iggy Fernandez published his own solution of the first annual NoCOUG SQL Challenge.
His solution was performing fast from the beginning according to the graph he sent to Chen Shapira back in the announcement days :
I never managed
Here is my proposal about the TSQL Challenge #11.
Given a product table, and a coupon table, we have to find within one or two coupons which combination gives the best discount, with additional rules :
the discount price can not be less than 70% of the original price
the total amount of the discount can [...]
NoCOUG
Well, I'm not really comparing comparable numbers here.
The NoCOUG last submit date was the last day of june, and therefore it is past.
Iggy Fernandez wrote about the nine different solutions he received (I very like the title he has chosen) !
I'm the seventh in the list there.
As I told before, my favorite solution to this [...]