How to query for first occuring event only

  • Thread starter Thread starter mmohon
  • Start date Start date
M

mmohon

Ok, I'm running some queries in our ER's event times. What I'm trying
to get is the time it takes to get a patient from the door and into a
room. The only way I can see this is with an Event Time and Event
Description. It looks like this

Patient key_EventTime_Event Description
-----------------------------------------------------------------------------
123456____7:55 AM___Patient Registered
123456____8:00 AM___Moved to: [Emergency Room:Trauma 2]
123456____8:01 AM___Staff Requested: [Physician John Smith]
123456____8:25 AM___Moved to: [Emergency Room:Exam 3]

The only event I'm analyzing that can have multiple events like this
where the patient is moved from 1 room to the other.

SELECT Patient Key, Hour([Event_Time]) AS [Hour],
DateDiff("n",[RegTime_Query],[Event_Time])/1440 AS [Minutes From Door
to a room]
FROM ErEventData
WHERE (((Left([Event_Desc],26))="Moved to: [Emergency Room:"));

Is there any way I can add in something that shows me 1 patient only 1
time, for their first event of "Moved to:" a room. So in my example
above, I would only get line 2, and not line 4.

In laymans terms,
Show me 1st time they are moved to a room
instead of
Show me anytime they are moved to a room
 
Back
Top