ALTER PROCEDURE [dbo].[spx_UPDATE_EtiquetasInventariadas]
@EtiquetasInventariadas int,
@InventarioID int,
@LocalizacaoID int
AS
BEGIN



UPDATE xLocalizacao
    SET EtiquetasInventariadas = EtiquetasInventariadas + @EtiquetasInventariadas, IsValid = 1
    WHERE (LocalizacaoID = @LocalizacaoID)

    UPDATE xLocalizacao
    SET Precisao = CAST(EtiquetasInventariadas AS DECIMAL) / CAST(EtiquetasPorInventariar AS DECIMAL)
    WHERE LocalizacaoID = @LocalizacaoID

    IF NOT EXISTS(SELECT 1 FROM xLocalizacao WHERE InventarioID = @InventarioID AND isValid = 0)
    BEGIN
        SELECT 1
    END
    ELSE
    BEGIN
        SELECT -1
    END
END