ตัวอย่าง 1 การเปรียบเทียบเทเบิ้ล ตำบล อำเภอ สองชุด เพื่อคัดลอกรหัสไปรษณีย์

/*  -- DATA NOT EQUAL !!!!! ---

select DISTINCT COUNT(*) AS DIST_113 from DISTRICT
select DISTINCT COUNT(*) AS DIST_ICON from ICON_EntForms_District
select DISTINCT COUNT(*) AS SDIST_113 from SUBDISTRICT
select DISTINCT COUNT(*) AS SDIST_ICON from ICON_EntForms_SubDistrict

*/

--- COMPARE (DIST,SDIST)   // DATA NOT EQUAL//

SELECT DISTINCT COUNT(*) AS TOTAL_113
         FROM SUBDISTRICT  SD INNER JOIN DISTRICT D
         ON  SD.SDIST_DIST_ID = D.DIST_ID
SELECT DISTINCT COUNT(*) AS TOTAL_ICON
     FROM ICON_EntForms_SubDistrict ISD INNER JOIN  ICON_EntForms_District ID
         ON ISD.DistrictID=ID.DistrictID

---------------FUNCTION TO UPDATE POSTAL IN SUBDISTRICT ---------------------

DECLARE @SDIST_NAME NVARCHAR(255)
DECLARE @DIST_NAME NVARCHAR(255)
DECLARE @POSTAL NVARCHAR(10)

DECLARE @TOTAL INT
DECLARE @I INT
SET @I =0

SELECT DISTINCT @TOTAL = COUNT (*) FROM  SUBDISTRICT  SD INNER JOIN
DISTRICT D ON  SD.SDIST_DIST_ID = D.DIST_ID

WHILE (@I<=@TOTAL)
  BEGIN
     SET @I+=1
 --- INTITIAL DIST,SDIST
     SELECT @SDIST_NAME = SDIST_NAME,@DIST_NAME =DIST_NAME
         FROM SUBDISTRICT  SD INNER JOIN DISTRICT D
                       ON  SD.SDIST_DIST_ID = D.DIST_ID
         WHERE SD.SDIST_ID = (@I+34296)

 --- FIND POSTAL FOR EACH (DIST,SDIST)
     SELECT @POSTAL=ISD.PostCode
     FROM ICON_EntForms_SubDistrict ISD INNER JOIN  ICON_EntForms_District ID
                       ON ISD.DistrictID=ID.DistrictID
         WHERE ISD.SubDistrictName = @SDIST_NAME AND ID.DistrictName=@DIST_NAME

 --- PRINT (UPDATE)
     --PRINT(CONVERT(VARCHAR(10),@I)+','+@DIST_NAME+','+@SDIST_NAME+','+@POSTAL)
     UPDATE SUBDISTRICT SET SDIST_POSTAL =@POSTAL WHERE SDIST_ID = (@I+34296)

  END

--PRINT(@TOTAL)