I have database follow
USE [Example]
GO
/****** Object: Table [dbo].[TB_Result] Script Date: 05/25/2016 08:30:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_Result](
[idCV] [int] IDENTITY(1,1) NOT NULL,
[SoCV] [nvarchar](50) NULL,
[ReadUser] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[TB_CongVan] Script Date: 05/25/2016 08:30:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_CongVan](
[idCV] [int] IDENTITY(1,1) NOT NULL,
[SoCV] [nvarchar](250) NULL,
[ReadUser] [nvarchar](max) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[cap2] Script Date: 05/25/2016 08:30:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cap2](
[id] [int] IDENTITY(1,1) NOT NULL,
[ten] [nvarchar](250) NULL,
[SoCV] [nvarchar](250) NULL
) ON [PRIMARY]
GO
in database have 3 table (cap2,TB_CongVan,TB_Result) i want use procedure or function combination of data between two tables cap2 and TB_CongVan is return result in TB_Result Help me?
And this is database table cap2.
INSERT INTO cap2(ten,SoCV) VALUES('user1|user2|user3','922/QD-HDQT-TDHO')
INSERT INTO cap2(ten,SoCV) VALUES('user1|user2','85-TB/BCSÐ-NHNN')
INSERT INTO cap2(ten,SoCV) VALUES('user1|user2|user3','286/CD-NHNO')
INSERT INTO cap2(ten,SoCV) VALUES('user1|user2|user3','388/QD/NHNO-TP-HCNS')
INSERT INTO cap2(ten,SoCV) VALUES('user4|user5','922/QD-HDQT-TDHO')
table TB_CongVan
INSERT INTO TB_CongVan(SoCV, ReadUser) VALUES('922/QD-HDQT-TDHO','a|b|c')
INSERT INTO TB_CongVan(SoCV, ReadUser) VALUES('85-TB/BCSÐ-NHNN','a|b')
INSERT INTO TB_CongVan(SoCV, ReadUser) VALUES('286/CD-NHNO','a|b|c|d')
INSERT INTO TB_CongVan(SoCV, ReadUser) VALUES('388/QD/NHNO-TP-HCNS','a|b|c')
return result table TB_Result
INSERT INTO TB_Result(SoCV, ReadUser) VALUES('922/QD-HDQT-TDHO','a|b|c|user1|user2|user3|user4|user5')
INSERT INTO TB_Result(SoCV, ReadUser) VALUES('85-TB/BCSÐ-NHNN','a|b|user1|user2')
INSERT INTO TB_Result(SoCV, ReadUser) VALUES('286/CD-NHNO','a|b|c|d|user1|user2|user3')
INSERT INTO TB_Result(SoCV, ReadUser) VALUES('388/QD/NHNO-TP-HCNS','a|b|c|user1|user2|user3')