USP_CONSTITUENT_ADDEVENTRESTRICTION

            create procedure dbo.USP_CONSTITUENT_ADDEVENTRESTRICTION
            (
                @CONSTITUENTID uniqueidentifier,
                @EVENTRESTRICTIONOPTIONID uniqueidentifier
            )
            as
            begin

                declare @CURRENTDATE datetime;
                declare @CHANGEAGENTID uniqueidentifier;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                set @CURRENTDATE = getdate();

                if (select count(*) from dbo.CONSTITUENTRESTRICTIONOPTION
                    where CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = @CONSTITUENTID
                    and CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID = @EVENTRESTRICTIONOPTIONID) = 0 begin
                        insert into CONSTITUENTRESTRICTIONOPTION
                            (ID, CONSTITUENTID, EVENTRESTRICTIONOPTIONID, 
                             ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values
                            (newid(), @CONSTITUENTID, @EVENTRESTRICTIONOPTIONID,
                             @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
                end
            end