I have a procedure every minute which makes a join, I want to check each time if a value has changed and store a new value.
Table 1 - Devices
lat - lon - road - time
Table 2 - Roads
Shape - name
So basically i have the location of the devices and the shapes of a road, everyminute I do a join to check in which road is the device and store that road name into road on devices table, thats working but my new requirements is to check if this name of the road is the same as the previous join, if its not we store a new time. So this is to check what has been the time in that specific road
35 pekerja bebas membida secara purata $9/jam untuk pekerjaan ini
Hello, i have good experience with Microsoft SQL Server, SQL queries and Stored Procedures. Let's discuss your requirement in more detail and then i can start immediately. Thanks.
Certificate in SQL queries and more than 7 years of experience in Microsoft BI tools, self-service services and analytical models. Carrying out complete processes of data integration, creation of data warehouses