USP_DATALIST_EXCHANGEPHONEMAPPING

Returns a list of Exchange phone type mappings.

Definition

Copy 


                    create procedure dbo.USP_DATALIST_EXCHANGEPHONEMAPPING
                    as
                        set nocount on;

                        select
                            EXCHANGEPHONEMAPPING.ID,
                            dbo.UFN_PHONETYPECODE_GETDESCRIPTION(EXCHANGEPHONEMAPPING.PHONETYPECODEID) PHONETYPE,
                            EXCHANGEPHONEMAPPING.OUTLOOKPHONETYPE
                        from
                            dbo.EXCHANGEPHONEMAPPING
                        order by
                            dbo.UFN_PHONETYPECODE_GETDESCRIPTION(EXCHANGEPHONEMAPPING.PHONETYPECODEID)