actually no, i posted this answer before seeing the second page on the forum where you already improved on your initial answer so you can just ignore my previous post.

for...

Slight improvement that works for decimal datatype:

CASE WHEN FLOOR(LOG10(REVERSE(ABS(Wert)+1)))+1 < 0 THEN 0 ELSE FLOOR(LOG10(REVERSE(ABS(Wert)+1)))+1 END

in your for loop, you could first generate a DDL statement (which creates a specific instance of a table), then execute this DDL, and afterwards import your data into this...