quote:

---

Originally posted by pascal_jimi



UPDATE dbo.DatalinkMerchantAccount_TEMP_old
SET dbo.DatalinkMerchantAccount_TEMP_old.MerchantID =(select MerchantID from dbo.DatalinkMerchantAccount_TEMP ) ;

kmkmmm

---

quote:

---

Originally posted by pascal_jimi

create table t1(name nvarchar(20), age int);
create table t2(name nvarchar(20), age int);

insert into t1(name, age) values('ivanov',35);
insert into t1(name, age) values('petrov',45);
insert into t1(name, age) values('sidorov',55);

insert into t2(name) values('ivanov');
insert into t2(name) values('petrov');
insert into t2(name) values('sidorov');
go

select*from t1
select*from t2
go

UPDATE t2
SET t2.age = (
SELECT t1.age
FROM t1
WHERE t1.name = t2.name)
go
select*from t2

kmkmmm

---

quote:

---

Originally posted by MuMu88

I believe PascalJimi is trying to provide an example for you.
You can update your tables in couple of ways:
1. If you want to keep part of the data in the dbo.DatalinkMerchantAccount_TEMP_old table then you can do something like this:
[CODE]

UPDATE T2 SET DBA = T1.DBA,
BankAccountNum = T1.BankAccountNum,
BankTransitNum = T1.BankTransitNum
FROM dbo.DatalinkMerchantAccount_TEMP_old AS T2 JOIN dbo.DatalinkMerchantAccount_TEMP
AS T1 ON T1.MerchantID = T2.MerchantID

[/CODE]

2. If you don't care to keep any of the data in the table dbo.DatalinkMerchantAccount_TEMP_old table then you can do something like this:

[CODE]

TRUNCATE TABLE dbo.DatalinkMerchantAccount_TEMP_old; -- WARNING THIS COMMAND DELETES ALL THE DATA FROM THIS TABLE!!!
INSERT INTO dbo.DatalinkMerchantAccount_TEMP_old(MerchantID, DBA, BankAccountNum, BankTransitNum)
SELECT MerchantID, DBA, BankAccountNum, BankTransitNum FROM dbo.DatalinkMerchantAccount_TEMP;
[/CODE]

---