Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Filtering

Author  Topic  william Starting Member 8 Posts Posted - 2001-04-22 : 18:18:43 Suppose I have a table that looks like this: RecordID Name And then a matrix table that links these records to users: RecordID UserID Then in a stored procedure I have built a temp table containing a list of user ID's suppose it's called #UserFilter. What I want to do is list all records that are associated with ALL user's in the #UserFilter. Can anyone help me with this? Thanks.