Posted by mittal.pradeep on 09/20/05 22:54

What is the better table design for a data collection application.
1. Vertical model (pk, attributeName, AttributeValue)
2. Custom columns (pk, custom1, custom2, custom3...custom50)

Since the data elements collected may change year over year, which
model better takes of this column dynamicness

• Next in forum: Linked server
• Prev in forum: Re: delete records
• Thread view: Dynamic data elements for a data collection application

[Reply to this message]