UFN_RESPONSECATEGORY_GETRESPONSES

Returns all responses for a given response category.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@RESPONSECATEGORYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_RESPONSECATEGORY_GETRESPONSES(@RESPONSECATEGORYID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    ID,
                    RESPONSE,
                    SEQUENCE
                from
                    dbo.RESPONSE
                where
                    RESPONSECATEGORYID = @RESPONSECATEGORYID
            );