Capture new and modified data

Hi,
I have two tables, 1 is yesterday data and 1 is today data.
My job is to identify new and modified data only.
I am thinking of compare data, field by field in the where clause to
identify change.
Is this the best way to do it?
Thanks,
CulamIt would seriously help if you had a column that stores the date/time the
row were inserted or updated.
"culam" <culam@.discussions.microsoft.com> wrote in message
news:5DC1BEE5-145A-48F8-B3A2-893E05651B9D@.microsoft.com...
> Hi,
> I have two tables, 1 is yesterday data and 1 is today data.
> My job is to identify new and modified data only.
> I am thinking of compare data, field by field in the where clause to
> identify change.
> Is this the best way to do it?
> Thanks,
> Culam|||Use BINARY_CHECKSUM to compare data and see what changed.