UFN_RE7INTEGRATION_GETSECURITIES

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