Hi there,

sorry for my late answer but weekend was just what I needed 😉

@Jus: The hint with the table is something I already thought of. But let's get to the next question to see why it's not really an option.

@GSquared:

The purpose of the transformation is to have a look at a real-time logging of our application. In my eyes it would be the best if the logger itself would just write the entries into seperate columns but it can't - it just delivers this string. In order to have a real-time look at the log entries I do not want to fire an SP every time to be able to have a look at it. I would prefer a view or a TVF. But i cannnot call an SP inside a view and I cannot really modify data inside a TVF.

The numbers of columns could be delimited by me so I could at least have some kind of static code.

Any other suggestions on how to make this transformation on the fly?

Rgds.

Daniel