Row filter vs join filter

Hi,
I am new to replication, I am confusing with row filter and join filter. If
I only use row filter, does the SQL server replication caused any data
integrity problem? e.g. simple relationship of such table tblCustomer,
tblOrder and tblOrderDetail?
Thank you.
HKM
a row filter normally means you filter by a column on a row with a value.
Ie in the authors table a row filter would look like this
where state='ca'
When you do a join filter you are joining on another table for your
filtering criteria.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"HKM" <HKM@.discussions.microsoft.com> wrote in message
news:F05A0678-7A6B-49F3-82D0-0C4EA60AB0D4@.microsoft.com...
> Hi,
> I am new to replication, I am confusing with row filter and join filter.
If
> I only use row filter, does the SQL server replication caused any data
> integrity problem? e.g. simple relationship of such table tblCustomer,
> tblOrder and tblOrderDetail?
> Thank you.
> HKM

Rounding Problem

Hi all,
Is there any function that truncates a decimal numeric without rounding, if
i use cast it rounds the figure but can i don't want that i.e i want it to
be as follows:
23.1238 turns to 23.123 and not 23.124 so it keeps only three decimals as
is
Please advise if there is any function or so
Thanks in advance
Suad
Try
Round(23.1238,3,1)