Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-26 : 09:20:14
|
| Matt writes "hello :)SQL server 2000 win serv 2003ASP.NET and VB.net applicationsI need to provide to be able get a piece of information from our DB, an "all time ranking" for each customer. this needs to be provided in quick time to build a web page..basically this query has to group all the sales by customer and then calculate the rank of the one we are asking about..I don't think running this query at runtime is practical as it is such a big calculation.so, I think i need to run this query overnight and store the rankings in a table.. then I can either have the ranking up to last night or maybe I could calculate any incremental sales since lsat night and alter the rankings at run time? not sure :)Is this a valid and the best way of calculaing and storing this sort of data? Up to now the website has only needed data that can be calculated quickly at run time and all our reporting is done off a read only copy of the DB that is synchronised in real time so it doesn't affect the live DB performance...Many thanks :)Matt" |
|
|
|
|
|
calculated ranking table