[quote=“Colby.Clegg”]a table like the following:
Table
TagId
TagValue
which would grow vertically, and only have the values that have changed.[/quote]
yep, this is what I’m going for.
Another table would be the Tags table where the TagId ties to a TagName field and maybe some other information. Optionally, I may have an Event table where an EventId will tie together a collection of simultaneous tag updates together, but I’m not sure if that’s necessary. It could be that a simple t_stamp field is all that’s needed to provide that function. I need a t_stamp field though, either in this table or in the Event table.
I’ll be trying out your suggestions this morning and see if I can make that work.