DROP PROCEDURE  IF EXISTS uspGetTantargyTanevIdEugyintezes 
GO

CREATE PROCEDURE uspGetTantargyTanevIdEugyintezes
  @pTantargyId INT
AS
BEGIN
  SET NOCOUNT ON;

  SELECT C_TANEVID
  FROM T_TANTARGY_OSSZES
  WHERE ID = @pTantargyId
    AND TOROLT = 'F'
END
GO