I have a situation ... I need to enter the details of a data load into an audit table..
I am loading the data from sales force object and once the data load is done, I need to enter the details of the load into audit table... I need to pick the max(LastModifiedDate) and enter the value in the audit table..
I loaded the Account table with 1 million records...
Once the load is done,
I created a stored procedure to enter the values into the audit table..But I'm not able to populate the max(LastModifiedDate)...
AUDIT TABLE Structue :
The insert statement I gave :
insert into audit values ('10','ACCOUNT','SCUCCESS',"need to populate the max(LastModifiedDate) of Account table")..
Can any one help me out on this please?