How to loop through records

[#1]

I have start time (2010-07-06 13:03:07) and End time ( 2010-07-06 16:24:39) for each record

I need to find by minute if the record was active or not and display to user in the table format.

13:00- 14:00 - Active Record

14:00-15:00 - Active Record

15:00 - 16:00 - Active Record

In general, how do I loop through a record and create a table by each minute.

Any help would be appreciated.

[rwunderlich · Accepted solution]

I would suggest a different approach. Generate a table of each minute and IntervalMatch that table with your fact table.

-Rob

[#3]

Thank you Rob for the direction . This worked.

Pranita