update vimis.SMIVersion set SMIVersionStatus_id = ( select vsvu.SMIVersionStatus_id from vimis.SMIVersionStatus
        vsvu where vsvu.SMIVersionStatus_Code = 1)
        where SMIVersionStatus_id = ( select vsvs.SMIVersionStatus_id from vimis.SMIVersionStatus vsvs where
        vsvs.SMIVersionStatus_Code = 7)
