roboticus

Thanks for your reply, but in my case using UPDATE statement is not good, since the changed fields vary for different records, I mean for the 1st record, maybe the changed fields is the first 3 ones, but for the 2nd record, maybe the changed fields are the last 3 ones. It will be tedious to find out which fields have changed for each record and then write out an update statement.

For the 3 tables I have mentioned, the tbl_3 is almost a combine of the tbl_1 and tbl_2 on each primary key. Just like: 

tbl_1:
key  col1 col2
---  ---- ----
1    abc  123
2    xyz  987

tbl_2:
key  col3 col4
---  ---- ----
1    bcd  12.5
2    zzz  11.1

tbl_3:
key  col1 col2 col3 col4
---  ---- ---- ---- ----
1    abc  123  bcd  12.5
2    xyz  987  zzz  11.1

[download]
Inspired by your bcp advice, I am just thinking whether I can bcp out tbl_1 and tbl_2, and then process the two bcp files to construct the bcp file for tbl_3. It should be much faster then inserting the sql statements.

In reply to Re^4: How can I improve the sql statements applying efficiency by littlehorse
in thread How can I improve the sql statements applying efficiency by littlehorse

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.