hi all,



Im running a snapshot replication on table.

first, i gonna copy the entire table with a regional filter other than date

second i'm going to replicate a days worth of data by using both the
regional filter and date filter (getdate) to capture a days wordth of data.

the publication are working fine.

my question is how am i going to accumulated the result of

the filtered snaphot replication in a single table in my db.



many thanks,

joey

--
thanks,

------------------------------------

Joey,
for the second publication you could see it as multiple publishers and
single subscriber:
http://www.replicationanswers.com/CentralSubscriberArticle.asp
However it might be that transactional replication would be more suitable?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)