I have a query that is composed of several queries by a UNION ALL. For example a single query would give me how many tickets were created, the next query would be how many were escalated, etc. Here is the kicker, I am manually entering the names of the employees for each query. This is not an efficient way but the only way I know how.
I am looking to create a variable like Employee_Name := ('Jon Doe', 'Richard Simmons', Michael Jordan')
Then I would be able to run the query that would look something like this:
Where Submitter = Employee_Name
Attached you will find my query.