In a t-sql 2012 column I have a column called test1 defines as (varchar(10),not null) in a table called tab. The values in this column look like '16-17' and '15-16'.
Right now the logic looks like
declare @test1 varchar(10) = '16-17'.
select * from test1 = @test
This logic is in an ssrs report where it would be too much trouble to change the parameter values due to the embedded subreports.
Now I need to select data where rows can equal '15-16' and '16-17'. Basically I need to pick the current school year ('16-17') and the previous school year('15-16').
Thus could you show me the t-sql on how to accomplish this goal without changing the parameter value logic?