i get questions and emails like 'can you look at proc/sql/ddl x and make it better' all the time. so, i figured i would publish my answers or refactors here for public scrutiny. i think i've seen several blogs that do something similar like this. learning from your questions... ? whatever. here is one...