UFN_EVENTLODGINGLOCATIONROOM_ISUNIQUE

      create function dbo.UFN_EVENTLODGINGLOCATIONROOM_ISUNIQUE(
        @EVENTLODGINGID uniqueidentifier,
        @ROOMTYPECODEID uniqueidentifier
        )

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

          select
            @DUPLICATECOUNT = count(ID)
          from
            dbo.EVENTLODGINGROOM
          where
            ROOMTYPECODEID = @ROOMTYPECODEID and
            EVENTLODGINGID = @EVENTLODGINGID

          if @DUPLICATECOUNT < = 1
            return 1;

          return 0;
        end