With the same Line,subline?

The 4 hour check was put in so if the process that is writing to the Import table has issues or is down, when restarted this

data could be outside of...

Answering Post by Jeff

"Two tables (one of existing data, one for new data) would be great."

If I was going to try a re-write, do you have any suggestions?

THx.

Was this the info you where looking for?

Thanks.

I'm on board with your suggestions may need to help to get started with the process.

Thanks again...

Thanks for the assessment ... any thoughts of how to detangle the RBAR.

Any thoughts to how to improve this SP and the overall process?

Thanks.

Here is the data for the #daily_invoices and a staging table where data imports will happen. Compare the STaging to Live and report

inserts-updates, and create a delta table of the...

Sorry misunderstood  .. will supply

Thanks again!!

When the process starts I will be extracting all Invoices for the month. If I started today my first load file would be 8-1 thru 8-13

as it gets prior day....

small sample of data, and the output desired.

Row 2 is written as a delta to a new table since acctgrp and channel changed.

Output:

Old:display yesterday's record

New:display today's record

Just so I have...

I have it heavily logged so I can debug or trace data coming from the calling process.

This is called for each of the alarms\alerts in prior SP.

Thanks for looking at...

My table as a PK(unique) of:

[InvoiceNbr] ASC,

[Line] ASC,

[SubLine] ASC,

[InvoiceDate] ASC,

[ShipDate] ASC

The process that creates the file to load to SQL does a FULL refresh of the data, meaning it does...

any examples of a compare script and output diff's?

Thanks.