USP_EXCHANGEDOWNLOADPROCESS_GETSETTINGS

            CREATE procedure dbo.USP_EXCHANGEDOWNLOADPROCESS_GETSETTINGS
            (
                @EXCHANGEDOWNLOADPROCESSID uniqueidentifier
            )
            as
                set nocount on;

                if @EXCHANGEDOWNLOADPROCESSID is null begin
                    select top 1 @EXCHANGEDOWNLOADPROCESSID = ID from dbo.EXCHANGEDOWNLOADPROCESS;
                end

                select
                    EXCHANGEDOWNLOADPROCESS.ID,
                    EXCHANGEDOWNLOADPROCESS.NAME,
                    EXCHANGEDOWNLOADPROCESS.EXCLUDEPERSONAL as EXCLUDEPERSONALEMAILS,
                    EXCHANGEDOWNLOADPROCESS.EXCLUDEPRIVATE as EXCLUDEPRIVATEEMAILS,
                    EXCHANGEDOWNLOADPROCESS.EXCLUDECONFIDENTIAL as EXCLUDECONFIDENTIALEMAILS,
                    EXCHANGEDOWNLOADPROCESS.EXCLUDEAUTOREPLY as EXCLUDEAUTOREPLYEMAILS,
                    EXCHANGEDOWNLOADPROCESS.EMAILBATCHAPPUSERID as DEFAULTEMAILBATCHOWNERID,
                    EXCHANGEDOWNLOADPROCESS.CONTACTBATCHAPPUSERID as DEFAULTCONTACTBATCHOWNERID,
                    EXCHANGEDOWNLOADPROCESS.CALENDARITEMBATCHAPPUSERID as DEFAULTCALENDARITEMBATCHOWNERID,
                    EXCHANGEDOWNLOADPROCESS.MAXEMAILBATCHROWCOUNT,
                    EXCHANGEDOWNLOADPROCESS.MAXCONTACTBATCHROWCOUNT,
                    EXCHANGEDOWNLOADPROCESS.MAXCALENDARITEMBATCHROWCOUNT,                                   
                    dbo.UFN_EXCHANGECONTACTBATCHASSIGNMENT_RESOLVEDASSIGNMENTS_TOITEMLISTXML(EXCHANGEDOWNLOADPROCESS.ID) as CONTACTBATCHASSIGNMENTS,
                    dbo.UFN_EXCHANGEEMAILBATCHASSIGNMENT_RESOLVEDASSIGNMENTS_TOITEMLISTXML(EXCHANGEDOWNLOADPROCESS.ID) as EMAILBATCHASSIGNMENTS,
                    dbo.UFN_EXCHANGECALENDARITEMBATCHASSIGNMENT_RESOLVEDASSIGNMENTS_TOITEMLISTXML(EXCHANGEDOWNLOADPROCESS.ID) as CALENDARITEMBATCHASSIGNMENTS,                                   
                    (select COUNTRY.DESCRIPTION from dbo.COUNTRY where COUNTRY.ID = EXCHANGEDOWNLOADPROCESS.DEFAULTCOUNTRYID) as DEFAULTCOUNTRY,
                    EXCHANGEDOWNLOADPROCESS.DEFAULTINTERACTIONTYPECODEID as DEFAULTINTERACTIONTYPECODEID,
                    EXCHANGEDOWNLOADPROCESS.DEFAULTINFOSOURCECODEID as DEFAULTINFOSOURCECODEID
                from
                    dbo.EXCHANGEDOWNLOADPROCESS
                where
                    EXCHANGEDOWNLOADPROCESS.ID = @EXCHANGEDOWNLOADPROCESSID;