DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX)

select @cols = STUFF((SELECT ',' + QUOTENAME([date]) 
                    from  Table_1
                    group by [date]
                    order by [date]
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'')


set @query = 'SELECT [description],' + @cols + '  
            from 
            (
              SELECT 
                 a.[description],
                 a.[date],
                 a.qtt
                -- ,sum(a.qtt) as total
              FROM Table_1 a      
               group by [date],[description],qtt
            ) x 
            pivot 
            (
                max(qtt)
                for [date] in (' + @cols + ') 
            ) p ' 

execute sp_executesql @query;

quote:

---

Originally posted by sapator

I'll have a look tomorrow.Does this support sum of columns?
Thanks.

---