Tricky Stored Procedure...

[TJ Bristol]

Hey,
As always any insight appreciated.

I am building a live auction app where people can leave absentee bids which
are then calculated during the live auction when the lot comes up.

I need to build a stored procedure that will pull the highest bid with the
lowest timestamp (this would be the winner, as in a tie the first person to
bid that amount would win) and the next lower or equal bid (or <=) to
compare it to and calculate the opening bid based on the amount of the bid.

The losing bid can be the same value as the winning bid, the winner having
the lower timestamp as he/she bid the amount first.

Here's what I have come up with so far to get the "winner":
CREATE PROCEDURE spProxy(@auctionID NUMERIC, @lotID NUMERIC)
AS
SELECT dbo.TAB_BIDS.usrID, bid, dbo.TAB_USERS.username FROM dbo.TAB_BIDS
INNER JOIN dbo.TAB_USERS ON dbo.TAB_BIDS.usrID = dbo.TAB_USERS.usrID WHERE
bid = (SELECT MAX(bid) FROM TAB_BIDS WHERE auctionID = @auctionID AND
lotID= @lotID AND absent = 1)
AND bidtime = (SELECT MIN(bidtime) FROM TAB_BIDS)
GO
This falls over and gives no records...I also need to find a way to pull
the"loser" at the same time...Any Ideas?
Thanks in advance

[TJ Bristol]

Got it sorted:

SELECT top 2 with ties
dbo.TAB_BIDS.usrID,
bid,
bidtime,
dbo.TAB_USERS.username
FROM
dbo.TAB_BIDS
INNER JOIN
dbo.TAB_USERS
ON dbo.TAB_BIDS.usrID = dbo.TAB_USERS.usrID
WHERE
auctionID = @auctionID
AND lotID= @lotID
AND absent = 1
order by
bid desc,
bidtime asc