How to Enhance Stored Procedure?

[rkiss]

Hi,

I have a stored procedure that monitors daily data (insert data into monitoring table, compares two tables) I would like to add the following functionality to the stored procedure.

1. If specific data exists in one table, but not in the other one, the current monitoring just totals the number of missing records. I would like to add the ability to store missing records in another monitoring table.


I do not know how to call this trigger: if specific field is 0 get/insert missing records to another table. Any help/ideas are appreciated.

Thank you

Roman

[tamilselvan]

Hmm,

Monitoring tool becomes application.
Is it not bad idea?

Tamil

[rkiss]

I am not sure what you mean by that response, but this is only a temporary solution until our DW is in production.

Roman

[rkiss]

Does anyone have some sort of idea how this can be done?

Thanks

Roman