Waldar's SQLing and Datawarehousing Place

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 of ANSI SQL but is supported in both SQL Server 2005+ and Oracle 11g.

First, I’ve got to assign an unique identifier to the rows of the table. Continue reading ‘My TSQL Challenge 10 Pivot-UnPivot Solution’

After being very whiny, Ozh send me some corrections in the php header and sidebar files.

I could revert my theme change back to the dark and red layout !
It’s funny how in only two months I could be involved in a visual relation to this blog.

But those three days with greyville taught me that I have better readability, and my sidebar can also be improved.
I’ll try to dig this subject whenever I’ll have some spare time.

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 handling those kind of queries.

Providing such valuable resources which is quite time consuming, for free, is really a nice move, that I’m supporting with passing important news about them over here, this is the least I can do for them.
Continue reading ‘TSQL Challenge #10, How To Process Horizontal Sorting’

Even if I did like very much the old RGB theme, mostly due to the red lines breaking the dark grey and white colors, I upgraded this blog to WordPress 2.8 and I had the bad surprise to have my sidebar broken.

Having absolutely no idea on how to fix it, I’ve looked after another theme.

My focus when finding a theme is first to be easy to use and easy to read.
I really don’t appreciate overcharged nor overcolored content when reading something.

As a blog beginner I really don’t need most features other blogs possess, two columns is nice for me, and fixed width is better for reading purpose in my mind.
Continue reading ‘WordPress 2.8 And A New Theme’

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 it was a bit harder that I first thought.
With the help of Tomas “MyMaster” Kytes I could find ideas and piece of code which are a more generic treatment of the issue, so it deserves it’s own post.
Continue reading ‘Using Analytics To Handle Breaks’