Iwould like to have the delimited values in one of the columns in sql server table to be split into three rows.
ex: Project id Teams Impacted
as below having 3 * 8 blocks
Project id : Team1 Team2 team 3 Team4 team5 team6 team 7 team 8
5032401 BSS Engineering
we have to ingore null values as well.
Any help regarding this is greatly appreciated. Please suggest at the earliest.
Thanks and Regards,