My tsql trigger was only inserting one record when multiple updates had occurred. I changed my insert statement. I think my problem has to do with getting the next sequence number.
I am not sure if I can do select NEXT VALUE FOR AssetHistory_Seq,
Prior I got the values doing the following "VALUES (NEXT VALUE FOR AssetHistory_Seq,"
New statement. Is this valid?
BEGIN
INSERT INTO AssetHistory
(RecId,CreatedDateTime,CreatedBy,CreatedByID,LastModDateTime,LastModBy,LastModByID,AssetStatus,AssetTag,AssetUser,AssetUserID,EmployeeNumber,CellPagerNo,CountyTag,DisposalType,DistrictSection,eCapsUnit,FacilityCode,
FacilityName,Model,ModelNumber,PhoneNUmber,SerialNumber,TicketShipNumber,typeofupdate,configassetsid,BudgetName,CG4UpdatedBy,CG4UserName,TransactionType,LastUpdatedBy,LastUpdatedDateTime,LastUpdatedEmpid,
LocationFloor,CubicleRoom,LotPallet,EquipmentType,ModelDescription,Ownership,PONumber,Brand,Category,PurchasePrice,IMEI,MEID,ICCID,Manufacturer,PA2197)
select NEXT VALUE FOR AssetHistory_Seq,GETDATE(),CreatedBy,CreatedByID,GETDATE(),LastModBy,LastModByID,AssetStatus,AssetTag,AssetUser,AssetUserID,EmployeeNumber,CellPagerNo,CountyTag,DisposalType,DistrictSection,eCapsUnit,FacilityCode,FacilityName,
Model,ModelNumber,PhoneNUmber,SerialNumber,TicketShipNumber,'','',BudgetName,CG4UpdatedBy,CG4UserName,'UPDATED',LastUpdatedBy,LastUpdatedDateTime,LastUpdatedEmpid, LocationFloor,CubicleRoom,LotPallet,
EquipmentType,ModelDescription,Ownership,PONumber,Brand,Category,PurchasePrice,IMEI,MEID,ICCID,Manufacturer,PA2197 from inserted
END
thanks