MS SQL Server - Merge Replication - Filter a table by multiple tables

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Merge Replication - Filter a table by multiple tables

Tim

2005-04-28, 7:23 am

Hi,

I have a problem regarding the filtering on a merge replication.

I have a complex Customers / Products database.

Each subscriber to the publication belongs to a sales region.

The idea is to have the data filtered down depending on the sales region so
that the sales team only have the necessary data.

My problem is that the Price table requires filtering by 3 other tables.

When I add the three filter clauses in the wizard it creates a view using
UNION statements for each of the filters. This means that all the data in the
price table is being returned. I need the view created to use AND statements
so that I only get data matching all 3 criteria.

I'd thought about creating VIEWS to filter the data, but the wizard will not
all you to filter tables by VIEWS.

Can anyone help?

Sponsored Links