Showing posts with label specify. Show all posts
Showing posts with label specify. Show all posts

Wednesday, March 21, 2012

Multiple fields with the Additive Resolver?

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.

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

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