Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

CTE Recursive sample

Language: Layout:
View schema
Absolute service time: 0,17 sec 
edit mode |  history  | discussion
Error(s), warning(s):
The statement terminated. The maximum recursion 100 has been exhausted before statement completion.
   (No column name) (No column name) (No column name)
1 2013 1 1
2 2013 1 2
3 2013 1 3
4 2013 1 4
5 2013 1 5
6 2013 1 6
7 2013 1 7
8 2013 1 8
9 2013 1 9
10 2013 1 10
11 2013 1 11
12 2013 1 12
13 2013 1 13
14 2013 1 14
15 2013 1 15
16 2013 1 16
17 2013 1 17
18 2013 1 18
19 2013 1 19
20 2013 1 20
21 2013 1 21
22 2013 1 22
23 2013 1 23
24 2013 1 24
25 2013 1 25
26 2013 1 26
27 2013 1 27
28 2013 1 28
29 2013 1 29
30 2013 1 30
31 2013 1 31
32 2013 2 1
33 2013 2 2
34 2013 2 3
35 2013 2 4
36 2013 2 5
37 2013 2 6
38 2013 2 7
39 2013 2 8
40 2013 2 9
41 2013 2 10
42 2013 2 11
43 2013 2 12
44 2013 2 13
45 2013 2 14
46 2013 2 15
47 2013 2 16
48 2013 2 17
49 2013 2 18
50 2013 2 19
51 2013 2 20
52 2013 2 21
53 2013 2 22
54 2013 2 23
55 2013 2 24
56 2013 2 25
57 2013 2 26
58 2013 2 27
59 2013 2 28
60 2013 3 1
61 2013 3 2
62 2013 3 3
63 2013 3 4
64 2013 3 5
65 2013 3 6
66 2013 3 7
67 2013 3 8
68 2013 3 9
69 2013 3 10
70 2013 3 11
71 2013 3 12
72 2013 3 13
73 2013 3 14
74 2013 3 15
75 2013 3 16
76 2013 3 17
77 2013 3 18
78 2013 3 19
79 2013 3 20
80 2013 3 21
81 2013 3 22
82 2013 3 23
83 2013 3 24
84 2013 3 25
85 2013 3 26
86 2013 3 27
87 2013 3 28
88 2013 3 29
89 2013 3 30
90 2013 3 31
91 2013 4 1
92 2013 4 2
93 2013 4 3
94 2013 4 4
95 2013 4 5
96 2013 4 6
97 2013 4 7
98 2013 4 8
99 2013 4 9
100 2013 4 10
101 2013 4 11