From: craig.futterman@nospam.comcast.net   
      
   As I have done more think about this, I have another question:   
   Should I have 2 Tcursors or a TCursor and a table variable, one which   
   increments step by step to get the next hospitalnumber and the other to   
   setrange and get the data?   
   Or should I have two copies of the table, one to go down step by step and   
   the other to do the set range?   
   My feeling is it should be the first, but I need expert opinions..... :)   
   Thanks, Craig   
      
   "Craig"  wrote in message   
   news:45d906f3$1@pnews.thedbcommunity.com...   
   > Liz, Egbert and Anders,   
   > Thanks, as always, for your replies.   
   > After doing a query which combines two tables from a specified time frame,   
   > I am going through each of the records, one by one, and looking for   
   > records which have the same medical record number and comparing the   
   > discharge datetime with the admission datetime of the next record. The   
   > goal is looking for patients who come back to the ICU within a specified   
   > period of time (24 or 48 hours). The purpose is to investigate why kids   
   > "bounce back" in a short period of time.   
   > According to what you suggest, I will have to create an index on the   
   > hospital number field after the query which creates the table. Then, as I   
   > go through the table with a scan loop, set the range for the hospital   
   > number, compare records and find the "bouncebacks". I have to reset the   
   > range each time the big scan loop goes to the next patient.   
   >   
   > Does that sound correct? Can I go through a scan loop of the entire table   
   > and use set range after each record?   
   > Thanks for helping me with this complex project.   
   > Craig   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)