RE: Help with Proper SQL to Limit number of rows

2003-04-02 Thread Roger Davis
? Or if someone has a better solution I would love to here it. Roger -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:18 AM To: Roger Davis; [EMAIL PROTECTED] Subject: Re: Help with Proper SQL to Limit number of rows Hi Roger, > Q

Re: Help with Proper SQL to Limit number of rows

2003-04-01 Thread Jeff Kilbride
Hi Roger, > Quick rundown. > > Table: > > Assignments > CaseID auto_increment > FileNumber char(18) > FirstName char(20) > LastName char(20) > and on and on and on > Indexes on > CaseID (Primary) > FileNumber > Name (LastName, FirstName) > > What I would like to do is something along the lines of

Help with Proper SQL to Limit number of rows

2003-03-31 Thread Roger Davis
Quick rundown. Table: Assignments CaseID auto_increment FileNumber char(18) FirstName char(20) LastName char(20) and on and on and on Indexes on CaseID (Primary) FileNumber Name (LastName, FirstName) What I would like to do is something alo