Hello All,
We have a table named TriageCheckList that saves records for a request and the list of items that are needed to process the request . There was an issue of some sort this week and there are now requests that are saved In the table for which an item with id 9 has missed
We want to identify all requests where a request has the itemnumber 9 missing so we can manually enter it into the table so the users don't face issues at the interface table
TriageCheckList Table Structure
ReqNo
CheckListItemNo
CompletedDt
Sample Data for a request without issue
123456,1,01/01/2018
123456,2,01/11/2018
123456,3,01/21/2018
123456,4,01/31/2018
123456,5,01/17/2018
123456,6,01/01/2018
123456,7,01/01/2018
123456,8,01/01/2018
123456,9,01/19/2018
123456,10,01/01/2018
Sample Data for a request with issue
123457,1,01/01/2018
123457,2,01/11/2018
123457,3,01/21/2018
123457,4,01/31/2018
123457,5,01/17/2018
123457,6,01/01/2018
123457,7,01/01/2018
123457,8,01/01/2018
123457,10,01/01/2018
How can we identify all requests within this table for which item number 9 is missing
Thanks in advance