The Problem is not retreving records in this format, but the Column Header must be Dynamic Date
--------------------------------------------------------------------------------------------
ProductId - Date 1 - Date 2 - Date 3 - Date 4 - Date 5
--------------------------------------------------------------------------------------------
1 - 234 - 989 - 876 - 7686 - 9878
2 - 34 - 99 - 876 - 66 - 87
--------------------------------------------------------------------------------------------
like this
--------------------------------------------------------------------------------------------
ProductId - 12-12-2008 - 13-12-2008 - 14-12-2008 - 15-12-2008 - 16-12-2008
--------------------------------------------------------------------------------------------
1 - 234 - 989 - 876 - 7686 - 9878
2 - 34 - 99 - 876 - 66 - 87
--------------------------------------------------------------------------------------------