UFN_EVENTLODGINGLOCATION_ISUNIQUE

      create function dbo.UFN_EVENTLODGINGLOCATION_ISUNIQUE(
        @EVENTID uniqueidentifier,
        @EVENTLODGINGLOCATIONID uniqueidentifier
        )

        returns bit
        with execute as caller
        as begin
          declare @DUPLICATECOUNT int;

          select
            @DUPLICATECOUNT = count(ID)
          from
            dbo.EVENTLODGING
          where
            EVENTID = @EVENTID and
            EVENTLODGINGLOCATIONID = @EVENTLODGINGLOCATIONID

          if @DUPLICATECOUNT < = 1
            return 1;

          return 0;
        end