fnSiteCodeTableEntryIsUsed

            CREATE function [dbo].[fnSiteCodeTableEntryIsUsed]
            (    
                @CodeTableID int, 
                @EntryGUID uniqueidentifier
            )
            returns int
            -- determines if a code table entry is used somewhere in the system
            -- returning 1 means 'yes - it is used'; 0 means 'no'
            as
            begin
                /* @CodeTableID Values
                Public Enum ESiteCodeTableTypes as Integer
                    EventCalendarCategories = 1
                    SiteTags = 2
                    AthleticsSports = 3
                    AthleticsDivisions = 4
                    AthleticsGenders = 5
                    AthleticsCoachTypes = 6
                    AthleticsSeasons = 7
                    AthleticsOpponents = 9
                End Enum
                */
                declare @IsUsed int
                set @IsUsed = 0

                -- for each code table, append your own if-block check below:
                if (@CodeTableID=1) 
                    begin
                        IF EXISTS (select EventCalendarID, CalendarCategoryPicksID, CategoryCodeTableEntryID   
                            from dbo.CalendarEvtCategoryPicks 
                            where CategoryCodeTableEntryID = @EntryGUID)            
                        SET @IsUsed=1        
                    end
                else if (@CodeTableID=3)
                    begin
                        if exists (select ID from ATHLETICS_TEAMS where Sport = @EntryGUID)
                        set @IsUsed=1
                    end
                else if (@CodeTableID=4)
                    begin
                        if exists (select ID from ATHLETICS_TEAMS where Division = @EntryGUID)
                        set @IsUsed=1
                    end
                else if (@CodeTableID=5)
                    begin
                        if exists (select ID from ATHLETICS_TEAMS where Gender = @EntryGUID)
                        set @IsUsed=1
                    end
                else if (@CodeTableID=6)
                    begin
                        if exists (select ID from ATHLETICS_EECOACHES where [Type] = @EntryGUID)
                        set @IsUsed=1
                    end
                else if (@CodeTableID=7)
                    begin
                        if exists (select ID from ATHLETICS_TEAMS where Season = @EntryGUID)
                        set @IsUsed=1
                    end
                else if (@CodeTableID=9)
                    begin
                        if exists (select ID from ATHLETICS_EVENTS where OpponentID = @EntryGUID)
                        set @IsUsed=1
                    end

                return(@IsUsed)
            end