T-SQL PIVOT data from long form to wide by a date, Sql Server

Language: Layout:

create table t (id int, date date, num int, value int)
insert into t values
 (1,'2005-01-20',29,197)
,(1,'2005-01-20',28,58)
,(1,'2005-01-20',30,90)
,(1,'2005-02-08',29,210)
,(1,'2005-02-08',30,133)
,(1,'2005-02-08',28,67)
,(2,'2005-01-10',28,87)
,(2,'2005-01-10',30,119)
,(2,'2005-07-11',28,77)
,(2,'2005-07-11',29,174)

select 
    id
  , date
  , v28 = sum(case when num = 28 then value end)
  , v29 = sum(case when num = 29 then value end)
  , v30 = sum(case when num = 30 then value end)
from t
group by id, date
order by id, date

select
    Id
  , date
  , v28
  , v29
  , v30
from 
  (select id, date, num = 'v'+convert(varchar(10),num), value
    from t) as t
  pivot (sum(value) for num in (v28, v29, v30)) pvt
order by id, date
  
declare @cols nvarchar(max);
declare @sql  nvarchar(max);
  select @cols = stuff((
    select distinct 
      ', ' + 'v'+convert(varchar(10),num)
      from t 
      order by 1
      for xml path (''), type).value('.','nvarchar(max)')
    ,1,2,'')
select  @sql = '
 select Id, date, ' + @cols + '
  from  (
    select Id, date, num = ''v''+convert(varchar(10),num), value
      from t
      ) as t
 pivot (sum([value]) for [num] in (' + @cols + ') ) p
 order by id, date'
 
--select @sql
exec(@sql);

View schema
Execution time: 0,03 sec, rows selected: 14, rows affected: 10, absolute service time: 0,19 sec