Create a table called "Cheater", containing both PatientId and last updatetime. Set both from a trigger on the Patient-table - do an insert of it doesn't contain the patient-Id, otherwise simply update the time.
Index the table on time, id.
You now have an indexed int/date table for your lookup.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
I created a table in ms access, and then i wanted to connect it to a java gui front end using type 1 driver. so i tried to create an odbc dsn for access. the test for connection failed while creating the dsn itself. Any suggestions will be extremely helpful, thanks.
Last Visit: 31-Dec-99 18:00 Last Update: 8-Mar-14 9:54