• Like this? (Still doesn't like near where the * is):

    USE [TrackIT]

    GO

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    CREATE TRIGGER [dbo].[trUpdateBulkPurchases]

    ON [dbo].[tblTransactions]

    AFTER UPDATE

    AS

    BEGIN

    UPDATE tblBulkPurchases

    SET

    PO_Number = i.PO_Number,

    Quantity = i.Quantity,

    Unit_Price = i.Unit_Price,

    Software_Description = i.Software_Description,

    PO_Date = i.PO_Date,

    PurchaseCostCenter = i.PurchaseCostCenter,

    HeatTicketNumber = i.HeatTicketNumber,

    PurchaseAccount = i.PurchaseAccount,

    Transaction_Date = i.Transaction_Date,

    SoftwareShortName = i.SoftwareShortName

    FROM INSERTED i

    inner join tblBulkPurchases

    on tblBulkPurchases.Transaction_Number = i.Transaction_Number

    WHERE Transaction_Type = 'Bulk Purchase' *

    GO