INSERT INTO UDRT_35 (             IDBDT,
                                  RUTA6,
                                  NoPesertaPBDT,
                                  NoPBDTKemsos,
                                  Vector1,
                                  Vector2,
                                  Vector3,
                                  Vector4,
                                  KDGabungan4,
                                  KDPROP,
                                  KDKAB,
                                  KDKEC,
                                  KDDESA,
                                  Alamat,
                                  AdaPKH,
                                  AdaPBDT,
                                  AdaKKS2016,
                                  AdaKKS2017,
                                  AdaPBI,
                                  AdaDapodik,
                                  AdaBPNT,
                                  NoPesertaPKH,
                                  NoPesertaKKS2016,
                                  NoPesertaPBI,
                                  PesertaKIP,
                                  NoKartuDebit,
                                  Nama_SLS,
                                  Nama_KRT,
                                  Jumlah_ART,
                                  Jumlah_Keluarga,
                                  sta_bangunan,
                                  sta_lahan,
                                  luas_lantai,
                                  lantai,
                                  dinding,
                                  kondisi_dinding,
                                  atap,
                                  kondisi_atap,
                                  jumlah_kamar,
                                  sumber_airminum,
                                  nomor_meter_air,
                                  cara_peroleh_airminum,
                                  sumber_penerangan,
                                  daya,
                                  nomor_pln,
                                  bb_masak,
                                  nomor_gas,
                                  fasbab,
                                  kloset,
                                  buang_tinja,
                                  ada_tabung_gas,
                                  ada_lemari_es,
                                  ada_ac,
                                  ada_pemanas,
                                  ada_telepon,
                                  ada_tv,
                                  ada_emas,
                                  ada_laptop,
                                  ada_sepeda,
                                  ada_motor,
                                  ada_mobil,
                                  ada_perahu,
                                  ada_motor_tempel,
                                  ada_perahu_motor,
                                  ada_kapal,
                                  aset_tak_bergerak,
                                  luas_atb,
                                  rumah_lain,
                                  jumlah_sapi,
                                  jumlah_kerbau,
                                  jumlah_kuda,
                                  jumlah_babi,
                                  jumlah_kambing,
                                  sta_art_usaha,
                                  sta_kks,
                                  sta_kip,
                                  sta_kis,
                                  sta_bpjs_mandiri,
                                  sta_jamsostek,
                                  sta_asuransi,
                                  sta_pkh,
                                  sta_rastra,
                                  sta_kur,
                                  sta_keberadaan_RT,
                                  InitData,
                                  LastUpdateData,
                                  kodewilayah,
                                  IDver,
                                  RID_RumahTangga,
                                  typedta,
                                  no_kks,
                                  sumber_data,
                                  uploaded_by,
                                  kode_sls,
                                  NOKK,
                                  id_hh,
                                  nourut_rt,
                                  NoPBDTKemsos_2017,
                                  KDPROP_2017,
                                  KDKAB_2017,
                                  KDKEC_2017,
                                  KDDESA_2017,
                                  adadivektor,
                                  KDPROP_OLD,
                                  KDKAB_OLD,
                                  KDKEC_OLD,
                                  KDDESA_OLD,
                                  id_periode,
                                  tgl_pindah,
                                  oleh_pindah,
                                  KET_BDTMEI18)
              SELECT DISTINCT
                            CASE WHEN
                            ( a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA +
                            RIGHT (('000000' +
                            CAST((dense_rank() OVER ( partition BY
                            a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA
                            ORDER BY a.Alamat,a.Nama_KRT, a.NoPBDTKemsos ))+RIGHT(b.maks,6) AS VARCHAR(5))),6)
                            ) IS NULL THEN ( a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA +
                            RIGHT (('000000' +
                            CAST((dense_rank() OVER ( partition BY
                            a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA
                            ORDER BY a.Alamat,a.Nama_KRT, a.NoPBDTKemsos )) AS VARCHAR(5))),6)
                            )
                            WHEN ( a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA +
                            RIGHT (('000000' +
                            CAST((dense_rank() OVER ( partition BY
                            a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA
                            ORDER BY a.Alamat,a.Nama_KRT, a.NoPBDTKemsos ))+RIGHT(b.maks,6) AS VARCHAR(5))),6)
                            ) IS NOT NULL THEN
                            ( a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA +
                            RIGHT (('000000' +
                            CAST((dense_rank() OVER ( partition BY
                            a.KDPROP + '' + a.KDKAB + '' + a.KDKEC + '' + a.KDDESA
                            ORDER BY a.Alamat,a.Nama_KRT, a.NoPBDTKemsos ))+RIGHT(b.maks,6) AS VARCHAR(5))),6)
                            ) END
              AS IDBDT,
              NULL AS RUTA6,
              NoPesertaPBDT,
              concat('US-',NoPBDTKemsos) AS NoPBDTKemsos,
              Vector1,
              Vector2,
              Vector3,
              Vector4,
              KDGabungan4,
              a.KDPROP,
              a.KDKAB,
              a.KDKEC,
              a.KDDESA,
              Alamat,
              AdaPKH,
              AdaPBDT,
              AdaKKS2016,
              AdaKKS2017,
              AdaPBI,
              AdaDapodik,
              NULL AS AdaBPNT,
              NoPesertaPKH,
              NoPesertaKKS2016,
              NoPesertaPBI,
              PesertaKIP,
              NULL AS NoKartuDebit,
              Nama_SLS,
              Nama_KRT,
              Jumlah_ART,
              Jumlah_Keluarga,
              sta_bangunan,
              sta_lahan,
              luas_lantai,
              lantai,
              dinding,
              kondisi_dinding,
              atap,
              kondisi_atap,
              jumlah_kamar,
              sumber_airminum,
              nomor_meter_air,
              cara_peroleh_airminum,
              sumber_penerangan,
              daya,
              nomor_pln,
              bb_masak,
              nomor_gas,
              fasbab,
              kloset,
              buang_tinja,
              ada_tabung_gas,
              ada_lemari_es,
              ada_ac,
              ada_pemanas,
              ada_telepon,
              ada_tv,
              ada_emas,
              ada_laptop,
              ada_sepeda,
              ada_motor,
              ada_mobil,
              ada_perahu,
              ada_motor_tempel,
              ada_perahu_motor,
              ada_kapal,
              aset_tak_bergerak,
              luas_atb,
              rumah_lain,
              jumlah_sapi,
              jumlah_kerbau,
              jumlah_kuda,
              jumlah_babi,
              jumlah_kambing,
              sta_art_usaha,
              sta_kks,
              sta_kip,
              sta_kis,
              sta_bpjs_mandiri,
              sta_jamsostek,
              sta_asuransi,
              sta_pkh,
              sta_rastra,
              sta_kur,
              sta_keberadaan_RT AS sta_keberadaan,
              InitData,
              LastUpdateData,
              NULL AS kodewilayah,
              NULL AS IDver,
              NULL AS RID_RumahTangga,
              NULL AS typedta,
              NULL AS no_kks,
              keterangan,
              NULL AS uploaded_by,
              NULL AS kode_sls,
              NULL AS NOKK,
              NULL AS id_hh,
              NULL AS nourut_rt,
              NULL AS NoPBDTKemsos_2017,
              NULL AS KDPROP_2017,
              NULL AS KDKAB_2017,
              NULL AS KDKEC_2017,
              NULL AS KDDESA_2017,
              NULL AS adadivektor,
              NULL AS KDPROP_OLD,
              NULL AS KDKAB_OLD,
              NULL AS KDKEC_OLD,
              NULL AS KDDESA_OLD,
              6 AS id_periode,
              NULL AS tgl_pindah,
              NULL AS oleh_pindah,
              'USULAN FNLS BDT PERIODE 6' AS KET_BDTMEI18
              FROM  RT_Import_35 a WITH (NOLOCK)
              LEFT JOIN (SELECT MAX(IDBDT) AS maks,
              KDPROP,KDKAB,KDKEC,KDDESA
              FROM UDRT_35 WHERE concat(KDPROP,KDKAB) = '3510'
              AND LEFT(RIGHT(IDBDT,6),2) < 9
                AND ISNUMERIC(IDBDT) <> 0
              AND ISNUMERIC(IDBDT) <> 0
              AND IDBDT NOT LIKE '%A%' AND IDBDT NOT LIKE '%B%'
              AND IDBDT NOT LIKE '%C%' AND IDBDT NOT LIKE '%F%'
              AND IDBDT NOT LIKE '%D%' AND IDBDT NOT LIKE '%E%'  GROUP BY KDPROP,KDKAB,KDKEC,KDDESA) b
              ON (a.KDPROP = b.KDPROP AND a.KDKAB = b.KDKAB AND a.KDKEC = b.KDKEC AND a.KDDESA = b.KDDESA)
              WHERE
              concat(a.KDPROP,a.KDKAB) = '3510' AND sta_proses = 1 AND StatusBdt = 4
              AND concat('US-',NoPBDTKemsos) NOT IN (SELECT NoPBDTKemsos FROM UDRT_35
              WHERE  concat(KDPROP,KDKAB) = '3510' AND
              id_periode = 6  AND isnull(sta_keberadaan_RT,0) IN (0,1,4)  AND KET_BDTMEI18 = 'USULAN FNLS BDT PERIODE 6')