Newbie help needed - could you provide me a pseudo code approach to the following problem
I have a table [Processing_FaultDurations] containing
FK_FaultHASCID, FK_AddressID, StartTime, ClosedTime
and a table of time periods that i need to report over T_TimePeriods containing
Any device can have multiple faults in a given reporting period (PK_PeriodID)
I need to retrieve the following:
For any 10 or more faults occuring on each device in each reporting period ie. when the fault starts between the period start time and end time
I need to get back a table that lists all fault IDs that are the 10th Fault and i need this for every device for every reporting period.