richard.noordam (11/21/2012)
I should also add that the column list changes and gets added to on a quarterly basis (as defined by the institution i work at)
Can these changes/additions be codified? You'll almost certainly end up having to modify the query otherwise.
the data set i show is only a small set of the column list.
Not too difficult to produce a select list containing all columns that you can then modify.
Cheers
Gaz