Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Move data from one column to another column in the same table.

Posted on 2004-10-11
2
Medium Priority
?
203 Views
Last Modified: 2012-06-27
I want to move the contents of a column RelatedMoveID to a column named RelatedInventoryID in a table named Tbl_Movements. Could you help me with what I assume will be an update query? Current values in RelatedInventoryID are all <NULL> and RelatedMoveID will be empty and Nulls are allowed.
0
Comment
Question by:jamesh1031
2 Comments
 
LVL 70

Expert Comment

by:Scott Pletcher
ID: 12276333
UPDATE Tbl_Movements
SET RelatedInventoryID = RelatedMoveID
0
 
LVL 10

Accepted Solution

by:
AustinSeven earned 2000 total points
ID: 12276364
update Tbl_Movements
set RelatedInventoryID  = RelatedMoveID,  RelatedMoveID = NULL

AustinSeven
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question