UFN_EXCHANGEEMAILBATCH_GETSITES

Given an exchange email batch entry, retrieves its list of sites.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EXCHANGEEMAILBATCHID	uniqueidentifier	IN

Definition

Copy




            create function dbo.UFN_EXCHANGEEMAILBATCH_GETSITES
            (
                @EXCHANGEEMAILBATCHID uniqueidentifier
            )
            returns table
            as
                return(
                    select
                        EXCHANGEEMAILBATCHSITE.ID,
                        EXCHANGEEMAILBATCHSITE.SITEID
                    from dbo.EXCHANGEEMAILBATCHSITE
                        inner join EXCHANGEEMAILBATCH on EXCHANGEEMAILBATCH.ID = EXCHANGEEMAILBATCHSITE.EXCHANGEEMAILBATCHID
                    where EXCHANGEEMAILBATCH.ID = @EXCHANGEEMAILBATCHID
                        and EXCHANGEEMAILBATCH.ADDASINTERACTION = 1
                )