Have an Error concatenating data.
SET @ZYEAR = 2015
SET @ZPERIOD = 5
SET @STARTPERIOD = CONVERT(NVARCHAR,@ZYEAR)+ Right('00' + Convert(varchar(10),@ZPERIOD), 2)
Error
Msg 244, Level 16, State 2, Procedure sp_Construction, Line 176
The conversion of the nvarchar value '201505' overflowed an INT2 column. Use a larger integer column.
How do I correct it.
What I have tried:
i HAVE CHECKED THE INTERNET AND SOME OF MY CODES