[Top] [All Lists]

Re: Multiple Subscriptions to the Same Field Type

Subject: Re: Multiple Subscriptions to the Same Field Type
From: "Diane Larsen [MSFT]"
Date: Wed, 30 Aug 2006 11:58:28 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Could you use a subquery in your WHERE clause to select the list of clients 
from another table?

Diane Larsen [MSFT]
SQL Server User Education

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at

"Isadore Schwartz" <[email protected]> wrote in 
message news:[email protected]
> Hi all,
> I am looking at an application configuration that requires me to manage 
> data
> for multiple clients as a single manager. Basically, I can have any number 
> of
> clients I am responsible for (say 20), and I need to be able to retrieve 
> any
> updates to data regarding those clients as it comes in. Thus, I could 
> receive
> an update for 1 client, 5 clients, or all 20 clients all at the same time.
> My question is this. In a subscription model through SQL-NS, what would be
> the most reasonable/efficient way to manage that many clients (assuming 
> that
> the search context would be - "give me all XXX for client YYY" in the
> subscription.
> I'm finding myself a little stuck functionally between having to define an
> individual susbscription for all 20 of the clients (for the single manager
> individual), or some sort of dynamic subscription that has all 20 clients 
> as
> individual fields in the subscription.
> What do any of you feel would be the best way to work with this? 

<Prev in Thread] Current Thread [Next in Thread>