USP_INVITATION_GETPARAMETERS

            CREATE procedure dbo.USP_INVITATION_GETPARAMETERS
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select
                    INVITATION.NAME,
                    INVITATION.EVENTID,
                    INVITATION.BUSINESSPROCESSVIEWID,
                    case 
                        when MKTSEGMENTATION.ID is null then INVITATION.CREATEOUTPUTIDSET
                        else MKTSEGMENTATION.CREATEOUTPUTIDSET
                    end CREATEOUTPUTIDSET,
                    case 
                        when MKTSEGMENTATION.ID is null then INVITATION.OUTPUTIDSETNAME
                        else MKTSEGMENTATION.OUTPUTIDSETNAME
                    end,
                    case 
                        when MKTSEGMENTATION.ID is null then INVITATION.OVERWRITEOUTPUTIDSET
                        else MKTSEGMENTATION.OVERWRITEOUTPUTIDSET
                    end,
                    INVITATION.CUSTOMPARAMETERDATAFORMITEM,
                    INVITATION.CHANNELCODE,
                    INVITATION.CHANNELPREFERENCECODE,
                    INVITATION.MAILPACKAGEID,
                    INVITATION.EMAILPACKAGEID,
                    INVITATION.MAILDATE,
                    INVITATION.ADDRESSPROCESSINGOPTIONID,
                    INVITATION.NAMEFORMATPARAMETERID,
                    INVITATION.HOUSEHOLDINGTYPECODE,
                    INVITATION.HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD,
                    INVITATION.HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS,
                    INVITATION.HOUSEHOLDINGONERECORDPERHOUSEHOLD,
                    MKTSEGMENTATIONACTIVATEPROCESS.ID MKTSEGMENTATIONACTIVATEPROCESSID
                from dbo.INVITATION
                left join dbo.MKTSEGMENTATION 
                    on INVITATION.ID = MKTSEGMENTATION.ID
                left join dbo.MKTSEGMENTATIONACTIVATEPROCESS
                    on INVITATION.ID = MKTSEGMENTATIONACTIVATEPROCESS.SEGMENTATIONID
                where
                    INVITATION.ID = @ID;