__Stephan,

I thought you were creating a physical table, this way there is less locations to modify.

create table DistributionList (
dtrkey int autoincrement not null
dtrtype varchar(50)
)

index on dtrkey

in your stored proc I would just reference this as follows.

select ytdsales, dtrtype
from ytdSalesTable inner join DistributionList
FROM ytdSalesTable INNER JOIN DistributionList ON ytdSalesTable.dtrkey = DistributionList.dtrKey

I would think a list would be better maintained from a permanent table.