--MIScleanup
--Delete records where all values are 0
--Changes in SP UpdateMISTable stops generating these records

DELETE from MISTABLE 
where BookedPrice = 0 and BookedPackage = 0 and ActualPrice = 0 and ActualPackage = 0 
and BookedAdult + BookedChildren1 + BookedChildren2 = 0 and ActualAdult + ActualChildren1 + ActualChildren2 = 0 
and BookedNumberOfRooms = 0 and ActualNumberOfRooms = 0



