Let me get this right, for the following records below for ROODVELT, What your saying is that the t1 has the forst record with a sequenceid of 1 and the t2...

PW,

I have clarified the rquirement from the BA and I have misunderstood something minor.

What you have done is exactly what I needed, now I just have to SELECT the NULL...

PW,

You have just discovered a flaw in the requirement. I will go back to the Business Analyst and inform him of this.

Thanks so much for understanding what I'm trying to...

For ROODVELDT it would be,

PETER CORNELIUS ROODVELDT      REHAB                2004-08-02 00:00:00.000                                2004-10-11 00:00:00.000                               

PETER CORNELIUS ROODVELDT      PENSION              2004-10-12 00:00:00.000                                2004-10-12 00:00:00.000                               

PETER CORNELIUS ROODVELDT      REHAB                2004-10-12 00:00:00.000                                NULL

The < 30...

PW,

Your solution works well for the <30 Days calculation but how do I treat it as 1 record when its < 30 Days? Could I please get you or anyone...

Is there anyone that can help with the dilemma I'm in? Surely there is someone or all of you that has understood what I need to do!

Check to see that the Subscriber has enough disk space to perform the snapshot.

Are you sure the T-SQL Debugger has been installed on the SQL Server?

At what time of the day will the Transactions be replicated? If it's after hours then 10mbps is plenty. If you will be doing replication during business hours then I...

I don't believe replication is the issue here however, I could be wrong!

Nevertheless, I would begin by perfroming some QA of the transactions that are in the Distribution Database compared...

What Replication model are you using?

Does this error occur when the initial Snapshot takes place or when the transactions are been replicated to the Subscriber?

Why not use Transactional Replication? You will still have to do the initial snapshot of the entire data and after that, only insert/update & delete transactions will replicate.

Thanks to all for your responses. They are all valid responses and they all work as far as I'm concerned. However, I have been doing some playing around and I...

I usually DECLARE a variable for example,

DECLARE @Identity INT

SET @Identity = SCOPE_IDENTITY()

SELECT @Identity

It's safer to use SCOPE_IDENTITY() as oppossed to @@Identity because SCOPE_IDENTITY runs within it's own scope and you...

The Payment_ID Column sounds like the Primary Key in tbl2. If you could Insert the Payment_ID into tbl1 based on tbl2 voucher_number, then updating tbl2 payment_date would be very simple.