|
|
-
RayB Commented 3 Years ago through Ask
<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...
|
-
RayB Commented 3 Years ago through Ask
<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_NAM...
|
-
RayB Commented 3 Years ago through Ask
<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>...
|
-
RayB Commented 3 Years ago through Ask
<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...
|
-
RayB Commented 3 Years ago through Ask
<p>No, there shouldn't be any NULLS.</p>...
|
-
RayB Commented 3 Years ago through Ask
<p>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="ProgId" content="Word.Document" />
<meta name="Generator" content="Microsoft Word 12" />
<meta name="Originator" content="Microsoft Word 12" />
<link rel="File-Li...
|
-
RayB Posted 3 Years ago through Ask
Hi All:
I'm using the following query and it appears to be returning rows even though I have specified to not include them using the NOT IN statement. Any ideas would be greatly appreciated!
DECLARE @BBCourse varchar(30)SET @BBCourse = 'PLACEMENT'SELE...
|
-
RayB Question Asked 3 Years ago through ASK
<p>Hi All:</p>
<p>I'm using the following query and it appears to be returning rows even though I have specified to not include them using the NOT IN statement. Any ideas would be greatly appreciated!</p>
<p>DECLARE @BBCourse varchar(30)<br />SET @BBCour...
|
ask
98
·
2% ·
538
|
|
-
RayB Commented 3 Years ago through Ask
<p>This works great! Thanks Jacob!</p>...
|
-
RayB Commented 3 Years ago through Ask
<p>Hi Jacob:<br /><br />Yes, I still need help.</p>
<p>Where would you need to add RGCRSE.SITE_NUMBER to the WHERE clause to make sure the students that I pull
are only from site 70?</p>
<p>Thanks,<br />Ray</p>...
|