Query to get data in one status not in another status
So if I understand correctly, you want the latest status and be able to filter on it. I don't know what version of SQL Server you're using but APPLY has been out since 2005 so try this out:

SELECT  DISTINCT TagNo,
        TruckNo,
        CA.VerifiedDateTime,
        CA.Status
FROM yourTable A
CROSS APPLY 
(
    SELECT TOP 1 VerifiedDateTime,Status 
    FROM yourTable 
    WHERE TagNo = A.TagNo 
    ORDER BY VerifiedDateTime DESC
) CA
WHERE CA.Status = 'A';