You could update the table creation to get the datatype of temporary table directly from the source instead of the hard-coded types/sizes.  This would  be easily done with:

SELECT RowText, ColumnText, Value FROM...

Any of you nay sayers (not that you are wrong) have any better plans?  What do YOU suggest?