begin tran
select a.assetid, TypeId = 143, OptionId = 0, StringValue = OwnershipName, IntegerValue = 0, DateValue = '1753-01-01 00:00:00.000', DecimalValue = 0, BooleanValue = 0
into customassetinfo
from assets a
join ownerships o on o.ownershipid = a.ownershipid
rollback tran