[sreaching]

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

[fishcolorbrick]

This is what I use at work. :) It can make the code difficult to read and update later though.