Professional Web Applications Themes

Multiple table compare and update - Microsoft SQL / MS SQL Server

Hello Chris ! Try to use the DTS to get the data in the original database. In the options just insert non-existing data, or use a query to insert only non-existing data. Hope that´ll help you, don´t hesitate either to ask us ;-)) Jens Süßmeyer. "Chris Guynn" <N.O.S.P.A.M.net> schrieb im Newsbeitrag news:7os0b.2550$news.prodigy.com...  the  old  would ...

  1. #1

    Default Re: Multiple table compare and update

    Hello Chris !

    Try to use the DTS to get the data in the original database. In the options
    just insert non-existing data, or use a query to insert only non-existing
    data.

    Hope that´ll help you, don´t hesitate either to ask us ;-))

    Jens Süßmeyer.


    "Chris Guynn" <N.O.S.P.A.M.net> schrieb im Newsbeitrag
    news:7os0b.2550$news.prodigy.com... 
    the 
    old 
    would 


    Jens Guest

  2. #2

    Default Re: Multiple table compare and update


    "Jens Süßmeyer" <jsuessmeyer[REJECT_SPAM]web.de> wrote in message
    news:phx.gbl... 
    options 

    Jens,

    Thanks for the help. This solution only addresses part of the problem. I
    also need to be able to import changed data. Any ideas? I'm beginning to
    think that it might be easier (since it's only about a days worth of data)
    to have our data entry people re-enter the data in the old system so that
    when we convert (for the second time) we won't have to deal with the
    headaches involved.
     
    Newsbeitrag [/ref]
    the [/ref]
    the 
    > the 
    > old [/ref]
    data [/ref]
    as 
    > would 
    >
    >[/ref]


    Chris Guest

  3. #3

    Default Re: Multiple table compare and update

    You can still use the DTS.
    Look up "Data Driven Query Task" in the Online Books. It can yze the
    source data and decide which out of four (insert, update, delete and user)
    queries to run on the current row. Might be what you're looking for :)

    GL!

    Lars-Erik

    "Chris Guynn" <N.O.S.P.A.M.net> wrote in message
    news:ODs0b.2551$news.prodigy.com... 
    > options [/ref]
    non-existing 
    >
    > Jens,
    >
    > Thanks for the help. This solution only addresses part of the problem. I
    > also need to be able to import changed data. Any ideas? I'm beginning to
    > think that it might be easier (since it's only about a days worth of data)
    > to have our data entry people re-enter the data in the old system so that
    > when we convert (for the second time) we won't have to deal with the
    > headaches involved.

    > Newsbeitrag [/ref]
    > the [/ref]
    > the [/ref][/ref]
    tough [/ref][/ref]
    250 [/ref][/ref]
    import [/ref][/ref]
    the [/ref]
    > data [/ref][/ref]
    tables 
    > > would [/ref][/ref]
    will 
    > >
    > >[/ref]
    >
    >[/ref]


    Lars-Erik Guest

  4. #4

    Default Re: Multiple table compare and update


    "Lars-Erik Aabech" <no> wrote in message
    news:phx.gbl... 

    Thanks. It looks like I've got a lot of reading to do. I appreciate all
    the help.

    C Guynn
     
    > > options [/ref]
    > non-existing 
    > >
    > > Jens,
    > >
    > > Thanks for the help. This solution only addresses part of the problem.[/ref][/ref]
    I [/ref]
    to [/ref]
    data) [/ref]
    that 
    > > Newsbeitrag [/ref][/ref]
    from [/ref][/ref]
    of [/ref][/ref]
    down [/ref]
    > tough [/ref]
    > 250 [/ref][/ref]
    we [/ref]
    > import [/ref]
    > the 
    > > data [/ref]
    > tables [/ref][/ref]
    or [/ref]
    > will 
    > >
    > >[/ref]
    >
    >[/ref]


    Chris Guest

Similar Threads

  1. multiple compare
    By carlbernardi@gmail.com in forum MySQL
    Replies: 5
    Last Post: March 5th, 04:03 AM
  2. update multiple rows from one table
    By kabbi~thkek in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 8th, 08:47 AM
  3. how can I update table with multiple rows
    By Anj01 in forum Macromedia ColdFusion
    Replies: 5
    Last Post: April 13th, 03:24 PM
  4. UPDATE MULTIPLE ROWS IN ONE TABLE OBTAINING SUMS FROM ANOTHER TABLE
    By Jon Spartan in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 9th, 04:48 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139