March 2, 2020 at 2:17 pm
Hello,
Our reporting database truncates and loads latest data during each import and generates Unique Identifiers for Tasks and Project UIDs .
Example:
ProjectTable
TaskTable
We have a SharePoint list where incremental updates are done using TaskUID from Task Table and ProjectUID from Project Table.
If with every refresh, Project and Task tables regenerates unique identifiers , how the incremental updates are done in the SharePoint list ?
Thanks,
PSB
March 2, 2020 at 2:22 pm
If you are throwing away your only unique key every load, this sounds like an impossible task.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 2, 2020 at 2:41 pm
It seems impossible to me too. However, when I track back with TaskUID in both TaskTable and SharePoint list ,I get exactly the same record.
March 2, 2020 at 4:09 pm
It seems impossible to me too. However, when I track back with TaskUID in both TaskTable and SharePoint list ,I get exactly the same record.
Are you saying that this process is already happening, but you do not understand how?
I thought that you were asking how to do it.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 2, 2020 at 4:14 pm
I'm not familiar with sharepoint too much, but is it possible that the GUIDs are being generated by the sharepoint server? not by SQL
MVDBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply