Smells suspiciously like homework to me...

Here's a solution. It has a minor error in it. See if you can find it...

create table #fruit(Item varchar(10) not null, price dec(6,2) not null,...

This doesn't look like a situation where I would use replication. You may be better off setting up SSIS packages to transfer the data that you need.

It looks like you are attempting to add the constraint each time that the synchronisation runs. As it already exists, the script returns a failure result. You should check for...

Generally, when I see the error "The merge process was unable to create a new generation at the 'Subscriber'", this is a result of blocking. I would suggest that your...

Hi Neel,

You might have the same problem that I had with creating a new subscription. Have a look at this thread and see if it helps:

http://www.sqlservercentral.com/Forums/Topic1297654-291-1.aspx#bm1297905

Regards, Iain

Thanks. I've pulled out the headline failure reasosn, I don't think any of them are relevant for me (but am happy to be corrrected if you think this isn't the...

Hi Vyas,

Merge replication.

I'm not sure what you mean by "Is the Data replicating to distributor?". Could you perhaps explain?

Thanks, Iain

That looks very interesting Jamie, thanks.

Interesting.

My input is standardised using PAF for the addresses (I'm in the UK, this is the Postal Service's delivery address file, commonly used for address cleansing and standardising). I...

Hi Lowell,

Re below:

Lowell (7/16/2012)

---

but if soundex finds any number, or any non a-z,A-Z character, it returns something like "B000" (all zeros), so soundexing on addresses gets meaningless, since most addresses...

Hi GSquared,

The function is part of a matching routine. Inbound name and address records are matched to existing data. Unmatched rows are used to create new name and address...

As I thought. The case with unpivot option does the job much better:

-- unpivot

-- again, note that this will be built dynamically, but not shown here for clarity

select FirstGroupingId

,...

Hi Matt,

Thanks for the reply. My example is heavily simplified. The procedure is to be used with an application that allows a user to select and execute a set...

Incidentally, I'm eliminating any rows where BitwiseValue = 0.

I've also thought that I might be able to use a combination of case statements in the cte with an unpivot...

As suggested by Lynn, full error message follows:

Error messages:

The merge process failed because it detected a mismatch between the replication metadata of the two replicas, such that some changes could...