0 - 2 of 2 tags for Syntax Error 3706

I am receiving an error in SQL Assistant: CREATE TABLE Failed.  [3706] Syntax error: expected something between ')' and ';'. Can someone point me to where the error is? Here is my code (I've highlighted where SQL Assistant is telling me where the issue is

The following procedure can be called with no errors when the Procedure input parameter is not used in the WHERE clause, but gives the following Syntax error when the input parameter is used:

 

3706: Syntax error: expected something between a string or a Unicode character literal and the 'AT' keyword.