If it's possible, how do you utilize variables in a SQL View? Everytime I try to declare the variable and use it, it gives me the following error:
Server: Msg 156, Level 15, State 1, Procedure sample_this2, Line 5
Incorrect syntax near the keyword 'declare'.
Thanks.
Jung
Server: Msg 156, Level 15, State 1, Procedure sample_this2, Line 5
Incorrect syntax near the keyword 'declare'.
Thanks.
Jung