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 |
|
firejackmusic
Starting Member
15 Posts |
 Posted - 2009-10-22 : 05:16:13
|
| Well I have 2 tables, one bidhistory and another products, bidhistory keeps a tab on all the bids and the product table just holds the bid made, ie: highest each time someone bids, my problem is when the auction is finished I need to get all bids that are proxy high ie:finished bid was 25 but i bid 75 so it should look through the table find the highest bid and get the price below that because noone outbid my bid,, it sounds complicated to meWell in both instances they are bound with product id in this case idproduct realting to each other |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-10-22 : 06:20:56
|
Post some accurate sample data to illustrate your problem.Also post your expected output.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-10-22 : 11:20:59
|
| is there anything that links the two table i.e. AuctionID |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-22 : 13:00:17
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
firejackmusic
Starting Member
15 Posts |
Posted - 2009-10-23 : 04:12:35
|
| Well this is a similar problem I posted herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=134781The data passed is the idproduct, this can then dig out all the bids from the bidhistory table, the problem is, on finding a user with bids, to check on each product if he was the high bidder and if so, calculate the next bid below the max proxy bid entered... ieif closing bid was 25 and bidder had bidder 75 to make sure thwy won the item, the calculation should be the bid lower 25 that is second highest, hope this is clear |
|
|
|
|
|
|
|
|
sql query for final invoice?