Hi Frank,

The system is quite a few years old, and there are many different .exe's running against it.

Please note that the solution supports selects, inserts, updates and deletes.

So to simply just move the data, and not support the old format for a while, would be a Big Bang solution. Big Bang solutions cause a lot of noise in the organisation.

I hate noise, so we came up with this work-a-round.

Erland Sommarskog has another couple of solutions as well, here: http://www.sommarskog.se/dynamic_sql.html#Sales_yymm.

Best regards,

Henrik