USP_REGISTRANT_SETATTENDEDSTATUS

                    create procedure dbo.USP_REGISTRANT_SETATTENDEDSTATUS
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier = null
                        )
                        as
                            set nocount on;

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

                            update
                                dbo.REGISTRANT
                            set
                                ATTENDED = 1,
                USERMARKEDATTENDANCE = 1,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = getdate()
                            where
                                REGISTRANT.ID = @ID;

                            return 0;