USP_DATALIST_INTERACTIONRESPONSE

Lists all responses for a given interaction.

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATALIST_INTERACTIONRESPONSE (
                        @INTERACTIONID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select    
                            RC.NAME as RESPONSECATEGORY,
                            R.RESPONSE
                        from 
                            dbo.INTERACTIONRESPONSE as IR
                            left join dbo.RESPONSE as R on IR.RESPONSEID = R.ID
                            left join dbo.RESPONSECATEGORY as RC on R.RESPONSECATEGORYID = RC.ID
                        where (IR.INTERACTIONID = @INTERACTIONID);