spDelete_SurveyCheck

    create procedure dbo.spDelete_SurveyCheck(
        @PKID            integer
    )
    as
    begin
        if exists(select * from SiteSurveyResponses where SiteSurveysId = @PKID)
            RAISERROR('Unable to delete Survey - It has one or more responses.',16,1)

    end