Re: Witango-Talk: Incremental Count of Subgroup Instances

[Charles Brown]

MS-SQL Alan Wolfe wrote: Hey Charles, sounds like you are in need of a view. what database are you using? ----- Original Message ----- From: "Charles Brown" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2003 5:16 PM 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf