Charles, Do you really need to know when the x visit was, or could you get by with the date of last one and total number of visits. Then you could make a view or a select something like this:
select username, (max(visit_date)), (count(*)) from visitTable group by username If you just want one use add a where clause before the group by "where username = @@myuserbar" Troy Sosamon -----Original Message----- From: Charles Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 6:17 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Incremental Count of Subgroup Instances This has got to be easier than I am making it. I have a table of client id numbers and their visit dates. I need to sort by the client id and date and assign the number of their visit - from 1 to n. - in a visit# field on the corresponding row in the table. So, for example, visit #4 for Fred was on 12/21/2003. Please speak real slow when responding to this request for assistance. I am not real quick on the uptake today. Oh yeah, the table has over 90,000 records in it, so I can't just give up and do it by hand. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
