USP_DATALIST_EXCHANGEADDRESSMAPPING

Returns a list of Exchange email address type mappings.

Definition

Copy 


                    create procedure dbo.USP_DATALIST_EXCHANGEADDRESSMAPPING
                    as
                        set nocount on;

                        select
                            EXCHANGEADDRESSMAPPING.ID,
                            dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(EXCHANGEADDRESSMAPPING.ADDRESSTYPECODEID) ADDRESSTYPE,
                            EXCHANGEADDRESSMAPPING.OUTLOOKADDRESSTYPE
                        from
                            dbo.EXCHANGEADDRESSMAPPING
                        order by
                            dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION(EXCHANGEADDRESSMAPPING.ADDRESSTYPECODEID)