SQLERROR, Sql Server

SQLERROR

Language: Layout:

CREATE TABLE [dbo].[Table1](
	[id]  uniqueidentifier NOT NULL ,
	[id2] uniqueidentifier NOT NULL,
	[name] nvarchar(max) NOT NULL
 CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
))
GO
CREATE NONCLUSTERED INDEX [IX_Table2_ID2] ON [dbo].[Table1]
(
	[id2] ASC
)
ALTER TABLE [dbo].[Table1] ADD  CONSTRAINT [DF_Id]  DEFAULT (newsequentialid()) FOR [id]

GO
CREATE TABLE [dbo].[Table2](
	[id] uniqueidentifier NOT NULL,
	[name] varchar(10)
 CONSTRAINT [PK_Table2] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)) 
GO
ALTER TABLE [dbo].[Table2] ADD  CONSTRAINT [DF_Id2]  DEFAULT (newsequentialid()) FOR [id]

Declare @loop int = 1
while @loop<=10
	begin
	insert into Table2 ([name]) Values(char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65)))
	set @loop = @loop+1
	end
set @loop = 1
while @loop<2000
	begin
	insert into Table1 (ID2, [name])
    select ID,char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65)) from Table2
	set @loop = @loop+1
	end
select top 100 table1.Name,table2.Name 
from table1 WITH (NOLOCK) left join table2 on table1.ID2= table2.ID 
order by table2.ID desc,table1.ID desc

View schema
Execution time: 1,92 sec, rows selected: 20211, rows affected: 20009, absolute service time: 2,49 sec

	Name	Name
1	DHFM	RWDR
2	VEMA	SDJK
3	WYYG	BHMA
4	HWJH	WUOQ
5	LLSI	RWDR
6	TIGJ	UXQG
7	XHNF	XGPW
8	TGGF	XGPW
9	SLDV	UXQG
10	GGSR	LFKS
11	BXLB	DDHH
12	YIXP	LFKS
13	AHPF	RWDR
14	NVGM	SDJK
15	HNEP	XGPW
16	VKKP	ABJD
17	MJUW	BHMA
18	YCDC	RWDR
19	UNXF	SDJK
20	JCWX	ABJD
21	UTPN	BHMA
22	QTAB	DDHH
23	AOLL	ABJD
24	CRPX	BHMA
25	OYFT	LFKS
26	NHAK	BHMA
27	GNRW	RWDR
28	GJST	SDJK
29	JKLC	UXQG
30	YEQP	RWDR
31	MDES	XVOX
32	WACY	WUOQ
33	WRQP	DDHH
34	LPHY	WUOQ
35	BHOD	SDJK
36	IXHA	WUOQ
37	GWBB	DDHH
38	VUXO	BHMA
39	SJWS	RWDR
40	JYIV	ABJD
41	QNNH	UXQG
42	QYMB	SDJK
43	BTBB	LFKS
44	UTYX	ABJD
45	YTJD	DDHH
46	HBES	LFKS
47	UEMX	SDJK
48	HKBL	DDHH
49	VBJN	DDHH
50	QIWG	WUOQ
51	NVEB	RWDR
52	GLUV	XGPW
53	VFOR	WUOQ
54	CMGF	WUOQ
55	PIPW	LFKS
56	ESCA	DDHH
57	ASWL	LFKS
58	NKAS	UXQG
59	PLVF	SDJK
60	WAXV	XGPW
61	GGJF	SDJK
62	RGDC	XGPW
63	ASAQ	UXQG
64	JLAH	LFKS
65	YAGE	XGPW
66	QAHS	XVOX
67	JKXH	ABJD
68	JNHY	SDJK
69	NFCR	RWDR
70	VYJA	RWDR
71	QFKR	XVOX
72	JIDD	XGPW
73	SQUL	XVOX
74	BOJB	WUOQ
75	KXOP	XGPW
76	TCDF	DDHH
77	NQWJ	SDJK
78	EBXV	ABJD
79	QQIU	WUOQ
80	RVUJ	ABJD
81	IUCL	BHMA
82	DYVU	DDHH
83	UTCX	BHMA
84	UQJS	LFKS
85	HSCG	BHMA
86	IFDV	ABJD
87	PRNA	XVOX
88	MDFR	SDJK
89	JCUY	SDJK
90	EDOQ	XVOX
91	PFMN	XGPW
92	PMJL	XGPW
93	EYJC	RWDR
94	HDAN	DDHH
95	XWGS	ABJD
96	LUSF	XVOX
97	FYNH	UXQG
98	AHAR	ABJD
99	QDTV	RWDR
100	DNWS	SDJK

	Name	Name
1	DHFM	RWDR
2	VEMA	SDJK
3	WYYG	BHMA
4	HWJH	WUOQ
5	LLSI	RWDR
6	TIGJ	UXQG
7	XHNF	XGPW
8	TGGF	XGPW
9	SLDV	UXQG
10	GGSR	LFKS
11	BXLB	DDHH
12	YIXP	LFKS
13	AHPF	RWDR
14	NVGM	SDJK
15	HNEP	XGPW
16	VKKP	ABJD
17	MJUW	BHMA
18	YCDC	RWDR
19	UNXF	SDJK
20	JCWX	ABJD
21	UTPN	BHMA
22	QTAB	DDHH
23	AOLL	ABJD
24	CRPX	BHMA
25	OYFT	LFKS
26	NHAK	BHMA
27	GNRW	RWDR
28	GJST	SDJK
29	JKLC	UXQG
30	YEQP	RWDR
31	MDES	XVOX
32	WACY	WUOQ
33	WRQP	DDHH
34	LPHY	WUOQ
35	BHOD	SDJK
36	IXHA	WUOQ
37	GWBB	DDHH
38	VUXO	BHMA
39	SJWS	RWDR
40	JYIV	ABJD
41	QNNH	UXQG
42	QYMB	SDJK
43	BTBB	LFKS
44	UTYX	ABJD
45	YTJD	DDHH
46	HBES	LFKS
47	UEMX	SDJK
48	HKBL	DDHH
49	VBJN	DDHH
50	QIWG	WUOQ
51	NVEB	RWDR
52	GLUV	XGPW
53	VFOR	WUOQ
54	CMGF	WUOQ
55	PIPW	LFKS
56	ESCA	DDHH
57	ASWL	LFKS
58	NKAS	UXQG
59	PLVF	SDJK
60	WAXV	XGPW
61	GGJF	SDJK
62	RGDC	XGPW
63	ASAQ	UXQG
64	JLAH	LFKS
65	YAGE	XGPW
66	QAHS	XVOX
67	JKXH	ABJD
68	JNHY	SDJK
69	NFCR	RWDR
70	VYJA	RWDR
71	QFKR	XVOX
72	JIDD	XGPW
73	SQUL	XVOX
74	BOJB	WUOQ
75	KXOP	XGPW
76	TCDF	DDHH
77	NQWJ	SDJK
78	EBXV	ABJD
79	QQIU	WUOQ
80	RVUJ	ABJD
81	IUCL	BHMA
82	DYVU	DDHH
83	UTCX	BHMA
84	UQJS	LFKS
85	HSCG	BHMA
86	IFDV	ABJD
87	PRNA	XVOX
88	MDFR	SDJK
89	JCUY	SDJK
90	EDOQ	XVOX
91	PFMN	XGPW
92	PMJL	XGPW
93	EYJC	RWDR
94	HDAN	DDHH
95	XWGS	ABJD
96	LUSF	XVOX
97	FYNH	UXQG
98	AHAR	ABJD
99	QDTV	RWDR
100	DNWS	SDJK