0

I want to select or split phone number from on column into multiple columns.

ID  PHONE
1   9701245929, 9701245929,9701245929
2   66663333, 66663333 ,66663333
3   9701245931, 9701245931
4   9701245932, 9701245932
5   26668888, 26668888
6   48228899, 48228899
7   88229933, 88229933

I want this OUTPUT

ID  PHONE       Phone2       Phone3     
1   9701245929  9701245929  9701245929
2   66663333    66663333    66663333
3   9701245931  9701245931  
4   9701245932  9701245932  
5   26668888    26668888
6   48228899    48228899     
7   88229933    88229933     

This is my view i want to edit it to give me that OutPut

SELECT        contactfk, STUFF
 ((SELECT        ', ' + CAST(Deviceinfo AS VARCHAR(20)) [text()]
  FROM            device
  WHERE        ContactFK = t .contactfk order by devicetypefk FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)'), 1, 2, ' ') DeviceList
 FROM            Device t
 GROUP BY contactfk

This is Device table sample data

devicePK   ContactFK   DevicetypeFK   DeviceInfo
  1             1          3          9701245929
  2             1          3          9701245929
  3             2          1          66663333
hashim
  • 135
  • 2
  • 4
  • 15

0 Answers0