I would recommend either (a) writing a script to create the sql for you or (b) de-pivot the rawdata_ic table into a long and skinny table along the lines of (labid, name, value). If you de-pivot the table, you can probably just do a simple query and wrap it in a pivot query.