Index: ssts-web/src/main/webapp/dataUpdater/sqls/4.9.45_4.9.46.sql =================================================================== diff -u -r30663 -r31600 --- ssts-web/src/main/webapp/dataUpdater/sqls/4.9.45_4.9.46.sql (.../4.9.45_4.9.46.sql) (revision 30663) +++ ssts-web/src/main/webapp/dataUpdater/sqls/4.9.45_4.9.46.sql (.../4.9.45_4.9.46.sql) (revision 31600) @@ -1 +1 @@ -update TousseDefinition set assetsBelongCode = (select orgUnitCoding from SupplyRoomConfig where orgUnitName = TousseDefinition.assetsBelong and supplyRoomType = 3); \ No newline at end of file +update TousseDefinition set assetsBelongCode = (select orgUnitCoding from SupplyRoomConfig where orgUnitName = TousseDefinition.assetsBelong and supplyRoomType = 3) where assetsBelongCode is not null and assetsBelongCode <> ''; \ No newline at end of file