TR_GLFISCALYEAR_INS

Trigger Definition

				
          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