UFN_CONSTITUENTAPPEAL_GETRESPONSES

CREATE function dbo.[UFN_CONSTITUENTAPPEAL_GETRESPONSES]
(
  @CONSTITUENTAPPEALID uniqueidentifier
)
returns table
as
  return
  (
    select
      [CAR].[ID],
      [CAR].[DATE],
      [R].[RESPONSECATEGORYID] as [RESPONSECATEGORY],
      [CAR].[RESPONSEID],
      [R].[CODE]
    from dbo.[CONSTITUENTAPPEALRESPONSE] as [CAR]
    inner join dbo.[RESPONSE] as [R] on [CAR].[RESPONSEID] = [R].[ID]
    where [CAR].[CONSTITUENTAPPEALID] = @CONSTITUENTAPPEALID
  );