The syntax problem is that your subselect, ie:

 

(SELECT SystemUserName ....

.... <> 'valverde\rKepler')

is expected to return a single value, which then must be compared with something.

So, prior to the BEGIN you need a comparison operator and value. Eg.

 

IF

(SELECT SystemUserName FROM Teacher_Data_Main

WHERE (SystemUserName = SYSTEM_USER)

or SystemUserName <> 'valverde\pGist'

or SystemUserName <> 'valverde\jGolden'

or SystemUserName <> 'valverde\tPeepgrass'

or SystemUserName <> 'valverde\lGallo'

or SystemUserName <> 'valverde\cBerry'

or SystemUserName <> 'valverde\aGuild'

or SystemUserName <> 'valverde\rGlenn'

or SystemUserName <> 'valverde\mSarkissian'

or SystemUserName <> 'valverde\cJenkins'

or SystemUserName <> 'valverde\rKepler')

 = 'somevalue'



BEGIN



SELECT * FROM tblTests

END

However, looking at the code, I fear there's other logic problems to be overcome.

OR's don't go well with "NOT Equal" operators.

Also, your subquery will have to be tighted to ensure it returns a maximum of 1 row.

Cheers,

- Mark