Post reply

Incremental Load only required data

  • April 30, 2015 at 5:27 am

    #317816

    Hi,

    I have a table in Server A and it has 5 columns. One is Address & ID, CreateDatetime,..

    I need to transfer data from this table from Server A to server B for a report pupose. The Address column in this table has some places two address in the table. I am giving ex below

    Address

    Houston, Dallas

    Redmond

    Sacramento

    New Jersey, New York

    I want to avoid the rows where address are two Houston, Dallas & New Jersey, NewYork to the destination table in server B and need to do incremental loads.

    Any idea how to proceed with this?

    The version we are using is Sql Server standard edition 2008r2

  • May 3, 2015 at 3:46 am

    #1795214

    ramana3327 (4/30/2015)

    Hi,

    I have a table in Server A and it has 5 columns. One is Address & ID, CreateDatetime,..

    I need to transfer data from this table from Server A to server B for a report pupose. The Address column in this table has some places two address in the table. I am giving ex below

    Address

    Houston, Dallas

    Redmond

    Sacramento

    New Jersey, New York

    I want to avoid the rows where address are two Houston, Dallas & New Jersey, NewYork to the destination table in server B and need to do incremental loads.

    Any idea how to proceed with this?

    The version we are using is Sql Server standard edition 2008r2

    Not too much to work with here, can you elaborate a little further on this? The first suggestion would be to look into the MERGE statement.

    😎

  • May 3, 2015 at 4:38 am

    #1795224

    kindly read up about linked server, LIKE '%,%' and EXISTS operators (previously mentioned MERGE will also work)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply