question

sarikathorat4 avatar image
sarikathorat4 asked

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.
sql-server-2008stored-procedures
1 comment
10 |1200 characters needed characters left characters exceeded

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

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 Like 1 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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