<p>Hi Leonid:</p> <p> </p> <p>My query does contain the NOT EXISTS.</p> <p> </p> <p>--Use this one!<br />DECLARE @BBCourse varchar(30)<br />SET @BBCourse = 'PLACEMENT'<br /><br />SELECT @BBCourse AS CourseID, STBIOS.LAST_NAME, STBIOS.FIRST_NA...

Hi Leonid:

 

My query does contain the NOT EXISTS.

 

--Use this one!
DECLARE @BBCourse varchar(30)
SET @BBCourse = 'PLACEMENT'

SELECT @BBCourse AS CourseID, STBIOS.LAST_NAME, STBIOS.FIRST...

<p>Thanks for the assistance Leonid!</p> <p>Something is still not right though. This is what I have now:</p> <p>DECLARE @BBCourse varchar(30)<br />SET @BBCourse = 'PLACEMENT'<br /><br />SELECT @BBCourse AS CourseID, STBIOS.LAST_NAME, STBIOS.FIRST_NAME, ...

Thanks for the assistance Leonid!

Something is still not right though. This is what I have now:

DECLARE @BBCourse varchar(30)
SET @BBCourse = 'PLACEMENT'

SELECT @BBCourse AS CourseID, STBIOS.LAST_NAME, STBIOS.FIRST_NAM...

<p>Still getting this error:</p> <p>Server: Msg 156, Level 15, State 1, Line 17<br />Incorrect syntax near the keyword 'WHERE'.<br />Server: Msg 156, Level 15, State 1, Line 27<br />Incorrect syntax near the keyword 'AND'.</p>...

Still getting this error:

Server: Msg 156, Level 15, State 1, Line 17
Incorrect syntax near the keyword 'WHERE'.
Server: Msg 156, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'AND'.

...

<p>I get the following error with that query:</p> <p> </p> <p>Server: Msg 102, Level 15, State 1, Line 16<br />Incorrect syntax near 'RGENRL'.<br />Server: Msg 156, Level 15, State 1, Line 27<br />Incorrect syntax near the keyword 'AND'.<br /></p>...

I get the following error with that query:

 

Server: Msg 102, Level 15, State 1, Line 16
Incorrect syntax near 'RGENRL'.
Server: Msg 156, Level 15, State 1, Line 27
Incorrect syntax near the keyword 'AND'.

<p>No, there shouldn't be any NULLS.</p>...

No, there shouldn't be any NULLS.

...