USP_SIMPLEDATALIST_MARKETINGSURVEYQUESTIONANSWER

Returns a list of preset answers for marketing a survey question.

Parameters

Parameter	Parameter Type	Mode	Description
@MARKETINGSURVEYQUESTIONID	uniqueidentifier	IN	MARKETINGSURVEYQUESTIONID

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_MARKETINGSURVEYQUESTIONANSWER
            (
                @MARKETINGSURVEYQUESTIONID uniqueidentifier
            )
            as
            select 
                ID as VALUE, 
                ANSWERTEXT as LABEL
            from dbo.MARKETINGSURVEYANSWER
            where MARKETINGSURVEYQUESTIONID = @MARKETINGSURVEYQUESTIONID
            and ISACTIVE = 1
            order by ANSWERTEXT