Loop through dataset and add new column in same dataset that list how many time an item occured in each loop

[Transistor]

Show us your SQL query. Please see Wiki - how to post code on this forum.