DROP PROCEDURE IF EXISTS uspGetCsengetesiRendekByTanev
GO
  CREATE PROCEDURE uspGetCsengetesiRendekByTanev
    @pTanevId INT
  AS
  BEGIN
    SET NOCOUNT ON;

    SELECT ID
      ,C_NEV
    FROM T_CSENGETESIREND_OSSZES
    WHERE TOROLT = 'F'
      AND C_TANEVID = @pTanevId
  END
GO