declare @id_state int declare @msg nvarchar(200) declare @idFilmati int declare @value nvarchar(32) declare @installation int declare @result int declare @idStateOk int declare @idStateErr int select @idfilmati=dbo.wf_api_getIdFilmatiFromJob(@id_job), @idStateOk = dbo.wf_api_getFirstTransitionState(@id_job) select top 1 @value = cod_progra, @installation = installation from filmati where id_filmati = @idfilmati select @value = substring(@value+'_ORIG', 1, 32) if (not exists (Select top 1 Id_Filmati from filmati with (nolock) where Cod_Progra = @value and id_filmati <> @idfilmati and installation = @installation)) begin update filmati with (rowlock) set cod_progra=@value where id_filmati = @idfilmati select @id_state = @idStateOk, @msg = 'Updated asset', @result= 0 end else begin select @id_state = @idStateErr, @msg = 'Code already exists', @result= 1 end exec wf_runtime_executeTransition @id_job, @id_state, 0, @msg