So far it has worked great, but today someone wanted to get all the tax codes(there are lot's of dupes) from the table.
others already suggested group by approach. i would like to also suggest use of triggers to maintain tax codes list in separate table. it would greatly speedup every future query that will need this list.