MysteryJimbo (2/24/2012)

---

Have you tried this in a push replication setup?

I did find this on technet as well which suggests its security related in someway but the wording to me suggests...

SELECT @FromDate = ISNULL(@FromDate, SELECT MIN(DateCreated) FROM #t))

, @ThroughDate= ISNULL(@ThroughDate, SELECT MAX(DateCreated) FROM #t))

SELECT *

FROM#t

WHERE DateCreated BETWEEN @FromDate AND @ThroughDate

;with baseData as (

select modifydate, fieldname, fieldvalue, modifyuser, seq = ROW_NUMBER() over (partition by fieldname order by modifydate)

from ChangeHistory

)

select T1.modifydate, T1.fieldname, OldValue = T1.fieldvalue, newValue = isnull(T2.fieldvalue, '------'), T1.modifyuser

from...

Thanks Satya

I will try this.

Thanks Bob

I agree that the actual number is irrelevant. However, the customer wants sequential numbers, so that's what he gets.

Regards

Des Norton

Jack, Christopher

Concurrency is an issue. The transaction is controlled by the application, and the audit table will be hit quite hard.

We will chnage the Identity field to a regular...

Thanks Christopher

That does the trick.

Mihael, Philip

Thanks of the input.

I have tried using the SPs to add the subscription manually, but still no luck.

I have carte blanche on the publisher/distributor (my server), but need lots...