spGet_ATHLETICS_TEAMS

  CREATE PROCEDURE [dbo].[spGet_ATHLETICS_TEAMS]
  (@ID int = null,
  @GenderGuid uniqueidentifier = null,
  @DivisionGuid uniqueidentifier = null,
  @SportGuid uniqueidentifier = null,
  @SeasonGuid uniqueidentifier = null,
  @ClientSitesID int
  )
  AS
  SET NOCOUNT ON

  DECLARE @EmptyGuid uniqueidentifier;
  SET @EmptyGuid = '00000000-0000-0000-0000-000000000000'

  DECLARE @temp table(id int);
  DECLARE @hasFilter bit;
  SET @hasFilter=0;

  if @ID <= 0
  SET @ID=null;

  if @GenderGuid = @EmptyGuid
  SET @GenderGuid = null;

  if @DivisionGuid = @EmptyGuid
  SET @DivisionGuid = null;

  if @SportGuid = @EmptyGuid
  SET @SportGuid = null;

  if @SeasonGuid = @EmptyGuid
  SET @SeasonGuid = null;

  if @id is not null
  begin
  set @hasFilter=1;
  INSERT into @temp(id)
  select id from athletics_teams where id=@id
  end
  else
  begin
  if @GenderGuid is not null
  begin
  set @hasFilter=1;
  INSERT into @temp(id)
  select id from athletics_teams where gender=@GenderGuid
  end

  if @DivisionGuid is not null
  begin
  set @hasFilter=1;
  INSERT into @temp(id)
  select id from athletics_teams where division=@DivisionGuid
  end

  if @SportGuid is not null
  begin
  set @hasFilter=1;
  INSERT into @temp(id)
  select id from athletics_teams where sport=@SportGuid
  end

  if @SeasonGuid is not null
  begin
  set @hasFilter=1;
  INSERT into @temp(id)
  select id from athletics_teams where season=@SeasonGuid
  end
  end

  if @hasFilter=0
  begin
  insert into @temp(id) select id from athletics_teams
  end

  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,
  at.Notes,
  at.PageCreatorClientUsersID
  from
  dbo.ATHLETICS_TEAMS at
  inner join (select id from @temp group by id) t on at.id = t.id
  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.clientsitesid=@clientsitesid
  order by Season asc
  SET NOCOUNT OFF