updating where the date is the oldest 1

[copeZero]

Hi i'm using smallDateTime for column InsertDate,

In the table i have 4 MID rows, each with a CredStr & MID

I'm trying to update the record where the InsertDate is the oldest date, this is what i have, any thoughts on this one?

Thanks.

UPDATE [_Credent] SET CredtStr=@CredStr WHERE
(Selete Min(InsertDate) from [_Credent]) AND MID=@MID

 

[AlexCuse]

I think you mean something like this?

WHERE
InsertDate = (Select Min(InsertDate) from [_Credent] where MID = @MID) 
AND MID=@MID

You need to make sure you include the MID = @MID in your subquery, or else you may not have a match because your earliest InsertDate could be different from the earliest where MID = @MID (and therefore 0 rows could be updated). Does this make sense?

Hope it helps,


Alex

[small]----signature below----[/small]
With all due respect, Don Bot, I don't think we should rely on an accident happening. Let's kill him ourselves.

Ignorance of certain subjects is a great part of wisdom

 

[copeZero]

definetly makes sense, thanks Alex.