UFN_CHECK_EVENTISACTIVE

            CREATE function dbo.UFN_CHECK_EVENTISACTIVE(@designationId uniqueidentifier) 
            returns bit
            as
            begin


      if(@DESIGNATIONID is null or @DESIGNATIONID = '00000000-0000-0000-0000-000000000000')
      begin
      return 1 --No designation id 

      end

      If exists(select 1 from dbo.DESIGNATION where ID=@designationId and ISACTIVE=1)
      begin
      return 1
      end
      return 0
      end