Violation of PRIMARY KEY constraint 'PK_MED_PLPARAM'. Cannot insert duplicate key in object 'dbo.MED_PLPARAM'.
The statement has been terminated

Violation of PRIMARY KEY constraint 'PK_MED_PLPARAM'. Cannot insert duplicate key in object 'dbo.MED_PLPARAM'.
The statement has been terminated

SELECT @ID+ (SELECT SUM(1) FROM PL_SUBJ_PARAM psp JOIN PL_SUBJ ps ON PS.PL_SUBJ_ID = PSP.PL_SUBJ_ID
JOIN MEDECINS m ON M.MEDECINS_ID=PS.MEDECINS_ID
where psp.PL_PARAM_ID=79 AND m.MEDECINS_ID<=MEDECINS.MEDECINS_ID)

SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[MED_PLPARAM](
	[MED_PLPARAM_ID] [int] NOT NULL,
	[PL_PARAM_ID] [int] NOT NULL,
	[MEDECINS_ID] [int] NULL,
	[KRN_CREATE_DATE] [datetime] NULL,
	[KRN_CREATE_USER_ID] [int] NULL,
	[KRN_MODIFY_DATE] [datetime] NULL,
	[KRN_MODIFY_USER_ID] [int] NULL,
	[KRN_CREATE_DATABASE_ID] [int] NULL,
	[KRN_MODIFY_DATABASE_ID] [int] NULL,
	[KRN_GUID] [varchar](36) NULL,
 CONSTRAINT [PK_MED_PLPARAM] PRIMARY KEY CLUSTERED 
(
	[MED_PLPARAM_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

select MED_PLPARAM_ID from MED_PLPARAM 
where  MEDECINS_ID = 1737 
and  PL_PARAM_ID = 7 

declare @P1 int
exec up_get_id  @KeyName = 'MED_PLPARAM', @Shift = 1, @ID = @P1 output
select @P1 Result

insert into MED_PLPARAM
(MED_PLPARAM_ID,PL_PARAM_ID,MEDECINS_ID, KRN_CREATE_DATE, KRN_CREATE_USER_ID, KRN_MODIFY_DATE, KRN_MODIFY_USER_ID)
values(4359,7,1737, convert(varchar(30),GetDate(),20), 1, convert(varchar(30),GetDate(),20), 1)

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[up_get_id](@KeyName varchar(30),@Shift integer,@ID integer output)
as
begin
  declare
    @rc int,
    @err int 
  begin tran
  
  update V set LAST_VALUE = COALESCE(LAST_VALUE,0) + @Shift 
    from ID_VALUES V with (UPDLOCK, ROWLOCK)  
    where Key_NAME = @KeyName
  select @rc = @@RowCount,
         @err = @@Error    
  if @err <> 0 goto L_ERROR
  if @rc = 0       
  begin
    insert into ID_VALUES values(@KeyName, @Shift)
    if @@ERROR<>0 goto L_ERROR
  end  
  select @ID = LAST_VALUE - @Shift + 1 
    from ID_VALUES 
    where KEY_NAME=@KeyName

  commit tran
  
  return 0
  L_ERROR: if @@TRANCOUNT<>0 rollback tran
  raiserror 50001 'E001-Error in sp_get_id.'
end