USP_DATALIST_CONSTITUENT_SURVEYREPONSES

Displays a list of responses for a given survey.

Parameters

Parameter	Parameter Type	Mode	Description
@SURVEYID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_CONSTITUENT_SURVEYREPONSES
                (
                    @SURVEYID uniqueidentifier
                )
                as
                begin
                    set nocount on;

                    select
                        SURVEYRESPONSE.ID,
                        SURVEYRESPONSE.QUESTION,
                        SURVEYRESPONSE.RESPONSE
                    from
                        dbo.SURVEYRESPONSE
                    where
                        SURVEYRESPONSE.SURVEYID = @SURVEYID
                    order by
                        SURVEYRESPONSE.QUESTION, SURVEYRESPONSE.RESPONSE
                end