fnSiteSurveyResultAlreadySubmitted

    create function dbo.fnSiteSurveyResultAlreadySubmitted(
        @ClientUsersId        int,
        @SiteSurveysID      int
    )
    returns bit
    as
    begin
        declare @Submitted bit
        set @Submitted = 0
        if exists (select * from SiteSurveyResponses 
            where @ClientUsersId > 0
            and SiteSurveysId = @SiteSurveysID
            and ClientUsersId = @ClientUsersId)
            set @Submitted = 1

        return @Submitted
    end