DECLARE C CURSOR FOR
select HQ,[year],
County,tollfree,Acc
from RICHLBD..[Business Classify]
declare @HQ varchar(50)
declare @year varchar(50)
declare @County varchar(50)
declare @tollfree varchar(50)
declare @Acc varchar(50)
OPEN C
FETCH NEXT FROM C INTO @HQ,@year,@County,@tollfree,@Acc
WHILE @@FETCH_STATUS =0
BEGIN
UPDATE T_Company_temp
SET OfficeClassification=@HQ,
YearOfEstablishment=@year,
County=@County,
TollFree=@tollfree
WHERE CompanyID=@Acc
FETCH NEXT FROM C INTO @HQ,@year,@County,@tollfree,@Acc
END
CLOSE C
DEALLOCATE C
