SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[ExamObjects](
	[ExamObjID] [uniqueidentifier] NOT NULL,
	[ObjNum] [varchar](10) NULL,
	[ObjName] [varchar](100) NULL,
	[IndexType] [char](1) NULL,
	[PersCount] [char](1) NULL,
	[ValidateState] [char](1) NULL,
PRIMARY KEY CLUSTERED 
(
	[ExamObjID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[DNAValues]    Script Date: 01.04.2023 9:02:44 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[DNAValues](
	[DNAValID] [uniqueidentifier] NOT NULL,
	[ExamObjID] [uniqueidentifier] NULL,
	[Locus] [varchar](15) NOT NULL,
	[ValOrder] [tinyint] NOT NULL,
	[Value] [varchar](5) NULL,
PRIMARY KEY CLUSTERED 
(
	[DNAValID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE VIEW [dbo].[vwValues]
AS
SELECT        dbo.ExamObjects.ExamObjID, dbo.DNAValues.Locus, dbo.DNAValues.ValOrder, dbo.DNAValues.Value, dbo.ExamObjects.IndexType, dbo.ExamObjects.PersCount
FROM            dbo.ExamObjects INNER JOIN
                         dbo.DNAValues ON dbo.ExamObjects.ExamObjID = dbo.DNAValues.ExamObjID
WHERE        (dbo.ExamObjects.ValidateState = 'A')
/****** Object:  Table [dbo].[Alleles]    Script Date: 01.04.2023 9:02:44 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Alleles](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Value] [varchar](5) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[Locuses]    Script Date: 01.04.2023 9:02:44 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Locuses](
	[Locus] [varchar](15) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Locus] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

/****** Object:  Table [dbo].[SearchResults]    Script Date: 01.04.2023 9:02:44 ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SearchResults](
	[SearchResID] [uniqueidentifier] NOT NULL,
	[ExamObjID] [uniqueidentifier] NULL,
	[MatchObjID] [uniqueidentifier] NULL,
	[MisMatchCount] [tinyint] NULL,
PRIMARY KEY CLUSTERED 
(
	[SearchResID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[Alleles] ON 

INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (1, N'11')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (2, N'11.1')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (3, N'11.2')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (4, N'12.2')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (5, N'13')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (6, N'13.1')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (7, N'14')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (8, N'15')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (9, N'15.5')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (10, N'16')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (11, N'17')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (12, N'17.1')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (13, N'18')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (14, N'19')
INSERT [dbo].[Alleles] ([ID], [Value]) VALUES (15, N'19,3')
SET IDENTITY_INSERT [dbo].[Alleles] OFF

INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'bdada74c-bf43-44bf-9cc7-025c6af7ed87', N'62da5c53-e70a-473a-923b-388232b79aff', N'L8cascade', 1, N'17')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c83d04b9-2123-4476-8fae-0527b595677f', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L5RTdev', 2, N'10')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'fd3d60e5-2509-421b-8d74-06a90318de63', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L8cascade', 2, N'17')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'ce3c37ed-ca14-4583-a8c8-07c91c3e08b9', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L4R4', 1, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a0c0f751-5147-48d1-8694-07f27f55dcf8', N'70a15724-a515-463c-915f-94260ad2cc64', N'L8cascade', 2, N'17')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'f4cd4e0a-85bc-42c0-8d52-084ce5db7480', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L1T1234', 2, N'10')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'88ebe9d9-d2f0-4291-947c-0b1b3000d619', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L5RTdev', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c3c581a6-d352-4451-99db-0bd8cdfcf27e', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L5RTdev', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a7c0673c-871a-431a-92a2-0c0814d8912a', N'59de806a-a675-4120-b1e4-68f41804defd', N'L8cascade', 1, N'17')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'85af96ee-fff9-4ee1-9b7a-0e597f95ec54', N'ba365217-bbce-4160-b891-82408e1ad498', N'L1T1234', 1, N'17')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b14d4636-a26e-49d5-a61c-0ee07aa15493', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L2T54332', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'72f872f7-d3a4-4425-bfde-0fd623d2a759', N'59de806a-a675-4120-b1e4-68f41804defd', N'L1T1234', 2, N'15.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a48c29f8-7917-4c4d-b889-108364576fe2', N'62da5c53-e70a-473a-923b-388232b79aff', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'470c3ad7-dfa2-499a-b6b2-1117a1887fb1', N'ba365217-bbce-4160-b891-82408e1ad498', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'8174375a-f26e-4aef-bbc2-11d06f0365a7', N'ba365217-bbce-4160-b891-82408e1ad498', N'L2T54332', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a8289eaf-01ce-48a4-ace6-12fef1208306', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3d291cfb-0f3d-40b7-be67-16f762dc0500', N'62da5c53-e70a-473a-923b-388232b79aff', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'f0ba8270-bf9b-4f0d-b37e-1870044da957', N'ba365217-bbce-4160-b891-82408e1ad498', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c267e2ad-02d9-40ae-8368-1ccef9c34bdb', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'91a161d8-5798-48d2-9d51-1e8a60745a88', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'82ef1e80-2cf1-47b5-9e9e-201cc4223ae9', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'705b5773-03fd-406b-b0c5-213803d24ba8', N'59de806a-a675-4120-b1e4-68f41804defd', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'500cef0d-5c9d-4e01-a503-2490c3ce6211', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'8fd72344-e02a-4beb-b5cb-26d2e3617bfd', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'9acb18eb-01eb-455e-b497-27c8dee6ee48', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'9232fbc8-ccb4-491d-a6bb-284c5d7101c5', N'62da5c53-e70a-473a-923b-388232b79aff', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'27cde6fe-61ad-4672-a471-2a87678a58e9', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'149856b3-6701-4ef0-b26d-2acedaec61cd', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'd2017823-fb31-4f60-a747-306746c86cb1', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'8aae5a5c-d142-4fc7-a527-319625df292c', N'ba365217-bbce-4160-b891-82408e1ad498', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'6e75e38b-7eaf-46b7-8456-328fb898303e', N'70a15724-a515-463c-915f-94260ad2cc64', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'969fd3f9-b7c2-473a-9ca1-35521ffcbfd5', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'878dc25b-c0cb-41cc-847d-37f8304f1091', N'ba365217-bbce-4160-b891-82408e1ad498', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'6d2d2a87-314f-4b69-ae47-38899e3c9b22', N'59de806a-a675-4120-b1e4-68f41804defd', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c6843f1d-7603-48ab-b758-38c61daebd56', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'96f599fa-20c8-402e-b563-39035cccf7de', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'e36e1dc6-e70a-494c-8c02-3a1103f3e4d4', N'62da5c53-e70a-473a-923b-388232b79aff', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'dfaf819f-4eb4-4d63-b1ef-3a84081accb5', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'4d3fb239-3c12-4e95-b2be-3efbef5925ec', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'727b1ad7-c9d2-4aeb-9b29-452d739a4ee9', N'59de806a-a675-4120-b1e4-68f41804defd', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'4039b578-74c8-4a4c-9b7d-4875c7a8e586', N'59de806a-a675-4120-b1e4-68f41804defd', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'ce3c290e-743f-418f-9e62-4ab5016c9b14', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'78e28c22-e9fc-4235-9038-4b7e6abb62f0', N'62da5c53-e70a-473a-923b-388232b79aff', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'7af685b3-596a-44ea-8a30-4c8b4bd47f32', N'ba365217-bbce-4160-b891-82408e1ad498', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b4f27d8e-b325-4df2-8897-4d4c89049e99', N'62da5c53-e70a-473a-923b-388232b79aff', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'2001ec8b-5261-408d-8b8a-4ed4feeb77aa', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'ab42d994-690c-41a4-af94-4f2b30d6adbf', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'6e17bb57-a249-4454-8d67-52d4ac64ed74', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3a072aeb-210f-493e-b3a6-5400bbdea826', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'214f9b6d-7aa2-4509-b653-541db7a870a0', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'14572528-b098-4a8c-a6cb-556e4223fae4', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'1260060c-ba9f-4b69-804e-5acb56d2a594', N'59de806a-a675-4120-b1e4-68f41804defd', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3933c6a9-e3e7-482a-9722-5b9ee0bbaaed', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'743234b9-59a7-4c42-a37d-5e12264035b0', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'16352b81-3d45-4e0e-b4d3-5f5c7ccd5468', N'70a15724-a515-463c-915f-94260ad2cc64', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b0e96ee1-1bd6-41f0-8afc-60ced03bf5ac', N'ba365217-bbce-4160-b891-82408e1ad498', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'6e59b32e-a404-4207-8615-63923bc5668d', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'5b09f84e-1b69-4d58-aef2-65b9b36b7ac8', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'1d63b89e-7cb8-4ede-a0e0-66e1c145ba20', N'ba365217-bbce-4160-b891-82408e1ad498', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'cc999363-3c33-4cd5-a9e5-687289bbe204', N'62da5c53-e70a-473a-923b-388232b79aff', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'102b5642-5282-4c94-9c34-687fbcc59892', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'48404b04-eb97-4c10-b17c-6be4945f441d', N'59de806a-a675-4120-b1e4-68f41804defd', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'f388d50d-7216-4e32-950d-6d933329d11a', N'62da5c53-e70a-473a-923b-388232b79aff', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'80c871fa-2b1b-474a-a820-7463fc3460cc', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'd5627842-950c-4c3e-85b7-788eb10c0639', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c42be653-cd4c-4615-a64b-794d520414b7', N'62da5c53-e70a-473a-923b-388232b79aff', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'91d5e2f2-def8-4e0d-994a-79e570aad87d', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'684d5c8c-9492-44da-9c0f-7ad4731fb294', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a411dbf5-e5bd-4a12-abb1-7e64cc4be1f3', N'70a15724-a515-463c-915f-94260ad2cc64', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'836cb934-c60d-41c8-b75c-80ae7c5c3f5a', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3702ae56-abb1-4450-8fdb-8498afa31c75', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'509a97f2-6ebe-48dc-a515-859d7e92b978', N'70a15724-a515-463c-915f-94260ad2cc64', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'771d20a3-1ec0-4049-8aae-89ba0fdb655a', N'62da5c53-e70a-473a-923b-388232b79aff', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'7e375669-3824-4409-8f1f-8b84bfc470c5', N'70a15724-a515-463c-915f-94260ad2cc64', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'583ec2a0-f3b8-45f6-b66e-90d80163627c', N'59de806a-a675-4120-b1e4-68f41804defd', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3d9374dc-65de-4851-8149-92186d5c4907', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'756cab1d-ebb9-45c8-a866-925e0a6999be', N'ba365217-bbce-4160-b891-82408e1ad498', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'ef3ae4b2-c943-4a63-998c-93bcc3a9d3ab', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'e81384c7-8c9e-4721-8904-9604cd1db1a2', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'052b905a-6dfd-4f18-aaa2-96c69098c58e', N'ba365217-bbce-4160-b891-82408e1ad498', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'f6e94540-e571-4537-b581-976cffe6a7ec', N'ba365217-bbce-4160-b891-82408e1ad498', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'82a7e8c3-4d0b-4dd4-a101-9a35d7ee9a35', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'61109dd0-4451-4f16-a2e4-9bb366ac6d44', N'70a15724-a515-463c-915f-94260ad2cc64', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'0f6df8ef-73da-41cb-87f6-9ce963f0be75', N'70a15724-a515-463c-915f-94260ad2cc64', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'fc80bdca-20d4-431b-8884-9ed291ea3138', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'0b321d81-aefc-45ef-a995-a00771fa167c', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3e26bdfa-9bc8-4f42-985b-a05d19414d02', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'e5635d2f-fbc7-44a2-93cc-a06637c646f3', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'9f04f6ef-75fb-4c94-a781-a06d43d76663', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'd5760d3e-1a16-41d0-9081-a1e58cbedbae', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'0eaccd6e-53fd-4806-a0d3-a28eb261dfdb', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'59272af3-448d-4bf2-8964-a55b32b8929f', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'56df7d8a-bdf7-40e4-958c-a897d8d740c6', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'95b98d69-51e1-49fe-8bbb-aaca4e6f2f30', N'59de806a-a675-4120-b1e4-68f41804defd', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'695ea901-5513-4454-b9f7-aee1e84b34bf', N'59de806a-a675-4120-b1e4-68f41804defd', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'dea2361b-7835-451e-9543-af2d37152f11', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'ebf0966c-1a1c-4fc4-a481-b17051892d80', N'70a15724-a515-463c-915f-94260ad2cc64', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'2f17014c-8362-49c3-bcbf-b22873433f2e', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'dcb9a3bb-cce9-4db6-836e-b6213789650a', N'62da5c53-e70a-473a-923b-388232b79aff', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b3e9fc56-aa46-4936-b1ba-b7e8ffefc158', N'70a15724-a515-463c-915f-94260ad2cc64', N'L6T10', 2, N'11')

INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'2f57f337-ed15-4331-a9f1-b8b73bbf336b', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b85a1f04-ec53-4479-9fd1-bdbeb3c710f4', N'59de806a-a675-4120-b1e4-68f41804defd', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'32d818ae-f544-4e79-9edf-be415f269e7f', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'e82b44db-a5a8-452e-b72a-c128d56f25ff', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c8bb515d-5e15-45a2-819c-c2c63debc2f7', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'02c6cf24-d381-47ff-b5eb-c4ae10c5f26a', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'4ad98182-a45c-4ca0-8c49-c604cce55f58', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L2T54332', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'de5f9dc6-026c-4df6-aa26-c6b56cba3570', N'ba365217-bbce-4160-b891-82408e1ad498', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'00764616-e352-460b-9a73-c7641c238747', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'7cacd399-2cf7-4671-87da-c7d8e94c3c0c', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'2ccf9d8b-6f01-4c59-ae23-c878fd3fc0c6', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'e734d785-1720-457a-b1cb-c8f43f0a1c62', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'abd59321-a748-4258-bf69-cf5bbbaffcd2', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c9913d5a-ef54-4d9a-92f5-cf985207df0a', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b748deef-9ef1-4b78-8880-d26b4e0e9e4e', N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'da9c9824-ea98-401f-9094-d26b85d043df', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'dc59f20f-ea22-47c7-a565-d53a541df399', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'29f4ecbf-d218-404c-aa11-d88acbc62c26', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'8aef5e9c-3a0c-41a1-9bac-dafb6f0396cb', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'ce5baba5-d158-4d96-b33d-db02b1af3299', N'59de806a-a675-4120-b1e4-68f41804defd', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'4924567f-2378-46bf-ac7f-dfb692056de8', N'70a15724-a515-463c-915f-94260ad2cc64', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'e1f27ea8-245a-40a4-8a51-e0960629273d', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L1T1234', 2, N'15')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'09ffe2ba-9cf5-435b-b4e1-e12e96ebdd3f', N'70a15724-a515-463c-915f-94260ad2cc64', N'L4R4', 1, N'14')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'9b3f7522-fd61-442f-b9ba-e153853632bb', N'183bfe2a-1469-411e-a0cd-82de301917a5', N'L6T10', 2, N'11')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'c6e62c53-aee1-4f9f-843c-e1a4507779a8', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L7indel', 2, N'18')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'24578aae-9855-4397-be1d-e55683f2c10d', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'439a2c7d-b8ff-4f6a-bc42-e580162ff14f', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L5RTdev', 2, N'11.2')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'd149a91c-70ef-409e-967f-e830ff6966fa', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'af76d9bf-5e35-44a4-94d6-e98eb5274925', N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'62dcaf84-e12c-4b2b-8b02-e9e6dafae92c', N'70a15724-a515-463c-915f-94260ad2cc64', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'eddd874f-dd15-4fac-996b-ee0f92fdc56d', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L1T1234', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'3af4296c-05f0-46e7-8fa0-efc3f29b2754', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L2T54332', 1, N'13.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'dd813aae-06d5-4e1f-ad65-f19610882a38', N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'L7indel', 1, N'15.5')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a1cd7675-0b8d-4fbf-9099-f4a8e03ba9bd', N'fe36745d-5e2f-40e0-921a-c441f2102662', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'a7c07dbb-6ff4-404f-87d7-f4cdf283806e', N'62da5c53-e70a-473a-923b-388232b79aff', N'L6T10', 1, N'11.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'223019e0-1e08-4702-b055-f7033b9ee61d', N'59de806a-a675-4120-b1e4-68f41804defd', N'L8cascade', 2, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'055fb3da-bfb9-49e8-9b91-fb8c03ac80f1', N'70a15724-a515-463c-915f-94260ad2cc64', N'L4R4', 2, N'19')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'b1a79ca3-db00-48a7-8782-fbdb682b9dae', N'62da5c53-e70a-473a-923b-388232b79aff', N'L5RTdev', 1, N'13')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'14eb167d-471c-433d-b0dd-fd0e7faf503f', N'ba365217-bbce-4160-b891-82408e1ad498', N'L8cascade', 1, N'17.1')
INSERT [dbo].[DNAValues] ([DNAValID], [ExamObjID], [Locus], [ValOrder], [Value]) VALUES (N'88188299-d7cb-459e-9be6-fda89376882c', N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'L6T10', 2, N'11')

INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'62da5c53-e70a-473a-923b-388232b79aff', N'1', N'UHR3', N'C', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'59de806a-a675-4120-b1e4-68f41804defd', N'1', N'Trace1', N'T', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'6ad47977-3722-4693-81b2-747bb6a42b0b', N'1', N'Sample2', N'P', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'ba365217-bbce-4160-b891-82408e1ad498', N'1', N'Trace2', N'T', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'183bfe2a-1469-411e-a0cd-82de301917a5', N'1', N'RMP2', N'R', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'70a15724-a515-463c-915f-94260ad2cc64', N'1', N'UHR1', N'C', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'45864697-4e0a-49cd-90be-9dba56a0bd29', N'1', N'Sample1', N'P', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'fe36745d-5e2f-40e0-921a-c441f2102662', N'1', N'UHR2', N'C', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'8dc9f4b1-34c7-4a81-abb1-f11bb6779278', N'1', N'RMP1', N'R', N'1', N'A')
INSERT [dbo].[ExamObjects] ([ExamObjID], [ObjNum], [ObjName], [IndexType], [PersCount], [ValidateState]) VALUES (N'9c2aeeb1-f651-4740-8b3e-f42ac01e089a', N'1', N'Sample3', N'P', N'1', N'A')

INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L1T1234')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L2T54332')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L3R12')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L4R4')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L5RTdev')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L6T10')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L7indel')
INSERT [dbo].[Locuses] ([Locus]) VALUES (N'L8cascade')

ALTER TABLE [dbo].[DNAValues] ADD  DEFAULT (newid()) FOR [DNAValID]

ALTER TABLE [dbo].[DNAValues]  WITH CHECK ADD FOREIGN KEY([ExamObjID])
REFERENCES [dbo].[ExamObjects] ([ExamObjID])

ALTER TABLE [dbo].[DNAValues]  WITH CHECK ADD FOREIGN KEY([Locus])
REFERENCES [dbo].[Locuses] ([Locus])

ALTER TABLE [dbo].[SearchResults]  WITH CHECK ADD FOREIGN KEY([ExamObjID])
REFERENCES [dbo].[ExamObjects] ([ExamObjID])

ALTER TABLE [dbo].[SearchResults]  WITH CHECK ADD FOREIGN KEY([MatchObjID])
REFERENCES [dbo].[ExamObjects] ([ExamObjID])
173 rows affected

SET STATISTICS XML ON
DECLARE @ExamObjID UNIQUEIDENTIFIER = '62DA5C53-E70A-473A-923B-388232B79AFF'
DECLARE @Target TABLE (
    ExamObjID UNIQUEIDENTIFIER NOT NULL,
    Locus VARCHAR(15) NOT NULL,
    Value VARCHAR(5) NOT NULL,
    PRIMARY KEY (ExamObjID, Locus, Value)
);

INSERT INTO @Target (ExamObjID, Locus, Value)
SELECT ExamObjID, Locus, Value
FROM vwValues
WHERE ExamObjID = @ExamObjID;

    SELECT
      other.ExamObjID,
      other.Locus,
      Matches = COUNT(CASE WHEN other.Value = t.Value THEN 1 END)
    FROM vwValues other
    JOIN @Target t ON t.Locus = other.Locus
    WHERE t.ExamObjID <> other.ExamObjID
    GROUP BY
      other.ExamObjID,
      other.Locus


SELECT
  other.ExamObjID,
  Mismatches = COUNT(CASE WHEN other.Matches = 0 THEN 1 END)
FROM (
    SELECT
      other.ExamObjID,
      other.Locus,
      Matches = COUNT(CASE WHEN other.Value = t.Value THEN 1 END)
    FROM vwValues other
    JOIN @Target t ON t.Locus = other.Locus
    WHERE t.ExamObjID <> other.ExamObjID
    GROUP BY
      other.ExamObjID,
      other.Locus
) other
GROUP BY
  other.ExamObjID
HAVING COUNT(*) >= 6
   AND COUNT(CASE WHEN other.Matches = 0 THEN 1 END) <= 2;


Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="INSERT INTO @Target (ExamObjID, Locus, Value)&#xa;SELECT ExamObjID, Locus, Value&#xa;FROM vwValues&#xa;WHERE ExamObjID = @ExamObjID" StatementId="1" StatementCompId="3" StatementType="INSERT" StatementSqlHandle="0x0900CD99B56008FF76FB96CA73B8D72D14C90000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="3" ParentObjectId="0" BatchSqlHandle="0x02000000D79786123E747C100BE1F85F56113ABE176097EB0000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="0.0176" StatementEstRows="14" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x8A20180340ADFC1B" QueryPlanHash="0x5D3009277E2E496E" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" NonParallelPlanReason="TableVariableTransactionsDoNotSupportParallelNestedTransaction" CachedPlanSize="24" CompileTime="15" CompileCPU="15" CompileMemory="272"><MemoryGrantInfo SerialRequiredMemory="0" SerialDesiredMemory="0" GrantedMemory="0" MaxUsedMemory="0"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1013776"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[PK__ExamObje__80BD4EBD612BA103]" Table="[ExamObjects]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_37A5467C]" Table="[DNAValues]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Clustered Index Insert" LogicalOp="Insert" EstimateRows="14" EstimateIO="0.01" EstimateCPU="1.4e-05" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0176" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="29" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Update DMLRequestSort="0"><Object Table="[@Target]" Index="[PK__#BF0A46D__C41ED54102C84E6F]" Storage="RowStore"></Object><SetPredicate><ScalarOperator ScalarString="[ExamObjID] = [fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ExamObjID],[Locus] = [fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[Locus],[Value] = RaiseIfNullInsert([fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[Value])"><ScalarExpressionList><ScalarOperator><MultipleAssign><Assign><ColumnReference Column="ExamObjID"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Column="Locus"></ColumnReference><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></Identifier></ScalarOperator></Assign><Assign><ColumnReference Column="Value"></ColumnReference><ScalarOperator><Intrinsic FunctionName="RaiseIfNullInsert"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Assign></MultipleAssign></ScalarOperator></ScalarExpressionList></ScalarOperator></SetPredicate><RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="14" EstimateIO="0" EstimateCPU="5.852e-05" AvgRowSize="38" EstimatedTotalSubtreeCost="0.00758604" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><RelOp NodeId="2" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="24" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Index="[PK__ExamObje__80BD4EBD612BA103]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[@ExamObjID]"><Identifier><ColumnReference Column="@ExamObjID"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates><Predicate><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ValidateState]=&apos;A&apos;"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ValidateState"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;A&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="3" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14" EstimatedRowsRead="140" EstimateIO="0.00386574" EstimateCPU="0.000311" AvgRowSize="38" EstimatedTotalSubtreeCost="0.00417674" TableCardinality="140" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="140" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Index="[PK__DNAValue__514EA7271116A4C0]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[ExamObjID]=[@ExamObjID]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="@ExamObjID"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp></NestedLoops></RelOp></Update></RelOp><ParameterList><ColumnReference Column="@ExamObjID" ParameterDataType="uniqueidentifier" ParameterRuntimeValue="{guid&apos;62DA5C53-E70A-473A-923B-388232B79AFF&apos;}"></ColumnReference></ParameterList></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>




ExamObjID
Locus
Matches


59de806a-a675-4120-b1e4-68f41804defd
L1T1234
1

6ad47977-3722-4693-81b2-747bb6a42b0b
L1T1234
2

ba365217-bbce-4160-b891-82408e1ad498
L1T1234
1

183bfe2a-1469-411e-a0cd-82de301917a5
L1T1234
2

70a15724-a515-463c-915f-94260ad2cc64
L1T1234
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L1T1234
2

fe36745d-5e2f-40e0-921a-c441f2102662
L1T1234
2

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L1T1234
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L1T1234
1

59de806a-a675-4120-b1e4-68f41804defd
L2T54332
2

6ad47977-3722-4693-81b2-747bb6a42b0b
L2T54332
2

ba365217-bbce-4160-b891-82408e1ad498
L2T54332
1

183bfe2a-1469-411e-a0cd-82de301917a5
L2T54332
1

70a15724-a515-463c-915f-94260ad2cc64
L2T54332
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L2T54332
2

fe36745d-5e2f-40e0-921a-c441f2102662
L2T54332
2

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L2T54332
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L2T54332
2

59de806a-a675-4120-b1e4-68f41804defd
L4R4
2

6ad47977-3722-4693-81b2-747bb6a42b0b
L4R4
2

ba365217-bbce-4160-b891-82408e1ad498
L4R4
2

183bfe2a-1469-411e-a0cd-82de301917a5
L4R4
2

70a15724-a515-463c-915f-94260ad2cc64
L4R4
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L4R4
2

fe36745d-5e2f-40e0-921a-c441f2102662
L4R4
1

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L4R4
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L4R4
2

59de806a-a675-4120-b1e4-68f41804defd
L5RTdev
2

6ad47977-3722-4693-81b2-747bb6a42b0b
L5RTdev
2

ba365217-bbce-4160-b891-82408e1ad498
L5RTdev
2

183bfe2a-1469-411e-a0cd-82de301917a5
L5RTdev
1

70a15724-a515-463c-915f-94260ad2cc64
L5RTdev
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L5RTdev
1

fe36745d-5e2f-40e0-921a-c441f2102662
L5RTdev
2

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L5RTdev
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L5RTdev
1

59de806a-a675-4120-b1e4-68f41804defd
L6T10
2

6ad47977-3722-4693-81b2-747bb6a42b0b
L6T10
2

ba365217-bbce-4160-b891-82408e1ad498
L6T10
2

183bfe2a-1469-411e-a0cd-82de301917a5
L6T10
2

70a15724-a515-463c-915f-94260ad2cc64
L6T10
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L6T10
2

fe36745d-5e2f-40e0-921a-c441f2102662
L6T10
2

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L6T10
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L6T10
2

59de806a-a675-4120-b1e4-68f41804defd
L7indel
2

6ad47977-3722-4693-81b2-747bb6a42b0b
L7indel
2

ba365217-bbce-4160-b891-82408e1ad498
L7indel
2

183bfe2a-1469-411e-a0cd-82de301917a5
L7indel
2

70a15724-a515-463c-915f-94260ad2cc64
L7indel
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L7indel
2

fe36745d-5e2f-40e0-921a-c441f2102662
L7indel
2

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L7indel
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L7indel
2

59de806a-a675-4120-b1e4-68f41804defd
L8cascade
2

6ad47977-3722-4693-81b2-747bb6a42b0b
L8cascade
2

ba365217-bbce-4160-b891-82408e1ad498
L8cascade
2

183bfe2a-1469-411e-a0cd-82de301917a5
L8cascade
2

70a15724-a515-463c-915f-94260ad2cc64
L8cascade
2

45864697-4e0a-49cd-90be-9dba56a0bd29
L8cascade
2

fe36745d-5e2f-40e0-921a-c441f2102662
L8cascade
2

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
L8cascade
2

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
L8cascade
2


Warning: Null value is eliminated by an aggregate or other SET operation.




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa;      other.ExamObjID,&#xa;      other.Locus,&#xa;      Matches = COUNT(CASE WHEN other.Value = t.Value THEN 1 END)&#xa;    FROM vwValues other&#xa;    JOIN @Target t ON t.Locus = other.Locus&#xa;    WHERE t.ExamObjID &lt;&gt; other.ExamObjID&#xa;    GROUP BY&#xa;      other.ExamObjID,&#xa;      other.Locus" StatementId="2" StatementCompId="4" StatementType="SELECT" StatementSqlHandle="0x0900C78D13E506DD8B167A1BB6BFCF6DFF2A0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="3" ParentObjectId="0" BatchSqlHandle="0x02000000D79786123E747C100BE1F85F56113ABE176097EB0000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="0.0622807" StatementEstRows="62.8014" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xD56CE06D39557E89" QueryPlanHash="0x01A7B4283AC07333" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="2656" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="88" CompileTime="0" CompileCPU="0" CompileMemory="400"><MemoryGrantInfo SerialRequiredMemory="2560" SerialDesiredMemory="2656" RequiredMemory="2560" DesiredMemory="2656" RequestedMemory="2656" GrantWaitTime="0" MaxQueryMemory="727192" GrantedMemory="2656" MaxUsedMemory="592"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1013776"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[PK__ExamObje__80BD4EBD612BA103]" Table="[ExamObjects]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.22" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000006_35BCFE0A]" Table="[ExamObjects]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_37A5467C]" Table="[DNAValues]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_37A5467C]" Table="[DNAValues]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="62.8014" EstimateIO="0" EstimateCPU="0" AvgRowSize="37" EstimatedTotalSubtreeCost="0.0622807" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1006],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="62.8014" EstimateIO="0" EstimateCPU="0.000115401" AvgRowSize="37" EstimatedTotalSubtreeCost="0.0622807" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="63" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="COUNT(CASE WHEN [fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[Value]=@Target.[Value] as [t].[Value] THEN (1) ELSE NULL END)"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></GroupBy><RelOp NodeId="2" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="140" EstimateIO="0.0112613" EstimateCPU="0.00165708" AvgRowSize="41" EstimatedTotalSubtreeCost="0.0621653" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></OutputList><MemoryFractions Input="0.333333" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="252" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="544" OutputMemoryGrant="224" UsedMemoryGrant="32" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="3" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="140" EstimateIO="0" EstimateCPU="0.019427" AvgRowSize="41" EstimatedTotalSubtreeCost="0.049247" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.333333"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="252" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1072" OutputMemoryGrant="1056" UsedMemoryGrant="248" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[Locus]=@Target.[Locus] as [t].[Locus] AND @Target.[ExamObjID] as [t].[ExamObjID]&lt;&gt;[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ExamObjID]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Table="@Target" Alias="[t]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="4" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14" EstimatedRowsRead="14" EstimateIO="0.003125" EstimateCPU="0.0001724" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032974" TableCardinality="14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@Target" Alias="[t]" Column="ExamObjID"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="14" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="@Target" Alias="[t]" Column="ExamObjID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></DefinedValue></DefinedValues><Object Table="[@Target]" Index="[PK__#BF0A46D__C41ED54102C84E6F]" Alias="[t]" Storage="RowStore"></Object></IndexScan></RelOp><RelOp NodeId="5" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="140" EstimateIO="0" EstimateCPU="0.0190381" AvgRowSize="37" EstimatedTotalSubtreeCost="0.0265156" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.333333"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="140" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1072" OutputMemoryGrant="1056" UsedMemoryGrant="320" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[ExamObjID]=[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ExamObjID]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="6" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10" EstimatedRowsRead="10" EstimateIO="0.003125" EstimateCPU="0.000168" AvgRowSize="24" EstimatedTotalSubtreeCost="0.003293" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="10" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Index="[PK__ExamObje__80BD4EBD612BA103]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ValidateState]=&apos;A&apos;"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ValidateState"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;A&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="7" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="140" EstimatedRowsRead="140" EstimateIO="0.00386574" EstimateCPU="0.000311" AvgRowSize="37" EstimatedTotalSubtreeCost="0.00417674" TableCardinality="140" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="140" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="140" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Index="[PK__DNAValue__514EA7271116A4C0]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>




ExamObjID
Mismatches


59de806a-a675-4120-b1e4-68f41804defd
0

6ad47977-3722-4693-81b2-747bb6a42b0b
0

ba365217-bbce-4160-b891-82408e1ad498
0

183bfe2a-1469-411e-a0cd-82de301917a5
0

70a15724-a515-463c-915f-94260ad2cc64
0

45864697-4e0a-49cd-90be-9dba56a0bd29
0

fe36745d-5e2f-40e0-921a-c441f2102662
0

8dc9f4b1-34c7-4a81-abb1-f11bb6779278
0

9c2aeeb1-f651-4740-8b3e-f42ac01e089a
0


Warning: Null value is eliminated by an aggregate or other SET operation.




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.564" Build="16.0.1000.6"><BatchSequence><Batch><Statements><StmtSimple StatementText="SELECT&#xa;  other.ExamObjID,&#xa;  Mismatches = COUNT(CASE WHEN other.Matches = 0 THEN 1 END)&#xa;FROM (&#xa;    SELECT&#xa;      other.ExamObjID,&#xa;      other.Locus,&#xa;      Matches = COUNT(CASE WHEN other.Value = t.Value THEN 1 END)&#xa;    FROM vwValues other&#xa;    JOIN @Target t ON t.Locus = other.Locus&#xa;    WHERE t.ExamObjID &lt;&gt; other.ExamObjID&#xa;    GROUP BY&#xa;      other.ExamObjID,&#xa;      other.Locus&#xa;) other&#xa;GROUP BY&#xa;  other.ExamObjID&#xa;HAVING COUNT(*) &gt;= 6&#xa;   AND COUNT(CASE WHEN other.Matches = 0 THEN 1 END) &lt;= 2" StatementId="3" StatementCompId="5" StatementType="SELECT" StatementSqlHandle="0x0900C699AFB5EC153842F80F92C405240EEC0000000000000000000000000000000000000000000000000000" DatabaseContextSettingsId="3" ParentObjectId="0" BatchSqlHandle="0x02000000D79786123E747C100BE1F85F56113ABE176097EB0000000000000000000000000000000000000000" StatementParameterizationType="0" RetrievedFromCache="false" StatementSubTreeCost="0.0623322" StatementEstRows="1" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xF2CD158255C93099" QueryPlanHash="0x081D988C01B0FAC7" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="160"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="2656" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="96" CompileTime="15" CompileCPU="15" CompileMemory="504"><MemoryGrantInfo SerialRequiredMemory="2560" SerialDesiredMemory="2656" RequiredMemory="2560" DesiredMemory="2656" RequestedMemory="2656" GrantWaitTime="0" MaxQueryMemory="727192" GrantedMemory="2656" MaxUsedMemory="592"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1013776"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[PK__ExamObje__80BD4EBD612BA103]" Table="[ExamObjects]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.22" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000006_35BCFE0A]" Table="[ExamObjects]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000002_37A5467C]" Table="[DNAValues]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo><StatisticsInfo LastUpdate="2023-04-12T06:43:06.19" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_37A5467C]" Table="[DNAValues]" Schema="[dbo]" Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="0" CpuTime="0"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="8.8e-06" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0623322" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="10" EstimateIO="0" EstimateCPU="0" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0623234" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference><ColumnReference Column="Expr1007"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1009],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1007"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1010],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1010"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="10" EstimateIO="0" EstimateCPU="4.26808e-05" AvgRowSize="31" EstimatedTotalSubtreeCost="0.0623234" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference><ColumnReference Column="Expr1010"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="9" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="Count(*)"><Aggregate AggType="countstar" Distinct="0"></Aggregate></ScalarOperator></DefinedValue><DefinedValue><ColumnReference Column="Expr1010"></ColumnReference><ScalarOperator ScalarString="COUNT(CASE WHEN [Expr1005]=(0) THEN (1) ELSE NULL END)"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Column="Expr1005"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(0)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></GroupBy><RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="62.8014" EstimateIO="0" EstimateCPU="0" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0622807" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Column="Expr1005"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1005"></ColumnReference><ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[Expr1008],0)"><Convert DataType="int" Style="0" Implicit="1"><ScalarOperator><Identifier><ColumnReference Column="Expr1008"></ColumnReference></Identifier></ScalarOperator></Convert></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="4" PhysicalOp="Stream Aggregate" LogicalOp="Aggregate" EstimateRows="62.8014" EstimateIO="0" EstimateCPU="0.000115401" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0622807" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Column="Expr1008"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="63" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><StreamAggregate><DefinedValues><DefinedValue><ColumnReference Column="Expr1008"></ColumnReference><ScalarOperator ScalarString="COUNT(CASE WHEN [fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[Value]=@Target.[Value] as [t].[Value] THEN (1) ELSE NULL END)"><Aggregate Distinct="0" AggType="COUNT_BIG"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><GroupBy><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></GroupBy><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="140" EstimateIO="0.0112613" EstimateCPU="0.00165708" AvgRowSize="41" EstimatedTotalSubtreeCost="0.0621653" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></OutputList><MemoryFractions Input="0.333333" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="252" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="544" OutputMemoryGrant="224" UsedMemoryGrant="32" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="140" EstimateIO="0" EstimateCPU="0.019427" AvgRowSize="41" EstimatedTotalSubtreeCost="0.049247" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.333333"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="252" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1072" OutputMemoryGrant="1056" UsedMemoryGrant="248" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[Locus]=@Target.[Locus] as [t].[Locus] AND @Target.[ExamObjID] as [t].[ExamObjID]&lt;&gt;[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ExamObjID]"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="NE"><ScalarOperator><Identifier><ColumnReference Table="@Target" Alias="[t]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></ProbeResidual><RelOp NodeId="7" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="14" EstimatedRowsRead="14" EstimateIO="0.003125" EstimateCPU="0.0001724" AvgRowSize="38" EstimatedTotalSubtreeCost="0.0032974" TableCardinality="14" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Table="@Target" Alias="[t]" Column="ExamObjID"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="14" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="14" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Table="@Target" Alias="[t]" Column="ExamObjID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="@Target" Alias="[t]" Column="Locus"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Table="@Target" Alias="[t]" Column="Value"></ColumnReference></DefinedValue></DefinedValues><Object Table="[@Target]" Index="[PK__#BF0A46D__C41ED54102C84E6F]" Alias="[t]" Storage="RowStore"></Object></IndexScan></RelOp><RelOp NodeId="8" PhysicalOp="Hash Match" LogicalOp="Inner Join" EstimateRows="140" EstimateIO="0" EstimateCPU="0.0190381" AvgRowSize="37" EstimatedTotalSubtreeCost="0.0265156" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></OutputList><MemoryFractions Input="0.5" Output="0.333333"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="140" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1072" OutputMemoryGrant="1056" UsedMemoryGrant="320" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></HashKeysBuild><HashKeysProbe><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></HashKeysProbe><ProbeResidual><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[DNAValues].[ExamObjID]=[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ExamObjID]"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></Identifier></ScalarOperator></Compare></ScalarOperator></ProbeResidual><RelOp NodeId="9" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="10" EstimatedRowsRead="10" EstimateIO="0.003125" EstimateCPU="0.000168" AvgRowSize="24" EstimatedTotalSubtreeCost="0.003293" TableCardinality="10" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="10" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="2" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="10" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ExamObjID"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Index="[PK__ExamObje__80BD4EBD612BA103]" IndexKind="Clustered" Storage="RowStore"></Object><Predicate><ScalarOperator ScalarString="[fiddle_c5d4a5d246684819ba5ccf1043a07525].[dbo].[ExamObjects].[ValidateState]=&apos;A&apos;"><Compare CompareOp="EQ"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[ExamObjects]" Column="ValidateState"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="&apos;A&apos;"></Const></ScalarOperator></Compare></ScalarOperator></Predicate></IndexScan></RelOp><RelOp NodeId="10" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="140" EstimatedRowsRead="140" EstimateIO="0.00386574" EstimateCPU="0.000311" AvgRowSize="37" EstimatedTotalSubtreeCost="0.00417674" TableCardinality="140" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="140" Batches="0" ActualElapsedms="0" ActualCPUms="0" ActualScans="1" ActualLogicalReads="4" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="140" ActualEndOfScans="1" ActualExecutions="1" ActualExecutionMode="Row"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="ExamObjID"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Locus"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Column="Value"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_c5d4a5d246684819ba5ccf1043a07525]" Schema="[dbo]" Table="[DNAValues]" Index="[PK__DNAValue__514EA7271116A4C0]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></Hash></RelOp></Hash></RelOp></Sort></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp></StreamAggregate></RelOp></ComputeScalar></RelOp><Predicate><ScalarOperator ScalarString="[Expr1006]&gt;=(6) AND [Expr1007]&lt;=(2)"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="GE"><ScalarOperator><Identifier><ColumnReference Column="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(6)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><Identifier><ColumnReference Column="Expr1007"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
ExamObjID	Locus	Matches
59de806a-a675-4120-b1e4-68f41804defd	L1T1234	1
6ad47977-3722-4693-81b2-747bb6a42b0b	L1T1234	2
ba365217-bbce-4160-b891-82408e1ad498	L1T1234	1
183bfe2a-1469-411e-a0cd-82de301917a5	L1T1234	2
70a15724-a515-463c-915f-94260ad2cc64	L1T1234	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L1T1234	2
fe36745d-5e2f-40e0-921a-c441f2102662	L1T1234	2
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L1T1234	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L1T1234	1
59de806a-a675-4120-b1e4-68f41804defd	L2T54332	2
6ad47977-3722-4693-81b2-747bb6a42b0b	L2T54332	2
ba365217-bbce-4160-b891-82408e1ad498	L2T54332	1
183bfe2a-1469-411e-a0cd-82de301917a5	L2T54332	1
70a15724-a515-463c-915f-94260ad2cc64	L2T54332	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L2T54332	2
fe36745d-5e2f-40e0-921a-c441f2102662	L2T54332	2
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L2T54332	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L2T54332	2
59de806a-a675-4120-b1e4-68f41804defd	L4R4	2
6ad47977-3722-4693-81b2-747bb6a42b0b	L4R4	2
ba365217-bbce-4160-b891-82408e1ad498	L4R4	2
183bfe2a-1469-411e-a0cd-82de301917a5	L4R4	2
70a15724-a515-463c-915f-94260ad2cc64	L4R4	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L4R4	2
fe36745d-5e2f-40e0-921a-c441f2102662	L4R4	1
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L4R4	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L4R4	2
59de806a-a675-4120-b1e4-68f41804defd	L5RTdev	2
6ad47977-3722-4693-81b2-747bb6a42b0b	L5RTdev	2
ba365217-bbce-4160-b891-82408e1ad498	L5RTdev	2
183bfe2a-1469-411e-a0cd-82de301917a5	L5RTdev	1
70a15724-a515-463c-915f-94260ad2cc64	L5RTdev	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L5RTdev	1
fe36745d-5e2f-40e0-921a-c441f2102662	L5RTdev	2
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L5RTdev	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L5RTdev	1
59de806a-a675-4120-b1e4-68f41804defd	L6T10	2
6ad47977-3722-4693-81b2-747bb6a42b0b	L6T10	2
ba365217-bbce-4160-b891-82408e1ad498	L6T10	2
183bfe2a-1469-411e-a0cd-82de301917a5	L6T10	2
70a15724-a515-463c-915f-94260ad2cc64	L6T10	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L6T10	2
fe36745d-5e2f-40e0-921a-c441f2102662	L6T10	2
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L6T10	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L6T10	2
59de806a-a675-4120-b1e4-68f41804defd	L7indel	2
6ad47977-3722-4693-81b2-747bb6a42b0b	L7indel	2
ba365217-bbce-4160-b891-82408e1ad498	L7indel	2
183bfe2a-1469-411e-a0cd-82de301917a5	L7indel	2
70a15724-a515-463c-915f-94260ad2cc64	L7indel	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L7indel	2
fe36745d-5e2f-40e0-921a-c441f2102662	L7indel	2
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L7indel	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L7indel	2
59de806a-a675-4120-b1e4-68f41804defd	L8cascade	2
6ad47977-3722-4693-81b2-747bb6a42b0b	L8cascade	2
ba365217-bbce-4160-b891-82408e1ad498	L8cascade	2
183bfe2a-1469-411e-a0cd-82de301917a5	L8cascade	2
70a15724-a515-463c-915f-94260ad2cc64	L8cascade	2
45864697-4e0a-49cd-90be-9dba56a0bd29	L8cascade	2
fe36745d-5e2f-40e0-921a-c441f2102662	L8cascade	2
8dc9f4b1-34c7-4a81-abb1-f11bb6779278	L8cascade	2
9c2aeeb1-f651-4740-8b3e-f42ac01e089a	L8cascade	2