USP_DATALIST_MARKETINGSURVEYQUESTION

Returns a list of user configured marketing questions.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_MARKETINGSURVEYQUESTION
            (
                @CONTEXTID uniqueidentifier,
                @INCLUDEINACTIVE bit = 1
            )
            as
                set nocount on;

                -- Marketing survey questions

                select
                    SMMSC.ID,
                    MSQ.ID MARKETINGSURVEYQUESTIONID,
                    MSQ.NAME NAME,
                    SMMSC.ISACTIVE
                from dbo.SALESMETHODMARKETINGSURVEYCONFIGURATION SMMSC
                inner join dbo.MARKETINGSURVEYQUESTION MSQ on SMMSC.MARKETINGSURVEYQUESTIONID = MSQ.ID
                where SMMSC.SALESMETHODID = @CONTEXTID
                and @INCLUDEINACTIVE = 1 or SMMSC.ISACTIVE = 1