Is there a way to specify more than one field for the Additive Resolver
argument? I have multiple fields in a table that I would like to be summed
from multiple subscriber updates.
regrettably, no. You can only sum the contents of a single column together.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Thirsh" <Thirsh@.discussions.microsoft.com> wrote in message
news:4E7CF966-7E82-471B-B885-E6AF1D9856AA@.microsoft.com...
> Is there a way to specify more than one field for the Additive Resolver
> argument? I have multiple fields in a table that I would like to be
summed
> from multiple subscriber updates.
Showing posts with label specify. Show all posts
Showing posts with label specify. Show all posts
Wednesday, March 21, 2012
Multiple EMails per Subscriber
Is it possible to have a subscriber specify more than one e-mail address for a subscription? ie, they want a notification sent to two different email accounts.
Thanks,
Dan
Yes, it is possible, but a much easier solution to this problem would be to treat these 2 email addresses as if they belonged to 2 different subscribers.
In other words, it's much easier: 1 email address == 1 subscriber. Although those 2 distinct subscribers can be 1 and the same "physical" person.
It's all managed by SMI classes.
|||Sure. Each subscriber can have multiple subscriberdevices associated with them. Just mind the match rule.Joesql
Labels:
address,
database,
e-mail,
email,
emails,
microsoft,
multiple,
mysql,
notification,
oracle,
server,
specify,
sql,
subscriber,
subscription
Saturday, February 25, 2012
Multiple column full text search
Is there a way to specify which column weights more when doing full text
search..
For example, I have three column, filename, description and data. I did
full text index on all three column, but want to list the hits in filename
first, is there a way to do it sql 2005?
--Xin Chen
your might want to check out some of these postings for examples of how
to do this.
http://groups-beta.google.com/groups...ff&qt_s=Search
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
search..
For example, I have three column, filename, description and data. I did
full text index on all three column, but want to list the hits in filename
first, is there a way to do it sql 2005?
--Xin Chen
your might want to check out some of these postings for examples of how
to do this.
http://groups-beta.google.com/groups...ff&qt_s=Search
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
Subscribe to:
Posts (Atom)