Writing a query with 3 parameters that it needs to meet. I have a temp table that I pull from, then apply the 3 parameters. Select all is an option in two of the three params. I'm attaching the query that I have so far. I can get it to meet all three, but get nothing if 'all' is selected. I also need to make the instructor field optional on the SSRS report.