UFN_MERCHANTACCOUNT_GETSITELIST

Retrieves the list of sites associated with merchant accounts.

Return

Return Type
table

Definition

Copy



            create function dbo.UFN_MERCHANTACCOUNT_GETSITELIST()
            returns table
            as
            return
            (
                select 
                    MERCHANTACCOUNTSITE.MERCHANTACCOUNTID as MERCHANTACCOUNTID,
                    dbo.UDA_BUILDLIST(SITE.NAME) as SITES
                from 
                    dbo.MERCHANTACCOUNTSITE
                    inner join dbo.SITE on SITE.ID = MERCHANTACCOUNTSITE.SITEID
                group by
                    MERCHANTACCOUNTSITE.MERCHANTACCOUNTID
            )