Database

mysql_set_charset('utf8');

WITH FirstObservation AS (
    SELECT  PatientID,Observation,Min(Time) Time
    FROM    MyTable
    WHERE   PatientID = @PatientID
    AND     Observation = @Observation
    GROUP BY PatientID,Observation
    )
SELECT  PatientId,Observation,TIME,Value
FROM    MyTable m
JOIN    FirstObservation f
ON      m.PatientID = f.PatientID
AND     m.Observation = f.Observation
AND     m.Time = f.Time

Kornfeld Eliyahu Peter wrote:

Why not using order by and top?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Kornfeld Eliyahu Peter wrote:

And nested select not?

Kornfeld Eliyahu Peter wrote:

It's performance depends only on the proper indexing...

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Eddy Vluggen wrote:

and the amount of records, the amount of fields in a row, their size

Eddy Vluggen wrote:

Ya reckon there's an index on the date

select * from Patient where time=(select max(time) from Patient);

GRANT EXECUTE ON B.packagename TO A;

Aravinth Spirited wrote:

the test for connection failed while creating the dsn itself. Any suggestions will be extremely helpful, thanks.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]