RE: Complicated SQL Query

2010-08-26 Thread Jacob Steinberger
Quoting Jerry Schwartz : -Original Message- From: Jacob Steinberger [mailto:trefal...@realitybytes.net] I have a requirement to keep track of a set of data, and all changes that might occur. In order to do this, for each field of the data set, I've created a table that keeps track o

Re: Complicated SQL Query

2010-08-25 Thread Jacob Steinberger
I found an answer without having to worry about complicated SQL statements - it's more about managing the tables than the SQL. Jacob Quoting Jacob Steinberger : I have a requirement to keep track of a set of data, and all changes that might occur. In order to do this, for each field o

Complicated SQL Query

2010-08-25 Thread Jacob Steinberger
I have a requirement to keep track of a set of data, and all changes that might occur. In order to do this, for each field of the data set, I've created a table that keeps track of the version, the value, the time the change was made, and a linking number that links all the different tables