UFN_INTERACTION_GETRESPONSES

CREATE function dbo.[UFN_INTERACTION_GETRESPONSES]
(
  @INTERACTIONID uniqueidentifier
)
returns table
as
  return
  (
      select
          [IR].[ID],
          [IR].[DATE],
          [R].[RESPONSECATEGORYID] as [RESPONSECATEGORY],
          [IR].[RESPONSEID],
      [R].[CODE]
      from dbo.[INTERACTIONRESPONSE] as [IR]
        inner join dbo.[RESPONSE] as [R] on [IR].[RESPONSEID] = [R].[ID]
      where [IR].[INTERACTIONID] = @INTERACTIONID
  );