USP_DATALIST_CONSTITUENTINTERACTIONRESPONSE

CREATE procedure dbo.[USP_DATALIST_CONSTITUENTINTERACTIONRESPONSE]
(
    @INTERACTIONID uniqueidentifier
)
as
    set nocount on;

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