C
cleech
Hello All:
I trying to find a different way of comparing data in 2 tables. The
tables I have are generated as follows
1) User Action creates a table that is a copy of a subset of an active
table as of the current date.
(Done through sql statement)
2) At a later date, compare the active table data to the copy made in
previous step.
What I've done in the past is to use queries with giant OR statements
with fields compared by field1Copy <> field1Active. Obviously this is
not the best approach.
I'm looking to do this much more dynamically. Ultimately, I would
like to create a procedure that would take tables with the same
structure and compare them.
I've read a little about using recordsets and cycling through the
fields, but I'm not sure where to start and I have absolutely no idea
where to finish.
Any help is greatly appreciated. Please let me know if you need any
additional information.
Thanks,
Cleech
I trying to find a different way of comparing data in 2 tables. The
tables I have are generated as follows
1) User Action creates a table that is a copy of a subset of an active
table as of the current date.
(Done through sql statement)
2) At a later date, compare the active table data to the copy made in
previous step.
What I've done in the past is to use queries with giant OR statements
with fields compared by field1Copy <> field1Active. Obviously this is
not the best approach.
I'm looking to do this much more dynamically. Ultimately, I would
like to create a procedure that would take tables with the same
structure and compare them.
I've read a little about using recordsets and cycling through the
fields, but I'm not sure where to start and I have absolutely no idea
where to finish.
Any help is greatly appreciated. Please let me know if you need any
additional information.
Thanks,
Cleech