Posted by rojelio on 11/28/07 19:53

Here's my issue. I'm tracking product interest so to speak. Each
time a user clicks on a product the userid, product id, and date is
tracked. Now users usually look at their products of interest several
times. So everytime they click the same product it is tracked as
well.

So as an administrator I want to look at the product to see who's
checked it out and how many times (ie interest level).

Here's what I have now
A.A. - Last Access: 11-12-2007 Total: 2
B.B. - Last Access: 11-26-2007 Total: 2

I can onlly get distinct user and order by name. Then while looping
get the last access date.

But I want the most recent person whos looked at the product to be on
top and don't want see A.A... multiple times.

Anyone have any ideas?

• Next in forum: Getting System Time From SQL Server
• Prev in forum: Function that replaces ntext and compares ntext with nvarchar
• Thread view: Distinct Name with Date Order By Date

[Reply to this message]