Simple...

• kbrady

  SSCommitted

  Points: 1861

  More actions

  April 8, 2002 at 7:00 pm

  #78435

  I am trying to come with a SQL statement to do the following.

  I have two tables in a DB.

  One table has user information in it while the other has personal user information like address phone number and such. What I want to do is insert the personal information from table 2 into table one. Heres where it gets tricky. Table one has two columns that make up a unique ID For instance:

  col1 col2

  abc 123

  Table 2 has just one columns with both these values:

  col1

  abc123

  How do I insert the information from table two into table one into there respective columns according to table 2's joined unique ID wich are represented in two columns in table one. Also I need to loop throught the records and do this automatiaclly.

  Currently I am using a DTS package to get the data from two different text files. One again makes up table one and the second table two.

  Any help would help

• RVPRASATH

  SSC Rookie

  Points: 27

  More actions

  April 9, 2002 at 3:45 pm

  #426901

  INSERT INTO TABLE1(COL1, COL2) SELECT LTRIM(LEFT((COL1 + REPLICATE(' ', 6)), 3)), LTRIM(RIGHT((COL1 + REPLICATE(' ', 6)), 3)) FROM TABLE2

  This makes sure that the query will not fail in case of 5 or less characters from table2.

  Prasath.

  
  
  Prasath.

• Eve

  SSCrazy

  Points: 2480

  More actions

  April 10, 2002 at 8:08 am

  #426957

  Is your column in the Table 2 always will have the structure abs123, or you will have different size of strings?

  Edited by - EPol29 on 04/10/2002 08:08:25 AM