Parameterized and static filter on the same article

Hi,
MS SQL Server Standart 2005 RTM, MS Windows Server 2003 SP1. Is it possible
to combine, mix, or have a static and a parameterized filter on the same
article simultaneously?
Thanks, Oskar.
Forgot to mention that I want to use a static filter only within the
boundaries of a dynamic partition, that is, I want to filter out rows of
dynamic filter by means of a static filter. Say, I have a table SALES and
columns LOCATION and STATUS in it. I want non-overlapping partitions by
LOCATION and in each LOCATION only rows which have STATUS = 'Placed'. Can I
do that?
"Oskar" wrote:

> Hi,
> MS SQL Server Standart 2005 RTM, MS Windows Server 2003 SP1. Is it possible
> to combine, mix, or have a static and a parameterized filter on the same
> article simultaneously?
> Thanks, Oskar.
|||Hi Oskar,
Once you have your partition by LOCATION, you should be able to use
AND in the filter's WHERE clause to limit your rows even further.
Something like
SELECT publishedColumns
FROM articleTable
WHERE LOCATION IN (SELECT LOCATION
FROM locationTable
WHERE username = suser_sname())
AND STATUS = 'Placed'
Thanks,
Ken
On Feb 16, 12:48 pm, Oskar <O...@.discussions.microsoft.com> wrote:[vbcol=seagreen]
> Forgot to mention that I want to use a static filter only within the
> boundaries of a dynamic partition, that is, I want to filter out rows of
> dynamic filter by means of a static filter. Say, I have a table SALES and
> columns LOCATION and STATUS in it. I want non-overlapping partitions by
> LOCATION and in each LOCATION only rows which have STATUS = 'Placed'. Can I
> do that?
> "Oskar" wrote:
|||Ken,
Problem with that is that rows with STATUS = 'Pending' won't be allowed in
SALES at subscribers by merge replication, because it "suspects" that
partitions will overlap.
"KenJ" wrote:

> Hi Oskar,
> Once you have your partition by LOCATION, you should be able to use
> AND in the filter's WHERE clause to limit your rows even further.
> Something like
> SELECT publishedColumns
> FROM articleTable
> WHERE LOCATION IN (SELECT LOCATION
> FROM locationTable
> WHERE username = suser_sname())
> AND STATUS = 'Placed'
>
> Thanks,
> Ken
> On Feb 16, 12:48 pm, Oskar <O...@.discussions.microsoft.com> wrote:
>
>