Database

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 

EXEC sp_attach_db @dbname = N'MyDB', 
   @filename1 = N'C:\Folder\DBData.mdf', 
   @filename2 = N'C:\Folder\DBLog.ldf'

<br />
INSERT INTO tbl(ColName1,ColName2)<br />
VALUES('One','Two')<br />
<br />
SELECT SCOPE_IDENTITY()<br />

SELECT DISTINCT
    A.account_id
FROM
    table1 A
    LEFT OUTER JOIN table2 B
        ON B.account_id = A.account_id
WHERE
    B.account_id IS NULL