Column Headers To Row Headers in sql server

--Create Dummy test table and insert data
Declare @t table(num int, descr varchar(20), [value] decimal(9,2), date smalldatetime)
insert into @t
values(101,'Blue Skirt', '20.00', '01/01/2008')
insert into @t
values(102,'white socks', '5.000','12/03/2009')
insert into @t
values(110,'blue shirt', '10.00','01/12/2010')
insert into @t
values(200,'Red Tie', '15.99','05/03/2010')
insert into @t
values(350,'Black Belt ', '100','02/09/2011')
--Test Results
Select num, descr, [value] from @t
--Declare our Variable for the first Column Header and set date as the header Column
Declare @s varchar(8000)
Select @s=COALESCE(@s+''',''','')+cast(num as varchar(10)) +'''as'''+ convert(varchar(10),date,3) from @t
--Declare our second Row Header data
declare @v varchar(8000)
select @v=COALESCE(@v+''',''','')+ descr from @t
--Declare our Third Row Header data
declare @l varchar(8000)
select @l=COALESCE(@l+''',''','')+ cast([value] as varchar(10)) from @t
--Execute all variables as well as inserting our Coulumn header
Exec('Select ''ID'' as ''Name'','''+ @s + ''' union all select ''Item'','''+ @v + ''' union all select ''Price'',''' +@l + '''' )