hi
This is in continuation of previous thread
http://www.aspforums.net/Threads/154902/rating-in-website/?s=2&p=1#Replies
hi vinayak this was your last query
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
that was useful for me
i have 3users that with your query the result was
|
id
|
name
|
address
|
| 1
|
paris
|
paris
|
| 2
|
india
|
india
|
| 3
|
china
|
china
|
it means user paris insert her first product recently
i want this
EG: when user india insert her new product after that user paris insert her first product
her name be at first row like this
|
id
|
name
|
address
|
| 1
|
india
|
india
|
| 2
|
paris
|
paris
|
| 3
|
china
|
china
|
or when user china insert other product in other time (not first time) her name be at first row
like this
|
d
|
name
|
address
|
| 1
|
china
|
china
|
| 2
|
india
|
india
|
| 3
|
paris |
paris
|
i want when users insert new product every time(not just first time) her name come to first
row of result
thanks
