DROP PROCEDURE  IF EXISTS uspGetKozteruletJellegekEugyintezes 
GO

CREATE PROCEDURE uspGetKozteruletJellegekEugyintezes
   @pKozteruletJellegeNa INT
  ,@pTipusId INT
  ,@pTanevId INT

AS
BEGIN
  SET NOCOUNT ON;

  SELECT DictionaryItemBase.ID AS KretaAzonosito
    ,DictionaryItemBase.C_NAME AS Megnevezes
  FROM T_DICTIONARYITEMBASE_OSSZES DictionaryItemBase
  INNER JOIN T_INTEZMENY_OSSZES Intezmeny ON Intezmeny.ID = DictionaryItemBase.C_INTEZMENYID
    AND Intezmeny.TOROLT ='F'
    AND DictionaryItemBase.C_DICTIONARYTYPEID = @pTipusId
  WHERE DictionaryItemBase.TOROLT = 'F'
    AND DictionaryItemBase.ID <> @pKozteruletJellegeNa
    AND DictionaryItemBase.C_TANEVID = @pTanevId
END
GO