I have a table with
1.date
2.casenumber
3.errortype
4.pagenumber columns
I want to pull all records in the table .
but, if an error_type of '2' is present for a pagenumber/case_number on the same day that there are other error types for that page, I only want to pull the error type 2 log and ignore the rest for that page.
Any ideas?
Sounds like maybe an exising clause?
This one has stumped a few people here today, so I come to you all!
So if for example a casenumber on 2/24 for page 13, had errortypes of 1,2,3,4,5 logs. I would only want to see the log for the error type 2.
1.date
2.casenumber
3.errortype
4.pagenumber columns
I want to pull all records in the table .
but, if an error_type of '2' is present for a pagenumber/case_number on the same day that there are other error types for that page, I only want to pull the error type 2 log and ignore the rest for that page.
Any ideas?
Sounds like maybe an exising clause?
This one has stumped a few people here today, so I come to you all!
So if for example a casenumber on 2/24 for page 13, had errortypes of 1,2,3,4,5 logs. I would only want to see the log for the error type 2.