Comment by sreaching

dynamic sql is the ugly solution - using a loop to generate the sql string to be executed.