ELSE IF @Id2=11 BEGIN DECLARE @Cob as varchar(1), @Servico as varchar(5) SELECT @Cob = Cobranca , @Servico = Servico, @Ano = Ano, @Processo = Processo FROM Servicos WHERE ServicoID = @ID UPDATE Servicos SET Paginas=@Id3 WHERE ServicoID=@Id IF EXISTS(SELECT Ano FROM Servicos WHERE Ano = @Ano AND Processo = @Processo AND Servico = @Servico AND Cobranca IN ( 'N', 'R') AND Paginas = 0) AND @Id3 > 0 BEGIN UPDATE Servicos SET Paginas=@Id3 WHERE Ano = @Ano AND Processo = @Processo AND Servico = @Servico AND Cobranca IN ( 'N', 'R') AND Paginas = 0 END END