fnCalEvtCategoryIsPicked

            CREATE function [dbo].[fnCalEvtCategoryIsPicked](@CalID int, @EntryGUID uniqueidentifier)
            returns int
            -- determines if a calendar event category is used in a calendar
            begin
                declare @IsPicked int
                set @IsPicked = 0
                    IF EXISTS (select EventCalendarID, CalendarCategoryPicksID, CategoryCodeTableEntryID  
                        from dbo.CalendarEvtCategoryPicks
                        where EventCalendarID = @CalId and CategoryCodeTableEntryID = @EntryGUID)
                        SET @IsPicked=1

                return(@IsPicked)
            end