briancampbellmcad (10/16/2012)

---

Any ideas?... I have a trigger (not working obviously) set up that decrements from my [tblBulkPurchases].[Quantity_Remaining] field an amount by one with each entry into my [tblTransactions] when my entry type is 'From Bulk Assignment':

USE [TrackIT]
GO
CREATE TRIGGER [dbo].[trDecrementBulkPurchases]
ON [dbo].[tblTransactions]
AFTER INSERT
AS
BEGIN
UPDATE [TrackIT].[dbo].[tblBulkPurchases]

SET [Quantity_Remaining] = [Quantity_Remaining] - 1

WHERE Transaction_Type = 'From Bulk Assignment'
END
GO

UPDATE [TrackIT].[dbo].[tblBulkPurchases]

   SET [Quantity_Remaining] = [Quantity_Remaining] - 1

WHERE Transaction_Type = 'From Bulk Assignment'
and YourKeyField in (select YourKeyField from Inserted)

briancampbellmcad (10/16/2012)

---

Let me make sure I understand this line by line and have each right so far...

First, isn't the line "WHERE Transaction_Type = 'From Bulk Assignment'"
correctly referenceing the INSERTED with no additional qualifiers for this line needed?

briancampbellmcad (10/17/2012)

---

That last part makes sense...
I'm thinking an "IF" condition on transaction_type may be a step in the right direction (?):

USE [TrackIT]
GO
CREATE TRIGGER [dbo].[trDecrementBulkPurchases]
ON [dbo].[tblTransactions]
AFTER INSERT
AS
BEGIN

IF Transaction_Type = 'From Bulk Assignment'

UPDATE [TrackIT].[dbo].[tblBulkPurchases]
SET [Quantity_Remaining] = [Quantity_Remaining] - 1
WHERE PO_Number IN (SELECT [PO_Number] FROM [tblTransactions])

END IF

END
GO

-- there are some syntax issues of course