Let's say I have 1,000 tables, each with a column named "ChangedAt". The ChangedAt column is data type of "datetime".
Anytime a record gets changed in any of the 1,000 tables the ChangedAt column gets updated with the current datetime using GetDate().
Let's also suppose I have a baseline date, say, '1/1/2012 00:00:00.000'.
My object is to find out how many records have changed in each of the 1,000 tables since my baseline date.
I know I can do this using TBAT (table by agonizing table) using a cursor or loop construct, but is there a way to get the same results using set based logic?