spGet_ATHLETICS_EECOACHES_BYTEAM

      CREATE PROCEDURE [dbo].[spGet_ATHLETICS_EECOACHES_BYTEAM]
          @TeamID integer
      AS
      BEGIN
          SET NOCOUNT ON;

          select 
              ATHLETICS_EECOACHES.ID, 
              ATHLETICS_EECOACHES.CoachEEID, 
              ATHLETICS_EECOACHES.FirstName, 
              ATHLETICS_EECOACHES.LastName, 
              ATHLETICS_EECOACHES.[Type] as TypeGuid,
              SiteCodeTableEntries.Description as [Type],
              ATHLETICS_EECOACHES.HideContactInfo
          from 
              ATHLETICS_EECOACHES
          left join 
              SiteCodeTableEntries on SiteCodeTableEntries.EntryGUID = ATHLETICS_EECOACHES.Type
          where 
              TeamID = @TeamID
          order by LastName

      END