Database

<br />
SELECT tTester.TesterID<br />
FROM tTester<br />
INNER JOIN tResultQue<br />
     ON (tTester.TesterID = tResultQue.TesterID)<br />
INNER JOIN tGroup<br />
     ON (tResultQue.GroupID = tGroup.GroupID)<br />
WHERE tGroup.ScheduleStamp < @DD<br />
GROUP BY tTester.TesterID<br />

<br />
AND tTester.TesterID NOT IN <br />
     (SELECT tTester.TesterID<br />
      FROM tTester<br />
      INNER JOIN tResultQue<br />
          ON (tTester.TesterID = tResultQue.TesterID)<br />
      INNER JOIN tGroup<br />
          ON (tResultQue.GroupID = tGroup.GroupID)<br />
      WHERE tGroup.ScheduleStamp < @DD<br />
      GROUP BY tTester.TesterID)<br />

SELECT tTester.TesterID
FROM tTester
INNER JOIN tResultQue
     ON (tTester.TesterID = tResultQue.TesterID)
INNER JOIN tGroup
     ON (tResultQue.GroupID = tGroup.GroupID)
WHERE tGroup.ScheduleStamp > @DD
GROUP BY tTester.TesterID

CREATE PROCEDURE usp_tp_GetPKCall
(
    @SexID char,
    @RaceID char,
    @LBirth datetime,
    @UBirth datetime,
    @SiteID varchar(5), 
    @DD datetime
)
AS

IF @SexID = '*' AND
   @RaceID <> '*' AND 
   @SiteID <> '90000'
BEGIN

    SELECT 
        tGroup.ScheduleStamp, 
        tResultQue.TesterID, 
        tTester.LastName,
        tTester.FirstName, 
        tTester.WorkNo, 
        tTester.WorkExtension, 
        tTester.HomeNo,
        tTester.SexID, 
        tTester.Birth, 
        tTester.RaceID, 
        tTester.SiteID
    FROM tGroup 
    INNER JOIN tResultQue 
        ON (tGroup.GroupID = tResultQue.GroupID)
    INNER JOIN tTester 
        ON (tResultQue.TesterID = tTester.TesterID)
    WHERE tTester.RaceID = @RaceID AND 
        tTester.Birth >= @LBirth AND 
        tTester.Birth <= @UBirth AND 
        tTester.SiteID = @SiteID AND 
        tGroup.ScheduleStamp <= @DD AND
        tTester.TesterID NOT IN 
            (SELECT tTester.TesterID
            FROM tTester
            INNER JOIN tResultQue
                ON (tTester.TesterID = tResultQue.TesterID)
            INNER JOIN tGroup
                ON (tResultQue.GroupID = tGroup.GroupID)
            WHERE tGroup.ScheduleStamp > @DD
            GROUP BY tTester.TesterID)

END

GO 

AND tGroup.ScheduleStamp  = 
    (SELECT MAX(cor_tGroup.ScheduleStamp)            
    FROM tTester cor_tTester           
    INNER JOIN tResultQue cor_tResultQue                                   
        ON (cor_tTester.TesterID = cor_tResultQue.TesterID)            
    INNER JOIN tGroup cor_tGroup                              
        ON (cor_tResultQue.GroupID = cor_tGroup.GroupID)            
    WHERE cor_tTester.TesterID = tTester.TestID)

DECLARE @tbl TABLE
(
    TesterID INTEGER NOT NULL,
    ScheduleStamp DATETIME NOT NULL
)
--*******************************************************
-- find the correct testers and their last ScheduleStamp
--*******************************************************
INSERT INTO @tbl
(
    TesterID,
    ScheduleStamp 
)
SELECT
    tTester.TesterID,
    MAX(tGroup.ScheduleStamp)
FROM tGroup     
INNER JOIN tResultQue         
    ON (tGroup.GroupID = tResultQue.GroupID)    
INNER JOIN tTester         
    ON (tResultQue.TesterID = tTester.TesterID)
GROUP BY TesterID
HAVING MAX(tGroup.ScheduleStamp) <= @DD
--***************************
-- final select for results
--***************************
SELECT 
    @tbl.ScheduleStamp,         
    @tbl.TesterID,         
    tTester.LastName,        
    tTester.FirstName,         
    tTester.WorkNo,         
    tTester.WorkExtension,         
    tTester.HomeNo,        
    tTester.SexID,         
    tTester.Birth,         
    tTester.RaceID,         
    tTester.SiteID
FROM @tbl
INNER JOIN tTester
    ON (@tbl.TesterID = tTester.TesterID)
WHERE tTester.RaceID = @RaceID AND         
    tTester.Birth >= @LBirth AND         
    tTester.Birth <= @UBirth AND         
    tTester.SiteID = @SiteID AND