SQL Server Performance Forum – Threads Archive

TRIGGER /AUDIT DATA

I have written triggers for several our tables that detects inserts,
deletes and changes. All of these changes are stored in a separate ‘Audit’ table.
I would like for the user to see all the items in the audit table in the
following format
ID SEQ CHANGETYPE FIELDNAME BEFORE AFTER
1 1 UPDATE Price 2.00 3.00
1 1 UPDATE Tax .50 .33 The problem is that in my Audit table the data is all stored on 1 row.
How can I get my trigger to store this change as 2 rows instead of 1? I would
like to see each individual change on separate rows. adv-thanks-ance

---

pls post some sample data and structure and trigger code( 1 eg.)

---

]]>