I'm trying to find out the best way to identify the records that were just inserted and select data fields from those records using a stored procedure.
The task is to retrieve certain fields from the entries that were inserted in bulk from a flat file.
To base it on creation date could be an issue as this could be an overnight process and dates will not match. Should I add a flag field that gets set for an insert and reset when its processed.
Or is there a way using cursors or identity I could achieve this. Please let me know your ideas. Thank You