USP_DATALIST_RESPONSE

Lists all responses for a given category.

Parameters

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

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_RESPONSE]
(
    @RESPONSECATEGORYID uniqueidentifier,
    @INCLUDEINACTIVE bit = 1
)
as
    declare @SORTMETHODCODE tinyint;
    set @SORTMETHODCODE = (select [SORTMETHODCODE] from dbo.[RESPONSECATEGORY] where [ID] = @RESPONSECATEGORYID);

    set nocount on;

    select    
        [ID],
        [RESPONSE],
        1 - [ISINACTIVE],
        [SEQUENCE],
    [CODE]
    from dbo.[RESPONSE]
    where ([RESPONSECATEGORYID] = @RESPONSECATEGORYID) 
    and (@INCLUDEINACTIVE = 1 or [ISINACTIVE] = 0)
    order by case @SORTMETHODCODE when 1 then [SEQUENCE] else 0 end, [RESPONSE];