Unanswered: Silly question about dynamic parameters with filters?
I have a CR that I want to make dynamic parameters for. The tables in the DB are extremely large and have a lot of information that isn't relative to the present. I want to make a parameter to choose an employee who was active in the last 6 months, as opposed to having a list of every employee ever. I also want it to be dynamic so that I don't have to constantly go in and change the list with every hire and fire. Is there a way to do this? I was thinking there had to be a way to write a procedure in sql and link this to the parameter values? Please help.