UFN_EDUCATIONALDEPARTMENTCODE_GETID_FROMNAME

create function dbo.UFN_EDUCATIONALDEPARTMENTCODE_GETID_FROMNAME(
@Description nvarchar(100),
@IsAffiliated bit = 0,
@AcademicCatalogOn bit = 0
)
RETURNS uniqueidentifier WITH EXECUTE AS CALLER
AS
begin
    declare @RETURNVALUE uniqueidentifier;

  declare @TABLE_OF_ALL_IDS table(ID uniqueidentifier, DESCRIPTION nvarchar(100));

  if @IsAffiliated = 1 and @AcademicCatalogOn = 1
  begin
      select top 1 @RETURNVALUE = ID
      from
      dbo.ACADEMICCATALOGDEPARTMENT AC
      where
      AC.NAME = @Description;
  end
  else
  begin
      select top 1 @RETURNVALUE = ID
      FROM 
      dbo.EDUCATIONALDEPARTMENTCODE EC
      where
      EC.DESCRIPTION = @Description;
  end

    return @RETURNVALUE;
end