How can I declair a variable so I can collect a variable in the where (having) clause of a query? I would like the user to populate MyTable.employer. I have tried @EmployerCode, and receive. I do not see how to add this in the design tool.
Msg 137, Level 15, State 2, Line 37
Must declare the scalar variable "@EmployerCode".