• "Msg 139, Level 15, State 1, Line 0

    Cannot assign a default value to a local variable."

    You probably have an older version of sql. instead of

    @variable tinyint =15

    do this:

    @variable tinyint

    set @variable = 15