Need to create a counter trigger

[Maxxamillian]

Need to create a trigger that automatically increases the value in the flx_objid column by 1 when an insert occurs. Not quite sure how I would go about doing this as this will be my first trigger. Any help would be appreciated.

 

[Maxxamillian]

This is what I have so far.... I have tried several different codes and none will fire.



CREATE TRIGGER FLXTrans_ObjidCount
ON FLX_Transaction
FOR INSERT

AS

DECLARE @NewCount INT, @MaxCount int


IF (SELECT Count(*) FROM inserted WHERE flx_objid IS NULL) > 0
BEGIN
SELECT @MaxCount= (SELECT Max(flx_objid) FROM FLX_Transaction)

SELECT @NewCount = @MaxCount + 1

INSERT INTO FLX_Transaction
SELECT i.*
FROM Insereted i
WHERE flx_objid IS NULL


UPDATE FLX_Transaction SET flx_objid = @NewCount WHERE flx_objid IS NULL
END
GO