Have you thought of changing the TrunkGroupID column to use identity? If you are just incrementing based on the existing columns max value then using the identity property of that column should solve the problem.