Move data from one column to another

Discuss DataPipe. Get help with installation and running it, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Sat Jan 24, 2004 9:13 am

Move data from one column to another

Post by mrspock » Sat Jan 24, 2004 9:15 am

After applying a filter, how would one then move the result from one column to another?

Posts: 18
Joined: Tue Sep 23, 2003 3:13 am

the SQL For you....

Post by jring » Fri Mar 12, 2004 4:58 pm

If you just processed Column A and You would like to move the result to Column b, and Column B is in the Same table:

Update X
Set Column B = Column A

if it's in another table and there is some kind of foreign key between the two tables:

Update X
Set X.B = Y.B
From Table1 X, Table2 Y
Where X.Key in
(Select Y.Key where X.Key = Y.Key)

Post Reply