Viewing 15 posts - 331 through 345 (of 611 total)
This debug script is returning data as expected.
Thanks.
August 18, 2021 at 12:03 pm
You are correct on the PK.
Thanks.
August 18, 2021 at 12:04 am
anything else I can try to see why script not working?
THx
August 17, 2021 at 11:52 pm
With the same Line,subline?
August 17, 2021 at 6:05 pm
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...
August 17, 2021 at 4:04 pm
Answering Post by Jeff
"Two tables (one of existing data, one for new data) would be great."
August 17, 2021 at 2:39 pm
If I was going to try a re-write, do you have any suggestions?
THx.
August 17, 2021 at 1:29 pm
Was this the info you where looking for?
Thanks.
August 17, 2021 at 1:22 pm
I'm on board with your suggestions may need to help to get started with the process.
Thanks again...
August 16, 2021 at 5:34 pm
Thanks for the assessment ... any thoughts of how to detangle the RBAR.
August 16, 2021 at 3:13 pm
Any thoughts to how to improve this SP and the overall process?
Thanks.
August 16, 2021 at 10:40 am
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...
August 16, 2021 at 12:16 am
Sorry misunderstood .. will supply
Thanks again!!
August 15, 2021 at 12:58 pm
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....
August 15, 2021 at 2:11 am
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...
August 13, 2021 at 8:45 pm
Viewing 15 posts - 331 through 345 (of 611 total)