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 Item's 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 recuiterMember since Jul 15, 2017 Kiran P.
from Delhi, India