Generate Unique Counter in a Parallel Transformer Without Surrogate Key generator
February 25, 2018
Old but handy trick.
@INROWNUM * @NUMPARTITIONS + @PARTITIONNUM
Update –
To start the series from 1, use
(@INROWNUM – 1) * @NUMPARTITIONS + @PARTITIONNUM + 1
Posted in Technology