write a procedure for insert/replace from bse_trade to Consolidated

write a procedure for insert/replace from bse_trade to Consolidated The purpose is to eleminate duplicate entries and data cleanup while inserting the data from staging table (bse_trade) to operational table (consolidated). The in the staging table will keep on incrementing at regular interval @200 records per 10 seconds and can reach upto 7 to 10 lakh records. hence have included the prodess1 flag to check what data is already processed and which need to be process now. Rating of the procedure will be done on the performance of the procedure and how soon you can deliver it.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Aug 18, 2013 at 11:10 AM

Homework? Or paid consulting? Either way, we have a vague description of a stored procedure with no structures. It's really hard to write a query without structures. If this is homework, you really need to show what you've tried that hasn't worked and I'm sure you can get some help. If it's consulting, you might want to advertise the rate you're paying us to get the work done.

1 ·