I came up with this:

CREATE TABLE SESSIONS(ID INT, SESSIONNAME VARCHAR(250), MAXSLOTS INT);

insert into SESSIONS
select 1, 'First Session', 5
union all
select 2, 'Second Session',3
union...

A simple catch all query will work

SELECT *
FROM @TAB AS [t]
WHERE ([t].[INCLUDE_ME] = @INCLUDE_ME) OR (@INCLUDE_ME <> 'Y');


Still need to learn LEAD/LAG but would think one of these would be something to use with SQL Server 2012 and newer.

You know what seems to be the eternal question that no one seems to get tired of asking, "How do you restore a copy of a database to an older...