UFN_MERCHANTACCOUNT_GETSITES

Returns all sites for a given merchant account.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@MERCHANTACCOUNTID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_MERCHANTACCOUNT_GETSITES
            (
                @MERCHANTACCOUNTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select 
                    ID, SITEID
                from 
                    dbo.MERCHANTACCOUNTSITE
                where 
                    MERCHANTACCOUNTSITE.MERCHANTACCOUNTID = @MERCHANTACCOUNTID
            )