ช่วยแนะน้ำวิธีเขียน sql ให้หน่อยนะค่ะ เขียนมาตั้งนานจนปัญญาจริงๆค่ะ

declare @colNames varchar(4000)
declare @colValues varchar(4000)
declare @query varchar(8000)

select @colNames = coalesce(@colNames + ', ', '') + 'isnull(' + t1.Date + ', 0) as ' + t1.Date from 
	(
		select distinct '[' + convert(varchar(10), [Date], 103) + ']' as [Date] from TblStatus 
	) t1

select @colValues = coalesce(@colValues + ', ', '') + t1.Date from 
	(
		select distinct '[' + convert(varchar(10), [Date], 103) + ']' as [Date] from TblStatus 
	) t1

set @query = N'select ID, ' + @colNames + ' from 
	(
		select ID, [Date], [Status] from TblStatus
	) p pivot
	(
		sum([Status])
		for [Date] in (' + @colValues + ')
	) as pvt
	order by ID'

execute(@query)