UFN_CONSTITUENTCORRESPONDENCE_GETRESPONSES

            CREATE function dbo.UFN_CONSTITUENTCORRESPONDENCE_GETRESPONSES(@CONSTITUENTCORRESPONDENCEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    CCR.ID,
                    CCR.DATE,
                    R.RESPONSECATEGORYID as RESPONSECATEGORY,
                    CCR.RESPONSEID,
                    R.CODE
                from
                    dbo.CONSTITUENTCORRESPONDENCERESPONSE as CCR
                    inner join dbo.RESPONSE as R on CCR.RESPONSEID = R.ID
                where
                    CCR.CONSTITUENTCORRESPONDENCEID = @CONSTITUENTCORRESPONDENCEID
            );