spGet_ATHLETICS_ROSTER

      CREATE PROCEDURE spGet_ATHLETICS_ROSTER
          @TeamID integer
      AS
      BEGIN
          SET NOCOUNT ON;

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

      END