fnSurveyHasResponses

        create function [dbo].[fnSurveyHasResponses](
            @PKID        int
        )
        returns bit
        as
        begin
            declare @hasResponses    bit
            set @hasResponses = 0

            if exists (select top 1 id from SiteSurveyResponses where SiteSurveysId = @PKID)
                set @hasResponses = 1

            return @hasResponses
        end