spGet_ATHLETICS_ROSTER_STUDENT

      CREATE PROCEDURE [dbo].[spGet_ATHLETICS_ROSTER_STUDENT]
          @ID integer
      AS
      BEGIN
          SET NOCOUNT ON;

          select 
              ID, 
              TeamID, 
              PlayerEEID, 
              Position, 
              FirstName, 
              LastName, 
              Number 
          from 
              ATHLETICS_ROSTERS 
          where 
              ID = @ID

      END