table column as argument to a function

Vote count:

0

I have a table like

create table Test_Table(LoginID nvarchar(max),Team nvarchar(max))

It has some data like

insert into Test_Table values ('kbcg','Administrator,Teacher,Student'), ('kbc','Admin,Teacher,Principal')

Now, I want data to be displayed like

LoginID | Team

kbcg | Administrator

kbcg | Teacher

kbcg | Student

kbc | Admin

and so on...

Need a function for this. Thanks in advance

asked 44 secs ago

vstandsforvinay

3