rudy, Thanks for the reply. > > 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
I'll try and forget it :-) > presumably there's a front end? like, a web page or something? > with some sort of scripting language? > (of course, this assumes you are sorting the results into ranking > sequence) There are actually two front ends - one web-based, one desktop-based - this query is a stored procedure, though, as part of an abstraction layer (sorry, I tried to keep the original question as straightforward as possible). I appreciate I'm going to have to build the entire ranking table at some point, as without it there's no way of knowing what rank my client is. What I was hoping is that I could build it, scan it, and have the rank returned as another just another column in my results, rather than having to build the ranking table and see which row my client ends up in with a separate query. I have a feeling I should be reading up on creating temporary tables... Cheers Jon ____ � 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.
