Hi All,
can please help to write sql where i have convert comma separated values to rows. Below is the result am looking for :
declare @Tab table (ID int,CommaValues varchar(100),businesskey varchar(100))
insert into @Tab
values (1,'21520203517013900,21520210047026800,21520210047025100','XYZ'),
(2,'21520203517013900,21520210047026800,21520210047025100','XYZ'),
(3,'21520203517013900,21520210047026800,21520210047025100','XYZ'),
(4,'21520210047025101,21520210047027901','ABC'),
(5,'21520210047025101,21520210047027901','ABC')
select * from @Tab
Result as below
ID CommaValues businesskey SeperatedValues
1 21520203517013900,21520210047026800,21520210047025100 XYZ 21520203517013900
2 21520203517013900,21520210047026800,21520210047025100 XYZ 21520210047026800
3 21520203517013900,21520210047026800,21520210047025100 XYZ 21520210047025100
4 21520210047025101,21520210047027901 ABC 21520210047025101
5 21520210047025101,21520210047027901 ABC 21520210047027901
