Hi, i need help with the next problem pls.
I want to add more rows with a determine service. for example i have de next table.
|id|name|serviceCatergory1 |serviceCatergory2 |
|1|harold|service1,service2 |service5,service6 |
|2|mario |service1 |service4,service5,service6|
i want to generate the following result table:
In a nutshell i want to unpivoting but i want also separate the services by comma and optimize the workflow why this will be procesing more than 50000 rows. Thanks