Calendar Table by Month

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

terry.home Ten Centuries Points: 1004 More actions · Answer 1

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 1, Line 29

Must declare the scalar variable "@End".

Msg 137, Level 15, State 2, Line 81

Must declare the scalar variable "@End".

fdimartini SSC Veteran Points: 259 More actions · Answer 2

"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