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 |
|
bangingtunes
Starting Member
23 Posts |
 Posted - 2001-10-30 : 09:07:52
|
| Im creating an auction site that requires me to sort the listings by highest bid, auction items are in 1 table and bids are stored in another linked by an ID.The only way i can think of doing this is by keeping track of the highest offer in the auction table, but this goes against my rule of not storing the same piece of data twice, and i could run into problems with keeping the figure upto date what with people editing and cancelling bids etc. Its possibly but asking for trouble.The only other method i can think of is performing a query for every row returned, but this is too uneconomical on server resources.Any Ideas as to the best approach would be greatly appreciated. |
|
|
|
|
|
which way is best?