USP_DATALIST_CMSDISTINCTEDUCATIONALINSTITUTION

create procedure dbo.USP_DATALIST_CMSDISTINCTEDUCATIONALINSTITUTION
(
    @USEACADEMICCATALOG bit = 0,
  @AFFILIATEDONLY bit = 0
)
as
    set nocount on;

  -- If Academic Catalog is on and we want Affiliated institutes only, this grabs only institutes that are affiliated

  -- If Academic Catalog is on and we want all institutes, this grabs institutes that are and are not affiliated (all of them)

  -- If Academic Catalog is off and we want all institutes, this grabs institutes that are and are not affiliated (all of them)

  -- If Academic Catalog is off and we don't want affiliated, this grabs institutes that are not affiliated

    select distinct NAME
    from dbo.EDUCATIONALINSTITUTION
    where 
    (ISAFFILIATED = @AFFILIATEDONLY or ISAFFILIATED = @USEACADEMICCATALOG)