Post reply

Question Concatenate the int in derived column

  • March 9, 2009 at 12:09 pm

    #956294

    hi........

    i am new to sql server, i have 2 columns fields like LIC-NO and SSN in database1 and CUST_ID in new database...... i have to move 2 columns LIC-NO AND SSN to CUST_ID,such that both should be placed in different columns.........

    can anyone please help me.......

    thanks,

    shravani

  • March 9, 2009 at 12:14 pm

    #956301

    Then you need to add a new column to the target to house the SSN data also.Do you control the target database?

    I think Lynn has proven that you while you *can* concat these fields you probably don't want to.

    Steve.

Viewing 2 posts - 16 through 16 (of 16 total)

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