Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sqlintegratonservice
  • Order by date
  1. sqlintegratonservice

    Concatenate the int in derived column

    hi.......... i have LIC-NO and SSN fields for all the customers in the database 1 and i have to send them to database2 into the CUST_ID column.......... for example,for a customer with id 1 have LIC_NO:234523 and SSN:123456,i have to display both the fields in the CUST_ID...
  2. sqlintegratonservice

    Concatenate the int in derived column

    hi......... (DT_STR,50,1252) ( (DT_STR,10,1252)[ [LIC-NO]] + (DT_STR,10,1252) [SSN] ) i am using the above expression in the derived column and LIC-NO and SSN are the columns i need to send and datatype i selected DT_STR........but also it is showing in red........ how can i write the...
  3. sqlintegratonservice

    Concatenate the int in derived column

    Hi,,,,,,,,,, No,i dont want like that result 123+456=123456........ i have id_num and ssn from one database to cust_id in another database........so i have 2 moves 2 values in to 1 column........... how can i do that??? thanks
  4. sqlintegratonservice

    Concatenate the int in derived column

    hi.......... i have to send 2 values from one database in to the 1 value of another database.......but they are int values.........when i am using derived column and concatenate they just adding up.........if i am using "" symbol in between them it is showing error in derived...
  5. sqlintegratonservice

    help in inserting data

    hi, i am new to sql server, ............. i have 2 databases,i have to insert data from the old database to new database........ for example i have first_name column in new database but i have first_name,first_name1,first_name2 ... 3 columns in old database...... i have to insert 3 columns into...

Part and Inventory Search

Back
Top