Thanks, the reason why i asked is because i don't see this new table in the original distribution database.

David, very interesting article, thank you.

Now i am wondering in which case do we need this code below?

Is this to keep snapshot files for each distribution database in the...

Nope, i jump to another issue and never had a chance to see where the problem is with this one. Still wondering why this is happening.

If you fon something please...

Yes, i tried to copy to the temp table and it's the same thing.

Btw, i just fixed this using

SELECT * FROM dbo.LinkShareTransactions_Temp

WHERE ABS(Amount) = 0.00

In this case it did...

Lynn, isn't this Amount decimal(10,2)? And what do you mean to show you in sql?

The column definition:

Column_nameType LengthPrecScaleNullable

Amount decimal910 2 yes

The only query on that table will be:

SELECT TOP (@rowcount) TMP.ID, TMP.OrderID

FROM dbo.OldRecords TMP

WHERE TMP.IsDeleted = 0

ORDER BY TMP.ID -- I am doing this in order to get...

Thank you for reply,

How about also to query sysjobhistory in MSDB to get output for the last time when the job run and insert into a file?

Something like:

select * from...

I tested and it worked perfectly fine, thanks again for you time!

Thank you very much all for your time spent on this!

I will get back as soon as i tested.

That changes the requirements. The next question follows, do you only want to delete complete groups? If an order for 2 items has different delivery dates do you...

Sorry, maybe i did not explained correctly or did not provide enough information.

If any record in the orderid group has unit 89 then completly skip this orderid from purging and...

I understand, but this is not what i was asking.

Thanks anyway for your help!

Thank you so much, one more question:

How can i completly eliminate from delete orderid = 2765 if it has UnitID = 89 and UnitID = 4 in this case for...

Thank you for reply,

Can you tell me please what do you mean by saying "you need to implement an export (recommended)"?

Do you mean sort of archive before purge?