UFN_PROSPECTSEARCH_GET_SELECTEDTILES

CREATE function dbo.UFN_PROSPECTSEARCH_GET_SELECTEDTILES(@APPUSERID uniqueidentifier)
returns @SELECTEDTILES table
(
  ID uniqueidentifier NULL,
  PROSPECTSEARCHAVAILABLETILEID uniqueidentifier NULL,
  TILEID uniqueidentifier NULL,
  SEQUENCE int NULL
)
as begin
    if exists(select top 1 1 from PROSPECTSEARCHSELECTEDTILE where APPUSERID = @APPUSERID)
  begin

    insert into @SELECTEDTILES (
      ID,
      PROSPECTSEARCHAVAILABLETILEID,
      TILEID,
      SEQUENCE
    )
    select 
      selectedTile.ID,
      availableTile.ID,
      availableTile.DATAFORMINSTANCECATALOGID,
      selectedTile.SEQUENCE
    from 
        dbo.PROSPECTSEARCHSELECTEDTILE selectedTile
    left join
      dbo.PROSPECTSEARCHAVAILABLETILE availableTile on selectedTile.PROSPECTSEARCHAVAILABLETILEID = availableTile.ID
    left join
        PROSPECTSEARCHAVAILABLETILEFORACCOUNTTYPE account on availableTile.ID = account.PROSPECTSEARCHAVAILABLETILEID
    inner join
      WEALTHPOINTCONFIGURATION config on config.ACCOUNTTYPECODE = account.ACCOUNTTYPECODE
    where 
        selectedTile.APPUSERID = @APPUSERID
    order by
        selectedTile.SEQUENCE;

  end else begin

    insert into @SELECTEDTILES (
      ID,
      PROSPECTSEARCHAVAILABLETILEID,
      TILEID,
      SEQUENCE
    )
      select 
      NULL,
          availableTile.ID,
      availableTile.TILEID,
          tile.SEQUENCE
      from 
          UFN_PROSPECTSEARCH_GET_AVAILABLETILES() availableTile
      left join 
          PROSPECTSEARCHAVAILABLETILE tile on tile.ID = availableTile.ID
      where 
          tile.ISDEFAULT = 1
      order by 
          tile.SEQUENCE;
  end
    return;
end