BackGround, i have an assembly line, that have many different function machine. Every machine have Key parameter, i store the key data to SQL database every second.
i actually want to use view to combine these two table, but i found the timestamp in the sql after second , there are still have 3 number as the following picture shows, so i am not able to use the sql view due to if i decrease the Process B timestamp by 30s it will perfect match with the process A timestamp.
currently i first store the data to a history database as a temp solution , then use scripting to read the data and use transction to SQL server finally, but it will make the a lot of cpu and memory and hard disk . is there any solution to solve this problem ?