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

Server and DB specs? How's that working out? Want to write about it...

Brandie Tarvin (1/11/2013)

---

Lynn Pettis (1/10/2013)

---

Just got an email from a newbie here on the forums. He had his account deleted. He felt he was on the wrong forums...

David.Poole (1/11/2013)

---

Given that audit logs are not read frequently I feel we need to consider where the appropriate place is to store audit logs.

Clearly they need to be secure so...

AD isn't that big a deal, and most of these technologies will require some parts of it since you are trying to move information around. For a relatively low volume...

Grant Fritchey (1/11/2013)

---

After seeing Lynn's comments about SQL Server Performance, I read through... well, attempted to read through a couple of articles over there. I have to ask, who is...

Lynn Pettis (1/10/2013)

---

Just got an email from a newbie here on the forums. He had his account deleted. He felt he was on the wrong forums thanks to...

You should examine why you might be having a slow insert.

- Is the log growing now? If so, since you have to zero out the file before data can...

I'd have to dig in, but I believe that the FTS index is a system table, and you can find out the number of times a word appears in a...