How about this (assuming your ID field is an identity column) --

DECLARE @ID_Machine_Info int

SELECT TOP 1 @ID_Machine_Info = MI.ID_Machine_Info FROM

(SELECT TOP 6 ID_Machine_Info FROM tblMachineInfo

WHERE Date >= CONVERT(CHAR(10), GETDATE(), 102)

ORDER...