the system runs on a 3rd party $200,000 enterprise e-commerce solution. There is no way for me to change it, and the client can't either. It's how the thing was built.
The tables are updated nightly via DTS, so i cannot touch the source table.
Perhaps a view would have been a better solution to use, but I don't need to limit permissions or anything on it, as the table in itself is pretty much meaningless...