Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: Adding data to columns

    Hi,

    Say I have two tables.

    Table A - Col a1, Cola2
    Table B - Col b1 and Col b2

    Now using DTS I transfer a1 to b1 ONLY.

    Now later I decide to transfer a2 to b2. How do I do that such that b2 is appended to the record b1. Using INSERT I end up not appending b2 to b1. b2 adds more rows to table B. Can this appending be done without using a WHERE predicate.

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63
    Hi,

    I see two possibilities.

    1. You can use an update-statement (unfortunately) with WHERE.
    or
    2. You TRUNCATE your table B and design a DTS package which transfers both columns from table A to table B.

    Greetings,
    Carsten

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •