Waldar's SQLing and Datawarehousing Place

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 [...]

This is the query I sent to the TC team. I published it when I sent it, but they prefer to keep solution secret as long as the closure date isn’t in the past, which I can understand.
I had fun using PIVOT and UNPIVOT operators to reduce the query size.
PIVOT / UNPIVOT syntax isn’t part [...]

Beyond Relational have released their last T-SQL Challenge, it’s already number 10 !
French version has been translated on Antoine Gémis’s blog.
Jacob Sebastian and the TC team is really active and involved in helping people to improve themselves with SQL and T-SQL.
For this challenge they offer a Free Training Webcast for those who have problems in [...]

When trying to solve last T-SQL Challenge I did find a query which fits well in both SQL Server and Oracle (with some syntax tweaking) and seems quite effective to me even on a ten millions rows table.
I said I’ll try to use the more advanced analytics function of Oracle to solve the problem, and [...]

Beyondrelational published their new TSQL Challenge #9, and as usual Antoine Gémis translated it in french.
They have taken redefined the goal about those challenges which I think is a very nice move.
The goal of TSQL Challenges is to help people enhance their SET based query writing skills.
Most of the times, a SET based query performs [...]