Find what has been added

Hi There,



I'd appreciate your help.



I need to find out what has been added to a table and then add that for each record I have in a stringed list called "lstTasks". This is the scenario.



I have a table of file links with multiple entries for TaskId.

As I enter a procedure I need to get a list of all file links for TaskId = 1

Then after the procedure does it's stuff I need to check all file links for TaskId = 1 again and if there are more records added, I need to add those records for each id in the stringed list "lstTasks"



Don't know if that makes sense, I'm rubbish at explaining what I need.

The tables are in MS Sql Server.



Thanks for any help you can give.



Best Regards,

Find what has been added