• Wrong design.

    CREATE TABLE Test(

    PatientID int,

    TestID int,

    Reading decimal(10,4)

    TestDate DateTime

    );

    Then the rest is trivial.