Master tables list : TableA,TableB,TableC

Main table : Trackertable

Tracker table having columns CountUpdatedDate,TableA,TableB,TableC

i want each and every time with date master tables counts are update in Trackertable. it means every time how much of bulk data insert counts showing in tracker table.

  • 2
    Postgres or SQL Server? Jun 18 at 6:07
  • dup on SO
    – SMor
    Jun 18 at 11:04
  • Try using an UPDATE statement.
    – mustaccio
    Jun 18 at 19:06
  • Why do you want to store the same data twice? Why not just query it when you need it (or use a view)? Jun 18 at 23:14


Browse other questions tagged or ask your own question.