Hi MMartin1,

The first post is not by me.

I will explain it in detail. I have this t_adr_rpt_doc table source table which has no primary key but a index on rpt_id....

Hi Orlando,

rpt_id doesnt contain any NULL value.

select count(*) from [dbo].[t_adr_rpt_doc] where rpt_id is not null;

count:396004

select count(*) from [dbo].[t_adr_rpt_doc] where rpt_id is null;

count:0

select count(distinct rpt_id) from [dbo].[t_adr_rpt_doc];

count:396004

Thanks

Hi,

Here is the DDL of the table.

CREATE TABLE [dbo].[t_adr_rpt_doc](

[rpt_id] [bigint] NULL,

[rpt_doc_tx] [varbinary](max) NULL,

[lst_upd_ts] [datetime] NOT NULL,

[lst_upd_user_id] [char](8) NOT NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

Index:

CREATE CLUSTERED INDEX [idx_adr_rpt_doc_01] ON [dbo].[t_adr_rpt_doc]

(

[rpt_id] ASC

)WITH (PAD_INDEX...

Thanks Orlando.

I understand that we need to add that BIT column to the source table. But I shouldnt change the structure of the source table. How can I do that.

And...

Sorry if I am asking silly doubts. What is IsTransferred here. Is it a property for every table. I am just a beginner. I dont get it.

I do understand it. But my doubt is if we set the IsTransferred property to 1 for the transferred rows, those rows will not be selected while fetching the next...

Koen,

I am sorry. I couldnt understand.

Can you please explain.

Hi Koen,

Is there any way of doing it without deleting the rows from the source table.

How to mark the rows as transferred instead of deleting it. I should not delete...