rating in website

sort by date mye be create proble try this,

select  top 10 furniture_ch.[id],
furniture_ch.name,furniture_ch.[address] , COUNT(furniture_ch.name) as [count] 
from furniture_ch inner join furniture_p on furniture_p.behcode = furniture_ch.behcode 
where furniture_ch.f_code = 1 and furniture_p.date <= GETDATE()
group by furniture_ch.[id],furniture_ch.name,furniture_ch.[address]
order by [count]  

use following query in your store procedure,

it gives you result what u want

select  top 100 furniture_ch.[id], 
furniture_ch.name,furniture_ch.[address] , COUNT(furniture_ch.name) as [count]  
from furniture_ch inner join furniture_p on furniture_p.behcode = furniture_ch.behcode  
where furniture_ch.f_code = @F_Code and furniture_p.date <= GETDATE() 
group by furniture_ch.[id],furniture_ch.name,furniture_ch.[address] 
order by [count] desc

use following query in your store procedure

select  top 100 furniture_ch.[id],  furniture_ch.name,furniture_ch.[address] 
into #furniture   
from furniture_ch inner join furniture_p on furniture_p.behcode = furniture_ch.behcode   
where furniture_ch.f_code = @F_Code  order by furniture_p.[date] desc
select id,[name],[address], COUNT([name]) as [count] from #furniture
group by Id,name,[address]order by [count]drop table #furniture