SQL Skills desired

Currently
The value 117016555568142650000000 is stored in the Assets table in the column RFID. The entry has an Id
Desired additional by a trigger
The value found using the following select LEFT(117016555568142650000000,8) which is 11701655 to be stored in the ItemName column with TypeId = 1 and Description NULL
In the event, the ItemName is new update Assets table with the Id of the Items Id in the Assets table ItemId
The value found using the following select SUBSTRING(117016555568142650000000,9,6) which is 556814 is to be stored in the AssetAdditionalFieldDetails table DVF10 with the Id from the Assets table.
The value found using the following select SUBSTRING(117016555568142650000000,15,9) which is 2650000000 value stored in the AssetAdditionalFieldDetails table DVF11 with the Id from the Assets table.
About the recuiter
Member since Mar 14, 2020
Kumar Vimal
from al-Jahra, Kuwait

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions