UPDATE VS4TMOHAllocate Set TMOHAllocateTypeDM=5 WHERE TMOHAllocateTypeDM=7
GO
UPDATE VS4TMOHAllocate Set TMOHAllocateTypeDM=6 WHERE TMOHAllocateTypeDM=8
GO
UPDATE VS4TMOHAllocate Set TMOHAllocateTypeDL=7 WHERE TMOHAllocateTypeDL>7
GO
UPDATE VS4TMOHAllocate Set TMOHAllocateTypeOH=7 WHERE TMOHAllocateTypeOH>7
GO
