CTE Recursive sample

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