which 250UL INSERT incremental number
5190-4073 | Aijiren
Part Number:5190-4073. 250ul insert, polypropylene w/grad 100pk. Add to Favorites. List Price: $37.60 /100 Pack.
Add an incremental number in a field in INSERT INTO SELECT
If you want to start with the maximum already in the table then do: INSERT INTO PM_Ingrediants_Arrangements_Temp (AdminID, ArrangementID, IngrediantID, Sequence) SELECT @AdminID, @ArrangementID, PM_Ingrediants.ID, coalesce (const.maxs, 0) + row_number () over (order by (select NULL)) FROM PM_Ingrediant...
MORE