SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Tags(
  Tags VARCHAR(100),
  UserID INT
);

CREATE TABLE Users(
  UserID INT,
  UserName VARCHAR(45)
 );
 
INSERT INTO Tags VALUES
('Analytics,Amazon Web Service,Active Directory', 1),
('BMC Remedy,Big Data,Ajax', 1),
('Azure,Assembly,Appache', 3),
('Azure,Assembly,Appache', 1),
('Azure,Assembly,Appache', 4),
('Azure,Assembly,Appache', 2),
('Apple Safari,Analytics,Ajax', 2);

INSERT INTO Users VALUES
(1, 'User1'),
(2, 'User2'),
(3, 'User3'),
(4, 'User4');
11 rows affected

CREATE PROCEDURE [dbo].[Dashboard_My_Skills_Projects]
(
  @UserID bigint,
  @UserSkills nvarchar(100)
)
AS
BEGIN
  SELECT U.UserID,
         U.UserName,
         TBL.Tags
  FROM
      (
        SELECT T1.*
        FROM Tags T1 CROSS JOIN 
                     (
                       SELECT Value 
                       FROM STRING_SPLIT(@UserSkills, ',')
                     ) TT
        WHERE T1.Tags LIKE '%' + Value + '%'
              AND
              T1.UserID = @UserID
  ) TBL INNER JOIN Users U ON TBL.UserID = U.UserID;
END
EXEC [dbo].[Dashboard_My_Skills_Projects] 1, 'Active Directory,Ajax,Azure';


UserID
UserName
Tags


1
User1
Analytics,Amazon Web Service,Active Directory

1
User1
BMC Remedy,Big Data,Ajax

1
User1
Azure,Assembly,Appache

UserID	UserName	Tags
1	User1	Analytics,Amazon Web Service,Active Directory
1	User1	BMC Remedy,Big Data,Ajax
1	User1	Azure,Assembly,Appache