microsoft.public.sqlserver.notificationsvcs
[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
http://www.microsoft.com/info/cpyright.htm.


"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>