Thanks this worked great!

INSERT INTO [SoftIT].[dbo].[tblBUlookup]

(

[CostCenter],

[BusinessUnit]

)

SELECT

[CostCenter],

[BusinessUnit]

FROM...

Both yours and the post above yours were most helpful and looks like I'm on the right track finally... thanks!

Yes using "opening a CSV file in Excel, copying the contents, then pasting directly into a table via "Edit top 200 rows" in SSMS"... which works well for about 19,500...

After I pasted the errors began. I looked back at my data in my .csv and found no reason that all the records should not commit. Not sure how to...

Actually I'm using SQL Server Express so I'm pasting them from copying the data from a .csv file. Is there another way with SQL Server Express?

The reason I was asking was I was loading about 20,000 records and kept getting an error popup "String or binary data would be truncated".... looked through the data and...

Thank you... all is working!

Thank you... all is working!

Correct... the asterick was just to show in the post where the problem was. There's no asterick in the code.

WHERE Transaction_Type = 'Bulk Purchase'

Msg 102, Level 15, State 1, Procedure trUpdateBulkPurchases, Line 21

Incorrect syntax near 'Bulk Purchase'.

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...

Kinda like your way... but the compiler doesn't like where I've placed astericks:

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

*(tblBulkPurchases.PO_Number,

tblBulkPurchases.Quantity,

tblBulkPurchases.Transaction_Number,

tblBulkPurchases.Quantity_Remaining,

tblBulkPurchases.Unit_Price,

tblBulkPurchases.Software_Description,

tblBulkPurchases.PO_Date,

...

Correct... do need to associate by PO = PO... thanks.... is the word INSERTED.____ appropriate to use?

I have an ASP.net application, no encryption, just a Record#, UserName, PW, and SecurityLevel, really simple file, 30 users tops.

Custom table I'm designing.