Dense_rank() row number?

Transact-SQL
3

Change your partition to LOCNCODE, ITEMNMBR with the order by as DestBin...

ROW_NUMBER() OVER(PARTITION BY LOCNCODE, ITEMNMBR ORDER BY DestBin)

This will generate the row number for each ITEMNMBR in each LOCNCODE by the DestBin...