I am using SQL Server Business Intelligence Development Studio 2005 and I have the following problem:
I have a dataset, consisting of different attributes. If one attribute value consists exactly of the String "string1/string2", the string must be splitted into "string1" and "string2". The splitted "string2" has to be added as a new row in the same table and schould keep the same values for the others attributes as "string1/string2".
How can I realize this issue?