• But better go with this:

    declare @Year int = 16

    declare @ThisYear varchar(10), @LastYear varchar(10)

    SELECT @ThisYear = CONVERT(VARCHAR(10), @Year) + '-' + CONVERT(VARCHAR(10), @Year + 1),

    @LastYear = CONVERT(VARCHAR(10), @Year-1) + '-' + CONVERT(VARCHAR(10), @Year)

    PRINT @ThisYear PRINT @LastYear

    select *

    FROM test1 t1

    INNER JOIN test t2 on t2.col = @LastYear

    WHERE t1.Col = @ThisYear

    _____________
    Code for TallyGenerator