Hi All.
I have data like below. (Sample)
CREATE TABLE [dbo].[Test0001](
[Guid] [nvarchar](50) NOT NULL,
[Level] [tinyint] NOT NULL,
[Parent_ID] [nvarchar](50) NULL,
[Child_ID] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 0, NULL, N'Parent_001')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 1, N'Parent_001', N'Child_001')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 1, N'Parent_001', N'Child_002')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_001', N'Child_002.1')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_001', N'Child_002.2')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_002', N'Child_002.3')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_002', N'Child_002.4')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_002', N'Child_002.5')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.1', N'Child_003.1')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.1', N'Child_003.2')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.3', N'Child_003.3')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.4', N'Child_003.4')
GO
INSERT [dbo].[Test0001] ([Guid], [Level], [Parent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.5', N'Child_003.5')
GO
I want the above records in below format. after parent the next child should come.
CREATE TABLE [dbo].[Test0002](
[Guid] [nvarchar](50) NOT NULL,
[Level] [tinyint] NOT NULL,
[Patent_ID] [nvarchar](50) NOT NULL,
[Child_ID] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 1, N'Parent_001', N'Child_001')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_001', N'Child_002.1')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.1', N'Child_003.1')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.1', N'Child_003.2')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_001', N'Child_002.2')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_002', N'Child_002.3')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.3', N'Child_003.3')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.3', N'Child_003.3')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_002', N'Child_002.4')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.4', N'Child_003.4')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 2, N'Child_002', N'Child_002.5')
GO
INSERT [dbo].[Test0002] ([Guid], [Level], [Patent_ID], [Child_ID]) VALUES (N'268FF0B4-7328-40C2-94F1-8F963D54D00A', 3, N'Child_002.5', N'Child_003.5')
GO
Please help me this.
What I have tried:
With CTE I found some examples in online but I couldn't use CTE in my code.