USP_SALESMETHODMARKETINGSURVEYCONFIGURATION_DELETE

Executes the "Sales Method Marketing Survey Configuration Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                CREATE procedure dbo.USP_SALESMETHODMARKETINGSURVEYCONFIGURATION_DELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin

                    declare @MARKETINGSURVEYQUESTIONID uniqueidentifier
                    select @MARKETINGSURVEYQUESTIONID = MARKETINGSURVEYQUESTIONID
                    from dbo.SALESMETHODMARKETINGSURVEYCONFIGURATION where ID = @ID

                    delete from dbo.MARKETINGSURVEYANSWER
                    where MARKETINGSURVEYQUESTIONID = @MARKETINGSURVEYQUESTIONID

                    exec USP_SALESMETHODMARKETINGSURVEYCONFIGURATION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
                    exec USP_MARKETINGSURVEYQUESTION_DELETEBYID_WITHCHANGEAGENTID @MARKETINGSURVEYQUESTIONID, @CHANGEAGENTID
                    return 0;

                end