USP_SIMPLEDATALIST_RESPONSE

This simple datalist returns all the active responses for a given category.

Parameters

Parameter	Parameter Type	Mode	Description
@RESPONSECATEGORYID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_RESPONSE(@RESPONSECATEGORYID uniqueidentifier)
            as
                set nocount on;

                select 
                    R.ID as VALUE,
                    R.RESPONSE as LABEL
                from
                    dbo.RESPONSE as R
                    inner join dbo.RESPONSECATEGORY as RC on r.RESPONSECATEGORYID = RC.ID
                where R.RESPONSECATEGORYID = @RESPONSECATEGORYID
                and R.ISINACTIVE = 0
                order by
                    case RC.SORTMETHODCODE when 1 then R.SEQUENCE else 0 end,
                    R.RESPONSE;