DROP PROCEDURE IF EXISTS uspUpdateErtekelesModTipus
GO

CREATE PROCEDURE uspUpdateErtekelesModTipus
   @pIntezmenyId INT
  ,@pTanevId INT
  ,@pUserId INT
  ,@pId INT
  ,@pIsBold CHAR(1)
  ,@pSuly INT
AS
BEGIN

  SET NOCOUNT ON;

  UPDATE
    T_ERTEKELESMOD_OSSZES
  SET
     C_ISBOLD = @pIsBold
    ,C_SULY = @pSuly
    ,SERIAL = SERIAL + 1
    ,LASTCHANGED = GETDATE()
    ,MODIFIER = @pUserId
  WHERE ID = @pId
    AND C_ALINTEZMENYID = @pIntezmenyId
    AND C_ALTANEVID = @pTanevId

END

GO