Что мне надо написать в условии фильтра, чтобы для каждого подписчика публикации отдавалась только его часть данных?


Dynamic Filters
Dynamic filters allow you to create a merge publication and then filter data from the publishing table providing different partitions of data to different Subscribers. Benefits of using dynamic filters in merge publications are:

Fewer publications stored at the Publisher. This reduces the overhead of administering multiple publications.


Employing user-defined functions in the dynamic filter enables you to filter criteria.


The Subscriber receives only the information needed because data is filtered based onthe connection properties of the Merge Agent for the subscription.
In the dynamic filter, you specify a Microsoft® SQL Server™ 2000 function or a user-defined function that is evaluated differently for each Subscriber based on the connection properties of the Merge Agent when the merge process is replicating data between the Subscriber and Publisher. The most common system functions used for this purpose are SUSER_SNAME() and HOST_NAME(). You can use a user-defined function in a dynamic filter, but unless the user-defined function definition includes SUSER_SNAME(), HOST_NAME(), or the user-defined function evaluates one of these system functions in the filter criteria (such as MyUDF(SUSER_SNAME()), the user-defined function will be static.

Dynamic filters are row filters (restricting rows of data) and are created on a single table basis (they do not cross or join tables). You can, however, use both dynamic filters and join filters in the same publication and on the same published tables.

Dynamic filters are available only with merge replication, so when using them, you should consider employing a dynamic snapshot as well. By default, dynamic filtered publications rely on INSERTs from the Publisher to apply data to the Subscriber as part of the initial snapshot. Dynamic snapshots provide the performance advantage of using SQL bulk copy program (bcp) files to apply data to a specific Subscriber when applying the initial snapshot while using dynamic filters. For more information, see Dynamic Snapshots.

If you are using snapshot replication or transactional replication, you can create custom filters using transformable subscriptions, which will filter data based on individual Subscriber requirements. For more information, see Transforming Published Data.

Example

Сорри, это для Merge репликации.

2 Long
Самое смешное это то, что в приведенной Вами ссылке перевод статьи из BOL которую я Вам скопировал.
Да уж, погоже что для программера родной язык английский.

2 Александр Гладченко
Саша, ты не с того языка переводишь, надо с русского на английский и рассылку соответственно тоже.