> Is there a way to calculate this rank and return it as part of the query?
yes, but it's not efficient > instead, I could add TotalBilled and Percentage columns to the Clients table > and update them via triggers on the Invoices table. I keep changing my mind > about whether this is a good idea or not. allow me to help you -- it's a *terrible* idea > Any pointers appreciated - we're using SQL Server, if that makes a difference. presumably there's a front end? like, a web page or something? with some sort of scripting language? in coldfusion, the "ranking" number is given by a query results property called CurrentRow -- it just doesn't get any simpler than that (of course, this assumes you are sorting the results into ranking sequence) rudy http://r937.com/ ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
