USP_INSTALLATIONINFO_GETORCREATEAUTHSERVICETENANTID

      create procedure dbo.USP_INSTALLATIONINFO_GETORCREATEAUTHSERVICETENANTID
      as
      set nocount on;

      declare @TENANTID uniqueidentifier = null; 
      select top 1 @TENANTID = [AUTHSERVICETENANTID] from dbo.[INSTALLATIONINFO];

      if @TENANTID is null
      begin
        set @TENANTID = newid();
        update dbo.[INSTALLATIONINFO]
          set [AUTHSERVICETENANTID] = @TENANTID
         where [AUTHSERVICETENANTID] is null; 
      end

      select @TENANTID [AUTHSERVICETENANTID];