• A simpler way to get the information you're looking at would be this:

    WITH CTE AS
    (
    SELECT EventDate,EventTime,Temp, rn=ROW_NUMBER() OVER (PARTITION BY EventDate ORDER BY Temp ASC, EventTime ASC)
    FROM mytable --Change to your table name, of course
    )

    SELECT EventDate, EventTime, Temp
    FROM CTE
    WHERE rn=1;

    Turning that into a view is as simple as adding the following line at the beginning:

    CREATE VIEW myview AS --Again, change to the desired name for the view as necessary

    Cheers!