MSSQL Trigger On Same Table
Posted on 2014-02-20
We have a table called "SY_WRKGRP", with a Primary Key on Field "WRKGRP_ID". Within that table, there's a field called "NXT_ITEM_NO".
When a value is UPDATED on the "NXT_ITEM_NO" field, for *any* of the WRKGRP_ID's, we want/need the value of "NXT_ITEM_NO" to be updated with that same value...for all other WRKGRP_ID's.
We were having a issue with the Syntax, as it seems we're (somehow?) looping the originating WRKGRP_ID onto itself. Please help...something's obviously amuck :-)