UFN_RE7INTEGRATION_GETOTHERASSETS

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