spGet_ATHLETICS_EECOACHES_COACH

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

          select 
              ATHLETICS_EECOACHES.ID, 
              ATHLETICS_EECOACHES.TeamID,
              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 
              ATHLETICS_EECOACHES.ID = @ID

      END