use Tempdb
go
--> --> 
 
if not object_id(N'Tempdb..#T') is null
    drop table #T
Go
Create table #T([Name] nvarchar(5),[Date] Datetime,[Des] nvarchar(3))
Insert #T
select N'jason','2010-11-10',N'yes' union all
select N'barry','2010-11-12',N'yes' union all
select N'barry','2010-11-10',N'no' union all
select N'barry','2010-11-12',N'yes' union all
select N'jason','2010-11-10',N'yes' union all
select N'jason','2010-11-12',N'no'
Go
Select 
[Name],
sum(CASE WHEN  [Des]='yes' THEN 1 ELSE 0 END) AS yes,
sum(CASE WHEN  [Des]='no' THEN 1 ELSE 0 END) AS [no]
from #T 
GROUP BY [Name],[Date]
ORDER BY 1,2

/*
Name    yes    no
barry    0    1
barry    2    0
jason    0    1
jason    2    0
*/