Need an sql script.The concerned table maintains an Inventory movement for the composite key field (itemID, BSNo). The requirement is to identify gaps in sql server table and generate a new table with the “Next Sequential ID” for each Item and BSNo combination… (Budget: $30-$250 USD, Jobs: Software Architecture, SQL)
