Removing Empty Waves
To remove empty waves, run the following SQL script:
Copy
UPDATE WVE LEFT OUTER JOIN PCK ON WVE.WaveID = PCK.WaveID SET WaveStatus = 'Complete' WHERE PCK.WaveID IS NULL
AND WVE.WaveStatus = 'Released';
UPDATE WVE LEFT OUTER JOIN PCK ON WVE.WaveID = PCK.WaveID SET WaveStatus = 'Complete' WHERE PCK.WaveID IS NULL
AND WVE.WaveStatus = 'Ready';