majorbloodnock (1/15/2013)

---

GSquared (1/15/2013)

---

The problem with the part I added emphasis to, is that quite often a company needs to hire a DBA because they don't have anyone who knows anything...

you may need to qualify as I mentioned:

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

Do you have an asterisk in your code? I thought you were using the to mark the place you were writing about.

No asterisks needed in your code.

What's the error? If it's an ambiguous column, you need to specify from which table (The base one or INSERTED) you are specifying in the WHERE clause.

Sorry, wasn't reading well. The problem is that you have a malformed UPDATE statement.

CREATE TRIGGER [dbo].[trUpdateBulkPurchases]

ON [dbo].[tblTransactions]

AFTER UPDATE

AS

BEGIN

UPDATE tblBulkPurchases

set PO_Number = i.PO_Number

, Quantity...

No effect. The extensions have no bearing on the files' purpose or use. They are set to mdf/ndf/ldf only for convention.

I had a line on a job in Kabul. 35% "danger" pay. Not sure it's worth it, though that car looks nice.

That should work.

I assume when you attach, you are attaching the MDF/LDF and new NDF at the same time.

INSERTED.___ is fine.

I'd do this, but your way works:

UPDATE tblBulkPurchases

(tblBulkPurchases.PO_Number,

tblBulkPurchases.Quantity,

tblBulkPurchases.Transaction_Number,

tblBulkPurchases.Quantity_Remaining,

tblBulkPurchases.Unit_Price,

tblBulkPurchases.Software_Description,

tblBulkPurchases.PO_Date,

tblBulkPurchases.PurchaseCostCenter,

tblBulkPurchases.HeatTicketNumber,

tblBulkPurchases.PurchaseAccount,

tblBulkPurchases.Transaction_Date,

tblBulkPurchases.Transaction_Type,

tblBulkPurchases.SoftwareShortName)

SELECT

i.PO_Number,

i.Quantity,

i.Transaction_Number,

i.Quantity,

...

FROM INSERTED i

inner join tblBulkPurchases

on tblBulkPurchases.PO = i.po

WHERE Transaction_Type = 'Bulk Purchase'

What was the issue?

Good to know. I misread and was thinking this affected all Java installations. Let's hope that's true and there isn't a bit hole in the desktop installations.

Brandie Tarvin (1/11/2013)

---

Steve Jones - SSC Editor (1/11/2013)

---

Brandi, if you'd like to write on ACID for me, and then put it on your blog in a couple months, I'd be...

Anything is good. Real world stuff preferred, stories of what has worked for you. Doesn't have to be long. Looking for 2-5 pages, including screenshots and code. If it's longer,...

Not yet. Feel free to...

BTW, my article queue is getting a little low.

If any of you experts wants to write about something you're doing, I'd love it.

Brandi, if you'd like to write on ACID...