Removing empty resultsets from looping through multiple tables at once

Question

My goal is to remove empty resultsets from a script I wrote to find matching values within multiple tables at once. I am currently returning empty resultsets where I've explicitly written to remove any row where the AssociatedId is empty. How can I write this to remove the empty resultsets?

Here is my SQL:

Select * From #Agreement

Declare @TableName nvarchar(256) 
Set @TableName = ''
While @TableName IS NOT NULL
Begin
    Set @TableName =  (
    Select top 1 MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
    From   INFORMATION_SCHEMA.TABLES
    Where  TABLE_TYPE = 'BASE TABLE'
        AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
        AND TABLE_NAME LIKE '%Association%'
        AND QUOTENAME(TABLE_NAME) NOT IN ('[AssociationPrivilege]'
                                        , '[AssociationMultiplicityAssociation]'
                                        , '[AssociationPrivilegeAssociation]'
                                        , '[AssociationTypeAssociation]'
                                        , '[AssociationType]'
                                        , '[AsyncOperationResultsAssociation]'
                                        , '[AttributeGroupRoleMappingAssociation]'
                                        , '[EntityAttributeDataTypeAssociation]'
                                        , '[AutoDelegationAssociation]'
                                        , '[EntityAssociation]'
                                        , '[AssociationMultiplicity]'
                                        , '[RoleAssociationMapping]')
        Group BY TABLE_SCHEMA, TABLE_NAME
    )

    Declare @SQLQuery nvarchar(500)
    Set @SQLQuery = 'SELECT AssociationName, AssociatedId FROM ' + @TableName + ' WHERE AssociatedId 
        IN (Select AgreementSysID From #Agreement) AND CAST(AssociatedId AS NVARCHAR(255)) NOT IN ('''') 
        GROUP BY AssociationName, AssociatedId'
    Exec sp_executesql @SqlQuery
End
GO