Firstly thanks for replying. Actually there is no join for the inserted table. Values are picked from 2 different tables and a view (vw_Summary) and dumped into the "Summary" table. The...
It actually would vary if the last table is used to join with a seperate 3rd table. The results will vary. It depends on the business logic that is expected....