spGet_ATHLETICS_TEAMS_USERCANCREATEPAGE

Parameters

Parameter	Parameter Type	Mode	Description
@ClientUsersID	int	IN
Definition

Copy

CREATE PROCEDURE [dbo].[spGet_ATHLETICS_TEAMS_USERCANCREATEPAGE]
    @ClientUsersID int
AS

select       at.ID,
           cte2.description season,
           at.season SeasonGuid,
           cte4.description gender,
           at.gender GenderGuid,
           cte3.description division,
           at.division DivisionGuid,
           cte1.description sport,
           at.sport SportGuid
           from
           dbo.ATHLETICS_TEAMS at
           left join dbo.sitecodetableentries cte1 on
           at.Sport = cte1.EntryGuid
           left join dbo.sitecodetableentries cte2 on
           at.Season = cte2.EntryGuid
           left join dbo.sitecodetableentries cte3 on
           at.division = cte3.EntryGuid
           left join dbo.sitecodetableentries cte4 on
           at.gender = cte4.EntryGuid
           where
           at.PageCreatorClientUsersID = @ClientUsersID