USP_DATALIST_EXCHANGEEMAILADDRESSMAPPING

Returns a list of Exchange address type mappings.

Definition

Copy


                    create procedure dbo.USP_DATALIST_EXCHANGEEMAILADDRESSMAPPING
                    as
                        set nocount on;

                        select
                            EXCHANGEEMAILADDRESSMAPPING.ID,
                            dbo.UFN_EMAILADDRESSTYPECODE_GETDESCRIPTION(EXCHANGEEMAILADDRESSMAPPING.EMAILADDRESSTYPECODEID) EMAILADDRESSTYPE,
                            EXCHANGEEMAILADDRESSMAPPING.OUTLOOKEMAILADDRESSTYPE
                        from
                            dbo.EXCHANGEEMAILADDRESSMAPPING
                        order by
                            dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(EXCHANGEEMAILADDRESSMAPPING.EMAILADDRESSTYPECODEID)