edward_hall76 (7/25/2012)

---

because they want it to update the PONumber table with the total when they fill out the po so they dont have to go into the PONumber and put...

edward_hall76 (7/25/2012)

---

what would you suggest then. I have a table called accounts as well would you use just the ID number for that account that coursponds with that dept and...

edward_hall76 (7/25/2012)

---

The reason for account number being the line item is because each office has there own budget and they are broken into computer supplies, office furnture, copy supplies etc...

edward_hall76 (7/25/2012)

---

Thats working ok except if there is already a amount in the subtotal in the PONumber table then it doesnt add them together.

I also get a error if trying...

Welsh Corgi (7/25/2012)

---

I did that and it worked fine.

I have a very basic...

All this work and effort to store a piece of data that should be retrieved real time using a view instead. 😛

I would comment on the table structure a little...

That assumption is entirely to generic to have any basis on fact. Why would a delete and an insert cause a recompile? There is nothing about having two statements in...

byecoliz (7/25/2012)

---

Hi Sean,

The tool is a modeling tool that gives DDL scripts as a result. so apparently it gives the DDL of one platform.

with T-SQL you can develop...

Maybe it...

byecoliz (7/25/2012)

---

I am working with a tool that generates DDL structures for tables,procedures,functions. Apparently these are generated based on one platform MS SQL 2005. My task is to change the...

ScottPletcher (7/25/2012)

---

I think the code below should at least be close to what you need (hopefully very close :-)):

ALTER TRIGGER UPDate_PONumber

ON dbo.PurchaseOrderDetail

AFTER INSERT, UPDATE, DELETE

AS

UPDATE PON

SET SubTotal = PO_Total.SubTotal

FROM dbo.PONumber...

I don't understand your response here....

This post is over 3 years old and the OP has not logged into SSC since they created the original post. Move along...nothing to see here.

Stefan Krzywicki (7/25/2012)

---

Lynn Pettis (7/25/2012)

---

Jeff Moden (7/25/2012)

---

Stefan Krzywicki (7/25/2012)

---

I didn't because I didn't want to pile on and distract from the OP's question. Enough that a few people are doing...

Holy cow. We don't need the entire database just the stuff relevant to your issue. In the future it would probably be in...