Re: Me know logical no need

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41308
interpreted = N
texte = Do you have SQL Server handy???Wouldn't try this in webcatOn 10/7/02 11:49 AM, Aaron Lynch wrote:> I need some advice on the best way to approach this task, I just can't seem > to wrap my tiny mind around the concepts needed... > > > I have a large real estate DB, currently 35 megs but when this project is > done it will be 500 Megs in size. (every house sold in Seattle for a year) > > I want to find the top 20 listing agents, so for example, the db looks > something like: > > AgentID price > AgentID price > AgentID price > > I think to find the agents with the most actual listings would be easy using > allhit=1&max=20 (right?) > > but, to find who has the most dollar volume, do I need to search all > listings, summarize all the agents, search all the agents, do math into a > temp DB to get a total, and then search the temp DB by total? or is there > (please dear god) an easier way? the full db will be several hundred > thousand records, each 130 or so fields wide. > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/-- Andrew Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +64 9 524-1849http://www.blackpepper.co.nz------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SOLUTION? Re: Me know logical no need (John Peacock 2002)
  2. Re: SOLUTION? Re: Me know logical no need (Jesse Williams-Proudman 2002)
  3. Re: SOLUTION? Re: Me know logical no need (John Peacock 2002)
  4. Re: SOLUTION? Re: Me know logical no need (Brian Fries 2002)
  5. SOLUTION? Re: Me know logical no need (Joseph D'Andrea 2002)
  6. Re: Me know logical no need (Dan Strong 2002)
  7. Re: Me know logical no need (Michael Davis 2002)
  8. Re: Me know logical no need (Aaron Lynch 2002)
  9. Re: Me know logical no need (Michael Davis 2002)
  10. Re: Me know logical no need Now totally OT (Aaron Lynch 2002)
  11. Re: Me know logical no need (Glenn Busbin 2002)
  12. Re: Me know logical no need (Aaron Lynch 2002)
  13. Re: Me know logical no need (Andrew Simpson 2002)
  14. Re: Me know logical no need (Alain Russell 2002)
  15. Re: Me know logical no need (Kenneth Grome 2002)
  16. Re: Me know logical no need (Aaron Lynch 2002)
  17. Re: Me know logical no need (Andrew Simpson 2002)
  18. Re: Me know logical no need (Aaron Lynch 2002)
  19. Re: Me know logical no need (Glenn Busbin 2002)
  20. Re: Me know logical no need (Aaron Lynch 2002)
  21. Re: Me know logical no need (Andrew Simpson 2002)
  22. Re: Me know logical no need (Kenneth Grome 2002)
  23. Re: Me know logical no need (Kenneth Grome 2002)
  24. Re: Me know logical no need (Aaron Lynch 2002)
  25. Re: Me know logical no need (Stuart Tremain 2002)
  26. Re: Me know logical no need (Aaron Lynch 2002)
  27. Re: Me know logical no need (Aaron Lynch 2002)
  28. Re: Me know logical no need (Jesse Williams-Proudman 2002)
  29. Re: Me know logical no need (Jesse Williams-Proudman 2002)
  30. Re: Me know logical no need (Alain Russell 2002)
  31. Re: Me know logical no need (Glenn Busbin 2002)
  32. Re: Me know logical no need (Aaron Lynch 2002)
  33. Re: Me know logical no need (Stuart Tremain 2002)
  34. Re: Me know logical no need (Robert Wade 2002)
  35. Re: Me know logical no need (Alain Russell 2002)
  36. Re: Me know logical no need (Andrew Simpson 2002)
  37. Me know logical no need (Aaron Lynch 2002)
Do you have SQL Server handy???Wouldn't try this in webcatOn 10/7/02 11:49 AM, Aaron Lynch wrote:> I need some advice on the best way to approach this task, I just can't seem > to wrap my tiny mind around the concepts needed... > > > I have a large real estate DB, currently 35 megs but when this project is > done it will be 500 Megs in size. (every house sold in Seattle for a year) > > I want to find the top 20 listing agents, so for example, the db looks > something like: > > AgentID price > AgentID price > AgentID price > > I think to find the agents with the most actual listings would be easy using > allhit=1&max=20 (right?) > > but, to find who has the most dollar volume, do I need to search all > listings, summarize all the agents, search all the agents, do math into a > temp DB to get a total, and then search the temp DB by total? or is there > (please dear god) an easier way? the full db will be several hundred > thousand records, each 130 or so fields wide. > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/-- Andrew Simpson Web DevelopmentBlackpepper Interactive Ltd PO Box 99805 Newmarket4 Clayton Street Newmarket AucklandPh: +64 9 520-6281 Mob: 0272733270 Fax: +64 9 524-1849http://www.blackpepper.co.nz------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Tab Charactor (1997) Online reference (1997) input and accents (2000) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) RE: too many nested [xxx] (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) switching users (1998) [WebDNA] Duplicate emails from list [WAS Ping....testing....1..2..3..] (2009) help testing quicktime delivery (1997) F3 crashing server (1997) RE: storefront (1998) Ghostly cached webpage (2000) WebCat b13 CGI -shownext- (1997) Setting up WebCatalog with Retail Pro data (1996) ShowNext (was New WebCatalog Site) (1997) [sendmail] on NT? (1997) Summing fields (1997) Trouble creating a temp database (2000) japanese characters (1997) Bug Report, maybe (1997)