The stored procedure fails when you execute it

(0 rows affected)

(1 row affected)

(0 rows affected)

(1 row affected)

(1 row affected)

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near ')'.

(0 rows affected)

(1...