darthvader747
asked on
Identify and select records that were just inserted
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER