USP_BBNC_CREATESURVEYRESPONSE

Creates a response to a survey generated by Blackbaud Internet Solutions.

Parameters

Parameter	Parameter Type	Mode
@RESPONSEID	uniqueidentifier	INOUT
@SURVEYID	uniqueidentifier	IN
@QUESTION	nvarchar(max)	IN
@RESPONSE	nvarchar(max)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_CREATESURVEYRESPONSE
            (
                @RESPONSEID uniqueidentifier = null output,
                @SURVEYID uniqueidentifier,
                @QUESTION nvarchar(max),
                @RESPONSE nvarchar(max),
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

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

                if @CHANGEDATE is null
                    set @CHANGEDATE = getdate();

                if @RESPONSEID is null
                    set @RESPONSEID = newid();

                insert into dbo.SURVEYRESPONSE(ID, SURVEYID, QUESTION, RESPONSE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values(@RESPONSEID, @SURVEYID, @QUESTION, @RESPONSE, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;