--DROP TABLE #Base_Resource, #Resource, #Resource_Trans;

SELECT data.*
   INTO #Base_Resource
   FROM (
         SELECT '11A','Samsung' UNION ALL
         SELECT '12A','Nokia' UNION ALL
         SELECT '13A', 'Alcatel' UNION ALL
         SELECT '14A', 'Motorolla' UNION ALL
         SELECT '15A', 'ChinaSets' UNION ALL
         SELECT '16A', 'Apple' 
        ) data (Resourcekey, value)
;

create table #Resource (StringId Int identity(1,1) primary key,Resourcekey varchar(50));
create table #Resource_Trans (TransId Int identity(1,1) primary key,StringId int, value

INSERT INTO #Resource(Resourcekey)
OUTPUT INSERTED.StringID INTO #Resource_Trans(StringId)
SELECT Resourcekey
FROM #Base_Resource


UPDATE  RT
SET 
	RT.Value= BS.Value
FROM
	#Resource_Trans as RT
	INNER JOIN #Resource as RS ON RS.StringID=RT.StringID
	INNER JOIN #Base_Resource as BS
	ON BS.Resourcekey=RS.Resourcekey
	

TransId	StringId	value
1	1	Samsung
2	2	Nokia
3	3	Alcatel
4	4	Motorolla
5	5	ChinaSets
6	6	Apple

StringId	Resourcekey
1	11A
2	12A
3	13A
4	14A
5	15A
6	16A