从每小时获取实时Feed的表格中获取的数据不会被复制 - 查看一些想法 [英] Data Not Getting Copied for Last hour of the day from the table that is getting live feed every hour -Seeking some ideas
问题描述
大家好,
未复制数据 一天中的最后一小时来自实时供稿表(所以基本上数据只会更新到晚上11点 - 比如12月16日的数据只会被复制到17日上午11点(12月16日的数据被复制)
但是在18日早上,12月16日数据的最后一小时被复制了......)....有人可以帮忙提出想法......我在下面的存储过程中使用的代码块:
插入tabletobecopiedto
Hi
Arun ,
感谢您的发布。
我是s奥利,我无法理解你。根据我的理解,在原始脚本中,您使用Between AND
限制列'print_datetime',其值从今天凌晨4:00到明天凌晨4:00。和 
列'print_datetime'一次增加5个小时。在你限制的时候,你将能够复制甚至更少的20个小时。对吗?
为什么不采取将每小时减少到4小时的时间?它可能对你有帮助。如果我的理解不正确,请告诉我。或
请与我们分享您的表结构和一些样本数据以及您的预期结果 ? 这样我们就可以得到正确的方向并进行一些测试。
希望它可以帮助你。
< p style ="margin:0in; font-family:Calibri; font-size:11.0pt">最好的问候,
Rachel
Hi Everyone,
The data is not getting copied for the last hour of the day from Live feed table (So basically the data is getting updated only till 11PM- Say for Dec 16th data is getting copied only till 11PM on the 17th Morning(data for Dec 16th is getting copied) but on 18th morning the last hour of the data for Dec 16th is getting copied )....Can someone please help with ideas...The blocks of code that I am using from the stored procedure below:
Hi Arun,
Thank you for your posting .
I am sorry that I could not understand you clearly. According to my understanding, in your original script, you use Between AND to limit the column 'print_datetime' whose value is from 4:00am today to 4:00am tomorrow. And the column 'print_datetime' adds 5 hours at a time. At the time you're limiting, you'll be able to replicate or even less of the 20 hours you're doing. Right ?
Why don't you take to increase the number of hours reduced to 4 hours each time? It might help you. If I have incorrect understanding, please let me know. Or please share us your table structure and some sample data along with your expected result? So that we’ll get a right direction and make some test.
Hope it can help you.
Best Regards,
Rachel
这篇关于从每小时获取实时Feed的表格中获取的数据不会被复制 - 查看一些想法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!