Thanks in advance for any help with this!
I have a trigger that is successfully writing data to two different tables: tblTransactions & tblBulkPurchases... on the first run of an insert into tblTransactions I get a beautiful creation of the same in tblBulkPurchases... however on the second run of another insert into tblTransactions I get TWO identical records created in the tblBulkPurchases table... NOT GOOD! Is there a way of nesting or some other method to keep this from happening?
CREATE TRIGGER [dbo].[trPopulateBulkPurchases]
INSERT INTO tblBulkPurchases
WHERE Transaction_Type = 'Bulk Purchase'