Home Statistics Script

--StatisticsSELECT *  fromT_SG_SJDJTJ;--Data SheetSELECT *  fromV_dataservice_ext TWHERET.data_type='0';--Check from descriptive information (statistics available, business table not)SELECT *  fromT_SG_SJDJTJ TWHEREt.msxx not inch(SELECTS.data_name fromV_dataservice_ext SWHERES.data_type='0');--Check from table nameSELECTT.*, T.rowid fromT_SG_SJDJTJ TWHERET.YWB not inch(SELECTS.table_name fromV_dataservice_ext SWHERES.data_type='0');--Comprehensive CheckSELECTM.table_name,n.ywb,m.unit_name,n.ywdw fromV_dataservice_ext M, (SELECTT.msxx,t.ywb,t.ywdw fromT_SG_SJDJTJ TWHERET.YWB not inch(SELECTS.table_name fromv_dataservice_ext S, T_SG_SJDJTJ TWHERES.data_type='0' andS.data_name=t.msxx andS.unit_name=T.YWDW--and S.TABLE_NAME<>T.YWB)) NWHEREM.data_name=N.msxx andM.data_type='0';

-- Update data this week SELECT *  from T_SG_SJDJTJ  SWHERE  s.msxxnot in(theSELECT from  t_sjtj T);

Home Statistics Script