By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dbo.email_list(UserID INT, Cliked_Linked varchar(2000));
INSERT INTO dbo.email_list(UserID,Cliked_Linked)
VALUES
(101012,'https:// amz/profile_center?qp= 8eb6cbf33cfaf2bf0f51'),
(052469,'htpps:// lago/center=age_gap=email_address=caipaingn4535=English_USA'),
(046894,'https://itune/fr/unsub_email&utm=packing_345=campaign_6458_linkname=ghostrider')
3 rows affected
Select UserID, Cliked_Linked, [1],[2],[3],[4],[5]
FROM
(
SELECT *, ROW_NUMBER() OVER(PARTITION BY USERID ORDER BY (SELECT NULL)) as rn
FROM dbo.email_list
CROSS APPLY
STRING_SPLIT(Cliked_Linked,'=')
) AS SourceT
PIVOT
(
MAX(value)
FOR rn IN ([1],[2],[3],[4],[5])
) as Pvt
| UserID | Cliked_Linked | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|---|
| 46894 | https://itune/fr/unsub_email&utm=packing_345=campaign_6458_linkname=ghostrider | https://itune/fr/unsub_email&utm | packing_345 | campaign_6458_linkname | ghostrider | null |
| 52469 | htpps:// lago/center=age_gap=email_address=caipaingn4535=English_USA | htpps:// lago/center | age_gap | email_address | caipaingn4535 | English_USA |
| 101012 | https:// amz/profile_center?qp= 8eb6cbf33cfaf2bf0f51 | https:// amz/profile_center?qp | 8eb6cbf33cfaf2bf0f51 | null | null | null |