UFN_RE7INTEGRATION_GETBUSINESSES

            create function dbo.UFN_RE7INTEGRATION_GETBUSINESSES(@ID uniqueidentifier, @TOPN integer = 100)
            returns table
            as
                return
          select top (@TOPN)
            ID,
            COMPANY as DESCRIPTION,
            OWNERSHIPVALUE as VALUE
          from 
            dbo.WPBUSINESSOWNERSHIP
          where 
            WEALTHID = @ID and CONFIRMED = 1
          order by 
            VALUE desc, DESCRIPTION asc;