quote:

---

Originally posted by qman

I have the following using the sp_MSforeachtable Stored Procedure.
I would like to modify the below logic to exclude tables where the
rn_edit_user or rn_create_user is not defined and also where they are
defined but not set.

I also get the message "The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.". How do I display values where there are more than 100 values in the grid? Can this be done or is this a limitation of SQL Server?

EXECUTE sp_MSforeachtable 'select o.*
from ? as o
where not exists(select * from users u
where (u.users_id = o.rn_create_user) or (u.users_id = o.rn_edit_user)
)';

---

EXECUTE sp_MSforeachtable '
IF COL_LENGTH(''?'',''rn_create_user'') >0 AND COL_LENGTH(''?'',''rn_edit_user'')>0
select top 5 o.*
from ? as o 
where not exists(select * from users u
where (u.users_id = o.rn_create_user) or (u.users_id = o.rn_edit_user)
)';