How to break out tables for Multiple events for 1 code
3 posters
Page 1 of 1
How to break out tables for Multiple events for 1 code
Hi there, I am modeling something and needed assistance.
I have a single code and tied to the code are several events.
For example 123456 has the following events at the following date and times.
Brush teeth 12/01/09 7:00AM
Eat 12/01/09 8:00 AM
Wash Car 12/02/09 2:30PM
Eat 12/02/09 8:00AM
Eat 12/02/09 1:20PM
When I pull reports I sometimes want the last instance of an event, sometimes the first and sometimes all of one or two types of events. I am trying to decide if I should have a table with all the first events, one with all the last events and one with all events or all three. I could have 50+ events for one code and multiple of several events in that code. I appreciate any advice you can offer.
I have a single code and tied to the code are several events.
For example 123456 has the following events at the following date and times.
Brush teeth 12/01/09 7:00AM
Eat 12/01/09 8:00 AM
Wash Car 12/02/09 2:30PM
Eat 12/02/09 8:00AM
Eat 12/02/09 1:20PM
When I pull reports I sometimes want the last instance of an event, sometimes the first and sometimes all of one or two types of events. I am trying to decide if I should have a table with all the first events, one with all the last events and one with all events or all three. I could have 50+ events for one code and multiple of several events in that code. I appreciate any advice you can offer.
spichael- Posts : 2
Join date : 2010-01-20
Re: How to break out tables for Multiple events for 1 code
A table with code, event & timestamp would suffice. If you want, you can add a sequence number within code to locate the nth event as well as a last event flag to identify the last event.
How to break out tables for Multiple events for 1 code
relate to referenced standards, calculations, examples, additional tables for ... The NFPA also publishes a 1,100-page NEC Handbook (for each new NEC edition) ...
________________
Download Windows 7
________________
Download Windows 7
Steve Dunning- Posts : 4
Join date : 2009-09-29
Similar topics
» Large number of snowflake code tables per dimension
» Multiple fact tables for invoice
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Multiple fact tables
» Connecting multiple fact tables
» Multiple fact tables for invoice
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Multiple fact tables
» Connecting multiple fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum