TR_GLFISCALYEAR_INS (Trigger)

                
          CREATE trigger [dbo].[TR_GLFISCALYEAR_INS] on [dbo].[GLFISCALYEAR]
          for insert
          as
            set nocount on

            update GLFISCALYEAR
            set PREVIOUSYEARID = (SELECT GLFISCALYEAR.ID 
                                  FROM GLFISCALYEAR
                                  WHERE GLFISCALYEAR.YEARSEQUENCE = (t2.YEARSEQUENCE - 1)),
                -- Grab the insert's CHANGEBYID and DATECHANGE to avoid extra work

                -- in the table's update trigger.

                CHANGEDBYID = t2.CHANGEDBYID,
                DATECHANGED = t2.DATECHANGED
                                  
            from GLFISCALYEAR t1
            inner join inserted t2 on t1.ID = t2.ID