USP_EXCHANGECONTACTSYNC_GETPARAMETERS

            CREATE procedure dbo.USP_EXCHANGECONTACTSYNC_GETPARAMETERS
            (
                @PARAMETERSETID uniqueidentifier
            )
            as
                set nocount on;

                select
                    coalesce(dbo.UFN_EXCHANGECONTACTCATEGORYCODE_GETDESCRIPTION(EXCHANGECONTACTSYNC.EXCHANGECONTACTCATEGORYCODEID),'') as CATEGORY,
                    EXCHANGECONTACTSYNC.PAGEDEFINITIONCATALOGID as LINKPAGEID,
                    EXCHANGECONTACTSYNC.APPUSERIDSETREGISTERID,
                    EXCHANGECONTACTSYNC.CONSTITUENTIDSETREGISTERID,
                    EXCHANGECONTACTSYNC.LASTRUNON,
                    EXCHANGECONTACTSYNC.LIMITTOASSIGNEDCONSTITUENTS,
                    EXCHANGECONTACTSYNC.SPECIFICAPPUSERID,
                    EXCHANGECONTACTSYNC.APPLYTOCODE,
                    EXCHANGECONTACTSYNC.NAME,
                    EXCHANGECONTACTSYNC.DESCRIPTION
                from
                    dbo.EXCHANGECONTACTSYNC
                where
                    EXCHANGECONTACTSYNC.ID = @PARAMETERSETID;