Please see my SQL below. Everything is working fine, except I have to account for duplicates.
What I want to do: If there are duplicate Member Number fields, then sequentially use L25 for the first one, L26 for the second, so on and so forth.
Any ideas? Thanks.