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
Well, this was a long wait for every participant of this challenge.
I entry the contest in April, and the winner has been announced yesterday by Iggy Fernandez and Chen Shapira.
It was indeed an amazing challenge and I thanks everyone who brought this up.
It was also the key factor for me to open this blog to [...]
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 [...]