05-29-2016 12:59 PM
05-29-2016 04:21 PM
05-29-2016 05:08 PM
You need to develop test cases.
Then check that each case is returning the correct number
of records. Make sure to test edge cases - ones with no
matches either by ID or by time, missing data, and/or a large number of matches.
Also, test each case individually
and then as a set.