Link to home
Start Free TrialLog in
Avatar of darthvader747
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
SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of darthvader747
darthvader747

ASKER

The records are inserted in a different method. Could you please explain your solution in this context. Thank You
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial