一个Sheet2业务表,一个行政区划表AREA
把业务表中f8(县市区中文名)转化为AREA表行政区划编码,
要求是Sheet2]表f8(县市区中文名)=AREA表name
才能把
AREA表code 赋给 Sheet2表AREA(县市区代码)
关键是
[Sheet2]表f8(县市区中文名)=AREA表name
才能把
AREA表code 赋给 Sheet2表AREA(县市区代码)
declare @code int --存放编号
declare @name nvarchar(255) --中文字符
declare @Sheet2_max_id int --存放最小id
set @Sheet2_max_id=(select max(FID) from [Sheet2]) --设定初始最小id
while @Sheet2_max_id>0
begin
set @name=(select f8 from [Sheet2] where FID=@Sheet2_max_id)
set @code=(select code from [AREA] where [name]=@name)
update [Sheet2] set [AREA]=@code where f8=@name
set @Sheet2_max_id=@Sheet2_max_id-1
end