I have a table that each day the list of delinquent vendors are added via a script to the table with the current date. I need to be able to query the table to select vendors that were on the list for a given date that are not on the list for today. For example,
100 vendors were added to the list with a date of 9/25/2020. 95 vendors were added with a date of 9/26/2020.
I need to create a query for a SSRS report that has two date parameters. The user would select 9/25/2020 and 9/26/2020 and the query would return the 5 vendors who were on the list for 9/25/2020 and not on the list for the second data parameter of 9/26/220.