搭建qq群数据库社工库

简介

之前找了一下之前泄露的qq群数据库,然后搭建了一下,现在记录下过程

安装sqlserver

这个很简单,但是我要说的是不能使用高版本的数据库,最高只能到2008的sqlserver,因为这是老版本数据库分离出来的数据高版本的sqlserver是不支持附加的,附加会报错

sqlserver怎么安装什么的这个我就不说了,安装完成之后直接附加上数据库就好了

关于数据库

可能现在找数据库比较难,而且也不好找,百度网盘的话容易被封,如果要的话,自己找途径吧,找到后最好放在硬盘里面备份了,因为这种东西越来越难找了

数据库的md5

下面两个资源的内容其实是一样的,都是群数据库,只不过有的人重新打包了,你只要找到其中的一个就可以

1
2
3
4
5
6
7
98ae9be8075e7b59117f32d85d002a9e  ./QQ数据库.7z.001
930b8d048de53b3e75c79ebbce043306 ./QQ数据库.7z.002
9964a0b9677ba8229cc5528deba1efff ./QQ数据库.7z.003
65a9fc23da90415afc74c41a78dd4b0f ./QQ数据库.7z.004
95bdcd74f55de944c3923eec6e413568 ./QQ数据库.7z.005
58f9738d498dc68d45d9ab1aad44375a ./QQ数据库.7z.006
b889b51e1c7182a3a9c571a42bfa52e4 ./解压密码.txt
1
2
3
4
5
6
7
8
9
10
11
12
9765549d1c000dee37eeab8d20f10d68  ./GroupData10_Data.rar
af61b75c6c3a70fa4fe739c19b78cfac ./GroupData11_Data.rar
b247948f7c12de054f08f8210e6ded92 ./GroupData1_Data.rar
65beb720f39458f48c886f32db43aec2 ./GroupData2_Data.rar
4fbf7a47e044ca42dc92471e7e07816e ./GroupData3_Data.rar
d756f2d37977ce58f473d6ce53d8cf08 ./GroupData4_Data.rar
8ae0fb7923a9e97c6ad3a0a727c34074 ./GroupData5_Data.rar
a31b0275b49cabb278ef083f5e200e72 ./GroupData6_Data.rar
6be2d330a9f572054c63afc77705c680 ./GroupData7_Data.rar
ade94d211bc554f6fddd012997c4c49a ./GroupData8_Data.rar
3d96e8810cb00f5e75dec9d539f4a592 ./GroupData9_Data.rar
dbfea5064cff1285c9ea213648338aed ./QunInfo.rar

其实还有一个100多个g的soyun的数据库里面也是有很多数据的,这个我找不到源文件了,只有mdf文件,所以就不放md5了,而且服务器硬盘比较小就不折腾这个数据库了,下篇博客我会讲这个数据库的所有操作,为什么分开两个数据库来讲呢,因为服务器存储不够了,哈哈

附加数据库

1
2
3
4
5
6
7
8
9
10
11
EXEC sp_attach_db "QunInfo1", "D:\qqdb\QunData\QunInfo1_Data.MDF"
EXEC sp_attach_db "QunInfo2", "D:\qqdb\QunData\QunInfo2_Data.MDF"
EXEC sp_attach_db "QunInfo3", "D:\qqdb\QunData\QunInfo3_Data.MDF"
EXEC sp_attach_db "QunInfo4", "D:\qqdb\QunData\QunInfo4_Data.MDF"
EXEC sp_attach_db "QunInfo5", "D:\qqdb\QunData\QunInfo5_Data.MDF"
EXEC sp_attach_db "QunInfo6", "D:\qqdb\QunData\QunInfo6_Data.MDF"
EXEC sp_attach_db "QunInfo7", "D:\qqdb\QunData\QunInfo7_Data.MDF"
EXEC sp_attach_db "QunInfo8", "D:\qqdb\QunData\QunInfo8_Data.MDF"
EXEC sp_attach_db "QunInfo9", "D:\qqdb\QunData\QunInfo9_Data.MDF"
EXEC sp_attach_db "QunInfo10", "D:\qqdb\QunData\QunInfo10_Data.MDF"
EXEC sp_attach_db "QunInfo11", "D:\qqdb\QunData\QunInfo11_Data.MDF"
1
2
3
4
5
6
7
8
9
10
11
EXEC sp_attach_db "GroupData1", "D:\qqdb\QunData\GroupData1_Data.MDF"
EXEC sp_attach_db "GroupData2", "D:\qqdb\QunData\GroupData2_Data.MDF"
EXEC sp_attach_db "GroupData3", "D:\qqdb\QunData\GroupData3_Data.MDF"
EXEC sp_attach_db "GroupData4", "D:\qqdb\QunData\GroupData4_Data.MDF"
EXEC sp_attach_db "GroupData5", "D:\qqdb\QunData\GroupData5_Data.MDF"
EXEC sp_attach_db "GroupData6", "D:\qqdb\QunData\GroupData6_Data.MDF"
EXEC sp_attach_db "GroupData7", "D:\qqdb\QunData\GroupData7_Data.MDF"
EXEC sp_attach_db "GroupData8", "D:\qqdb\QunData\GroupData8_Data.MDF"
EXEC sp_attach_db "GroupData9", "D:\qqdb\QunData\GroupData9_Data.MDF"
EXEC sp_attach_db "GroupData10", "D:\qqdb\QunData\GroupData10_Data.MDF"
EXEC sp_attach_db "GroupData11", "D:\qqdb\QunData\GroupData11_Data.MDF"

附加完成之后创建索引

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
CREATE INDEX ix_QQNum_Group7 On GroupData1.dbo.Group7 (QQNum);  
CREATE INDEX ix_QQNum_Group75 On GroupData1.dbo.Group75 (QQNum);
CREATE INDEX ix_QQNum_Group8 On GroupData1.dbo.Group8 (QQNum);
CREATE INDEX ix_QQNum_Group76 On GroupData1.dbo.Group76 (QQNum);
CREATE INDEX ix_QQNum_Group9 On GroupData1.dbo.Group9 (QQNum);
CREATE INDEX ix_QQNum_Group77 On GroupData1.dbo.Group77 (QQNum);
CREATE INDEX ix_QQNum_Group10 On GroupData1.dbo.Group10 (QQNum);
CREATE INDEX ix_QQNum_Group78 On GroupData1.dbo.Group78 (QQNum);
CREATE INDEX ix_QQNum_Group11 On GroupData1.dbo.Group11 (QQNum);
CREATE INDEX ix_QQNum_Group79 On GroupData1.dbo.Group79 (QQNum);
CREATE INDEX ix_QQNum_Group12 On GroupData1.dbo.Group12 (QQNum);
CREATE INDEX ix_QQNum_Group80 On GroupData1.dbo.Group80 (QQNum);
CREATE INDEX ix_QQNum_Group13 On GroupData1.dbo.Group13 (QQNum);
CREATE INDEX ix_QQNum_Group81 On GroupData1.dbo.Group81 (QQNum);
CREATE INDEX ix_QQNum_Group14 On GroupData1.dbo.Group14 (QQNum);
CREATE INDEX ix_QQNum_Group82 On GroupData1.dbo.Group82 (QQNum);
CREATE INDEX ix_QQNum_Group15 On GroupData1.dbo.Group15 (QQNum);
CREATE INDEX ix_QQNum_Group83 On GroupData1.dbo.Group83 (QQNum);
CREATE INDEX ix_QQNum_Group16 On GroupData1.dbo.Group16 (QQNum);
CREATE INDEX ix_QQNum_Group84 On GroupData1.dbo.Group84 (QQNum);
CREATE INDEX ix_QQNum_Group17 On GroupData1.dbo.Group17 (QQNum);
CREATE INDEX ix_QQNum_Group85 On GroupData1.dbo.Group85 (QQNum);
CREATE INDEX ix_QQNum_Group18 On GroupData1.dbo.Group18 (QQNum);
CREATE INDEX ix_QQNum_Group86 On GroupData1.dbo.Group86 (QQNum);
CREATE INDEX ix_QQNum_Group19 On GroupData1.dbo.Group19 (QQNum);
CREATE INDEX ix_QQNum_Group87 On GroupData1.dbo.Group87 (QQNum);
CREATE INDEX ix_QQNum_Group20 On GroupData1.dbo.Group20 (QQNum);
CREATE INDEX ix_QQNum_Group88 On GroupData1.dbo.Group88 (QQNum);
CREATE INDEX ix_QQNum_Group21 On GroupData1.dbo.Group21 (QQNum);
CREATE INDEX ix_QQNum_Group89 On GroupData1.dbo.Group89 (QQNum);
CREATE INDEX ix_QQNum_Group22 On GroupData1.dbo.Group22 (QQNum);
CREATE INDEX ix_QQNum_Group90 On GroupData1.dbo.Group90 (QQNum);
CREATE INDEX ix_QQNum_Group23 On GroupData1.dbo.Group23 (QQNum);
CREATE INDEX ix_QQNum_Group91 On GroupData1.dbo.Group91 (QQNum);
CREATE INDEX ix_QQNum_Group24 On GroupData1.dbo.Group24 (QQNum);
CREATE INDEX ix_QQNum_Group92 On GroupData1.dbo.Group92 (QQNum);
CREATE INDEX ix_QQNum_Group25 On GroupData1.dbo.Group25 (QQNum);
CREATE INDEX ix_QQNum_Group93 On GroupData1.dbo.Group93 (QQNum);
CREATE INDEX ix_QQNum_Group26 On GroupData1.dbo.Group26 (QQNum);
CREATE INDEX ix_QQNum_Group94 On GroupData1.dbo.Group94 (QQNum);
CREATE INDEX ix_QQNum_Group27 On GroupData1.dbo.Group27 (QQNum);
CREATE INDEX ix_QQNum_Group95 On GroupData1.dbo.Group95 (QQNum);
CREATE INDEX ix_QQNum_Group28 On GroupData1.dbo.Group28 (QQNum);
CREATE INDEX ix_QQNum_Group96 On GroupData1.dbo.Group96 (QQNum);
CREATE INDEX ix_QQNum_Group29 On GroupData1.dbo.Group29 (QQNum);
CREATE INDEX ix_QQNum_Group97 On GroupData1.dbo.Group97 (QQNum);
CREATE INDEX ix_QQNum_Group30 On GroupData1.dbo.Group30 (QQNum);
CREATE INDEX ix_QQNum_Group98 On GroupData1.dbo.Group98 (QQNum);
CREATE INDEX ix_QQNum_Group31 On GroupData1.dbo.Group31 (QQNum);
CREATE INDEX ix_QQNum_Group99 On GroupData1.dbo.Group99 (QQNum);
CREATE INDEX ix_QQNum_Group32 On GroupData1.dbo.Group32 (QQNum);
CREATE INDEX ix_QQNum_Group100 On GroupData1.dbo.Group100 (QQNum);
CREATE INDEX ix_QQNum_Group33 On GroupData1.dbo.Group33 (QQNum);
CREATE INDEX ix_QQNum_Group34 On GroupData1.dbo.Group34 (QQNum);
CREATE INDEX ix_QQNum_Group35 On GroupData1.dbo.Group35 (QQNum);
CREATE INDEX ix_QQNum_Group36 On GroupData1.dbo.Group36 (QQNum);
CREATE INDEX ix_QQNum_Group37 On GroupData1.dbo.Group37 (QQNum);
CREATE INDEX ix_QQNum_Group38 On GroupData1.dbo.Group38 (QQNum);
CREATE INDEX ix_QQNum_Group39 On GroupData1.dbo.Group39 (QQNum);
CREATE INDEX ix_QQNum_Group40 On GroupData1.dbo.Group40 (QQNum);
CREATE INDEX ix_QQNum_Group41 On GroupData1.dbo.Group41 (QQNum);
CREATE INDEX ix_QQNum_Group42 On GroupData1.dbo.Group42 (QQNum);
CREATE INDEX ix_QQNum_Group43 On GroupData1.dbo.Group43 (QQNum);
CREATE INDEX ix_QQNum_Group44 On GroupData1.dbo.Group44 (QQNum);
CREATE INDEX ix_QQNum_Group45 On GroupData1.dbo.Group45 (QQNum);
CREATE INDEX ix_QQNum_Group46 On GroupData1.dbo.Group46 (QQNum);
CREATE INDEX ix_QQNum_Group47 On GroupData1.dbo.Group47 (QQNum);
CREATE INDEX ix_QQNum_Group48 On GroupData1.dbo.Group48 (QQNum);
CREATE INDEX ix_QQNum_Group49 On GroupData1.dbo.Group49 (QQNum);
CREATE INDEX ix_QQNum_Group50 On GroupData1.dbo.Group50 (QQNum);
CREATE INDEX ix_QQNum_Group51 On GroupData1.dbo.Group51 (QQNum);
CREATE INDEX ix_QQNum_Group52 On GroupData1.dbo.Group52 (QQNum);
CREATE INDEX ix_QQNum_Group53 On GroupData1.dbo.Group53 (QQNum);
CREATE INDEX ix_QQNum_Group54 On GroupData1.dbo.Group54 (QQNum);
CREATE INDEX ix_QQNum_Group55 On GroupData1.dbo.Group55 (QQNum);
CREATE INDEX ix_QQNum_Group56 On GroupData1.dbo.Group56 (QQNum);
CREATE INDEX ix_QQNum_Group57 On GroupData1.dbo.Group57 (QQNum);
CREATE INDEX ix_QQNum_Group58 On GroupData1.dbo.Group58 (QQNum);
CREATE INDEX ix_QQNum_Group59 On GroupData1.dbo.Group59 (QQNum);
CREATE INDEX ix_QQNum_Group60 On GroupData1.dbo.Group60 (QQNum);
CREATE INDEX ix_QQNum_Group61 On GroupData1.dbo.Group61 (QQNum);
CREATE INDEX ix_QQNum_Group62 On GroupData1.dbo.Group62 (QQNum);
CREATE INDEX ix_QQNum_Group63 On GroupData1.dbo.Group63 (QQNum);
CREATE INDEX ix_QQNum_Group64 On GroupData1.dbo.Group64 (QQNum);
CREATE INDEX ix_QQNum_Group65 On GroupData1.dbo.Group65 (QQNum);
CREATE INDEX ix_QQNum_Group66 On GroupData1.dbo.Group66 (QQNum);
CREATE INDEX ix_QQNum_Group67 On GroupData1.dbo.Group67 (QQNum);
CREATE INDEX ix_QQNum_Group68 On GroupData1.dbo.Group68 (QQNum);
CREATE INDEX ix_QQNum_Group1 On GroupData1.dbo.Group1 (QQNum);
CREATE INDEX ix_QQNum_Group69 On GroupData1.dbo.Group69 (QQNum);
CREATE INDEX ix_QQNum_Group2 On GroupData1.dbo.Group2 (QQNum);
CREATE INDEX ix_QQNum_Group70 On GroupData1.dbo.Group70 (QQNum);
CREATE INDEX ix_QQNum_Group3 On GroupData1.dbo.Group3 (QQNum);
CREATE INDEX ix_QQNum_Group71 On GroupData1.dbo.Group71 (QQNum);
CREATE INDEX ix_QQNum_Group4 On GroupData1.dbo.Group4 (QQNum);
CREATE INDEX ix_QQNum_Group72 On GroupData1.dbo.Group72 (QQNum);
CREATE INDEX ix_QQNum_Group5 On GroupData1.dbo.Group5 (QQNum);
CREATE INDEX ix_QQNum_Group73 On GroupData1.dbo.Group73 (QQNum);
CREATE INDEX ix_QQNum_Group6 On GroupData1.dbo.Group6 (QQNum);
CREATE INDEX ix_QQNum_Group174 On GroupData2.dbo.Group174 (QQNum);
CREATE INDEX ix_QQNum_Group107 On GroupData2.dbo.Group107 (QQNum);
CREATE INDEX ix_QQNum_Group175 On GroupData2.dbo.Group175 (QQNum);
CREATE INDEX ix_QQNum_Group108 On GroupData2.dbo.Group108 (QQNum);
CREATE INDEX ix_QQNum_Group176 On GroupData2.dbo.Group176 (QQNum);
CREATE INDEX ix_QQNum_Group109 On GroupData2.dbo.Group109 (QQNum);
CREATE INDEX ix_QQNum_Group177 On GroupData2.dbo.Group177 (QQNum);
CREATE INDEX ix_QQNum_Group110 On GroupData2.dbo.Group110 (QQNum);
CREATE INDEX ix_QQNum_Group178 On GroupData2.dbo.Group178 (QQNum);
CREATE INDEX ix_QQNum_Group111 On GroupData2.dbo.Group111 (QQNum);
CREATE INDEX ix_QQNum_Group179 On GroupData2.dbo.Group179 (QQNum);
CREATE INDEX ix_QQNum_Group112 On GroupData2.dbo.Group112 (QQNum);
CREATE INDEX ix_QQNum_Group180 On GroupData2.dbo.Group180 (QQNum);
CREATE INDEX ix_QQNum_Group113 On GroupData2.dbo.Group113 (QQNum);
CREATE INDEX ix_QQNum_Group181 On GroupData2.dbo.Group181 (QQNum);
CREATE INDEX ix_QQNum_Group114 On GroupData2.dbo.Group114 (QQNum);
CREATE INDEX ix_QQNum_Group182 On GroupData2.dbo.Group182 (QQNum);
CREATE INDEX ix_QQNum_Group115 On GroupData2.dbo.Group115 (QQNum);
CREATE INDEX ix_QQNum_Group183 On GroupData2.dbo.Group183 (QQNum);
CREATE INDEX ix_QQNum_Group116 On GroupData2.dbo.Group116 (QQNum);
CREATE INDEX ix_QQNum_Group184 On GroupData2.dbo.Group184 (QQNum);
CREATE INDEX ix_QQNum_Group117 On GroupData2.dbo.Group117 (QQNum);
CREATE INDEX ix_QQNum_Group185 On GroupData2.dbo.Group185 (QQNum);
CREATE INDEX ix_QQNum_Group118 On GroupData2.dbo.Group118 (QQNum);
CREATE INDEX ix_QQNum_Group186 On GroupData2.dbo.Group186 (QQNum);
CREATE INDEX ix_QQNum_Group119 On GroupData2.dbo.Group119 (QQNum);
CREATE INDEX ix_QQNum_Group187 On GroupData2.dbo.Group187 (QQNum);
CREATE INDEX ix_QQNum_Group120 On GroupData2.dbo.Group120 (QQNum);
CREATE INDEX ix_QQNum_Group188 On GroupData2.dbo.Group188 (QQNum);
CREATE INDEX ix_QQNum_Group121 On GroupData2.dbo.Group121 (QQNum);
CREATE INDEX ix_QQNum_Group189 On GroupData2.dbo.Group189 (QQNum);
CREATE INDEX ix_QQNum_Group122 On GroupData2.dbo.Group122 (QQNum);
CREATE INDEX ix_QQNum_Group190 On GroupData2.dbo.Group190 (QQNum);
CREATE INDEX ix_QQNum_Group123 On GroupData2.dbo.Group123 (QQNum);
CREATE INDEX ix_QQNum_Group191 On GroupData2.dbo.Group191 (QQNum);
CREATE INDEX ix_QQNum_Group124 On GroupData2.dbo.Group124 (QQNum);
CREATE INDEX ix_QQNum_Group192 On GroupData2.dbo.Group192 (QQNum);
CREATE INDEX ix_QQNum_Group125 On GroupData2.dbo.Group125 (QQNum);
CREATE INDEX ix_QQNum_Group193 On GroupData2.dbo.Group193 (QQNum);
CREATE INDEX ix_QQNum_Group126 On GroupData2.dbo.Group126 (QQNum);
CREATE INDEX ix_QQNum_Group194 On GroupData2.dbo.Group194 (QQNum);
CREATE INDEX ix_QQNum_Group127 On GroupData2.dbo.Group127 (QQNum);
CREATE INDEX ix_QQNum_Group195 On GroupData2.dbo.Group195 (QQNum);
CREATE INDEX ix_QQNum_Group128 On GroupData2.dbo.Group128 (QQNum);
CREATE INDEX ix_QQNum_Group196 On GroupData2.dbo.Group196 (QQNum);
CREATE INDEX ix_QQNum_Group129 On GroupData2.dbo.Group129 (QQNum);
CREATE INDEX ix_QQNum_Group197 On GroupData2.dbo.Group197 (QQNum);
CREATE INDEX ix_QQNum_Group130 On GroupData2.dbo.Group130 (QQNum);
CREATE INDEX ix_QQNum_Group198 On GroupData2.dbo.Group198 (QQNum);
CREATE INDEX ix_QQNum_Group131 On GroupData2.dbo.Group131 (QQNum);
CREATE INDEX ix_QQNum_Group199 On GroupData2.dbo.Group199 (QQNum);
CREATE INDEX ix_QQNum_Group132 On GroupData2.dbo.Group132 (QQNum);
CREATE INDEX ix_QQNum_Group200 On GroupData2.dbo.Group200 (QQNum);
CREATE INDEX ix_QQNum_Group133 On GroupData2.dbo.Group133 (QQNum);
CREATE INDEX ix_QQNum_Group134 On GroupData2.dbo.Group134 (QQNum);
CREATE INDEX ix_QQNum_Group135 On GroupData2.dbo.Group135 (QQNum);
CREATE INDEX ix_QQNum_Group136 On GroupData2.dbo.Group136 (QQNum);
CREATE INDEX ix_QQNum_Group137 On GroupData2.dbo.Group137 (QQNum);
CREATE INDEX ix_QQNum_Group138 On GroupData2.dbo.Group138 (QQNum);
CREATE INDEX ix_QQNum_Group139 On GroupData2.dbo.Group139 (QQNum);
CREATE INDEX ix_QQNum_Group140 On GroupData2.dbo.Group140 (QQNum);
CREATE INDEX ix_QQNum_Group141 On GroupData2.dbo.Group141 (QQNum);
CREATE INDEX ix_QQNum_Group142 On GroupData2.dbo.Group142 (QQNum);
CREATE INDEX ix_QQNum_Group143 On GroupData2.dbo.Group143 (QQNum);
CREATE INDEX ix_QQNum_Group144 On GroupData2.dbo.Group144 (QQNum);
CREATE INDEX ix_QQNum_Group145 On GroupData2.dbo.Group145 (QQNum);
CREATE INDEX ix_QQNum_Group146 On GroupData2.dbo.Group146 (QQNum);
CREATE INDEX ix_QQNum_Group147 On GroupData2.dbo.Group147 (QQNum);
CREATE INDEX ix_QQNum_Group148 On GroupData2.dbo.Group148 (QQNum);
CREATE INDEX ix_QQNum_Group149 On GroupData2.dbo.Group149 (QQNum);
CREATE INDEX ix_QQNum_Group150 On GroupData2.dbo.Group150 (QQNum);
CREATE INDEX ix_QQNum_Group151 On GroupData2.dbo.Group151 (QQNum);
CREATE INDEX ix_QQNum_Group152 On GroupData2.dbo.Group152 (QQNum);
CREATE INDEX ix_QQNum_Group153 On GroupData2.dbo.Group153 (QQNum);
CREATE INDEX ix_QQNum_Group154 On GroupData2.dbo.Group154 (QQNum);
CREATE INDEX ix_QQNum_Group155 On GroupData2.dbo.Group155 (QQNum);
CREATE INDEX ix_QQNum_Group156 On GroupData2.dbo.Group156 (QQNum);
CREATE INDEX ix_QQNum_Group157 On GroupData2.dbo.Group157 (QQNum);
CREATE INDEX ix_QQNum_Group158 On GroupData2.dbo.Group158 (QQNum);
CREATE INDEX ix_QQNum_Group159 On GroupData2.dbo.Group159 (QQNum);
CREATE INDEX ix_QQNum_Group160 On GroupData2.dbo.Group160 (QQNum);
CREATE INDEX ix_QQNum_Group161 On GroupData2.dbo.Group161 (QQNum);
CREATE INDEX ix_QQNum_Group162 On GroupData2.dbo.Group162 (QQNum);
CREATE INDEX ix_QQNum_Group163 On GroupData2.dbo.Group163 (QQNum);
CREATE INDEX ix_QQNum_Group164 On GroupData2.dbo.Group164 (QQNum);
CREATE INDEX ix_QQNum_Group165 On GroupData2.dbo.Group165 (QQNum);
CREATE INDEX ix_QQNum_Group166 On GroupData2.dbo.Group166 (QQNum);
CREATE INDEX ix_QQNum_Group167 On GroupData2.dbo.Group167 (QQNum);
CREATE INDEX ix_QQNum_Group168 On GroupData2.dbo.Group168 (QQNum);
CREATE INDEX ix_QQNum_Group101 On GroupData2.dbo.Group101 (QQNum);
CREATE INDEX ix_QQNum_Group169 On GroupData2.dbo.Group169 (QQNum);
CREATE INDEX ix_QQNum_Group102 On GroupData2.dbo.Group102 (QQNum);
CREATE INDEX ix_QQNum_Group170 On GroupData2.dbo.Group170 (QQNum);
CREATE INDEX ix_QQNum_Group103 On GroupData2.dbo.Group103 (QQNum);
CREATE INDEX ix_QQNum_Group171 On GroupData2.dbo.Group171 (QQNum);
CREATE INDEX ix_QQNum_Group104 On GroupData2.dbo.Group104 (QQNum);
CREATE INDEX ix_QQNum_Group172 On GroupData2.dbo.Group172 (QQNum);
CREATE INDEX ix_QQNum_Group105 On GroupData2.dbo.Group105 (QQNum);
CREATE INDEX ix_QQNum_Group173 On GroupData2.dbo.Group173 (QQNum);
CREATE INDEX ix_QQNum_Group106 On GroupData2.dbo.Group106 (QQNum);
CREATE INDEX ix_QQNum_Group274 On GroupData3.dbo.Group274 (QQNum);
CREATE INDEX ix_QQNum_Group207 On GroupData3.dbo.Group207 (QQNum);
CREATE INDEX ix_QQNum_Group275 On GroupData3.dbo.Group275 (QQNum);
CREATE INDEX ix_QQNum_Group208 On GroupData3.dbo.Group208 (QQNum);
CREATE INDEX ix_QQNum_Group276 On GroupData3.dbo.Group276 (QQNum);
CREATE INDEX ix_QQNum_Group209 On GroupData3.dbo.Group209 (QQNum);
CREATE INDEX ix_QQNum_Group277 On GroupData3.dbo.Group277 (QQNum);
CREATE INDEX ix_QQNum_Group210 On GroupData3.dbo.Group210 (QQNum);
CREATE INDEX ix_QQNum_Group278 On GroupData3.dbo.Group278 (QQNum);
CREATE INDEX ix_QQNum_Group211 On GroupData3.dbo.Group211 (QQNum);
CREATE INDEX ix_QQNum_Group279 On GroupData3.dbo.Group279 (QQNum);
CREATE INDEX ix_QQNum_Group212 On GroupData3.dbo.Group212 (QQNum);
CREATE INDEX ix_QQNum_Group280 On GroupData3.dbo.Group280 (QQNum);
CREATE INDEX ix_QQNum_Group213 On GroupData3.dbo.Group213 (QQNum);
CREATE INDEX ix_QQNum_Group281 On GroupData3.dbo.Group281 (QQNum);
CREATE INDEX ix_QQNum_Group214 On GroupData3.dbo.Group214 (QQNum);
CREATE INDEX ix_QQNum_Group282 On GroupData3.dbo.Group282 (QQNum);
CREATE INDEX ix_QQNum_Group215 On GroupData3.dbo.Group215 (QQNum);
CREATE INDEX ix_QQNum_Group283 On GroupData3.dbo.Group283 (QQNum);
CREATE INDEX ix_QQNum_Group216 On GroupData3.dbo.Group216 (QQNum);
CREATE INDEX ix_QQNum_Group284 On GroupData3.dbo.Group284 (QQNum);
CREATE INDEX ix_QQNum_Group217 On GroupData3.dbo.Group217 (QQNum);
CREATE INDEX ix_QQNum_Group285 On GroupData3.dbo.Group285 (QQNum);
CREATE INDEX ix_QQNum_Group218 On GroupData3.dbo.Group218 (QQNum);
CREATE INDEX ix_QQNum_Group286 On GroupData3.dbo.Group286 (QQNum);
CREATE INDEX ix_QQNum_Group219 On GroupData3.dbo.Group219 (QQNum);
CREATE INDEX ix_QQNum_Group287 On GroupData3.dbo.Group287 (QQNum);
CREATE INDEX ix_QQNum_Group220 On GroupData3.dbo.Group220 (QQNum);
CREATE INDEX ix_QQNum_Group288 On GroupData3.dbo.Group288 (QQNum);
CREATE INDEX ix_QQNum_Group221 On GroupData3.dbo.Group221 (QQNum);
CREATE INDEX ix_QQNum_Group289 On GroupData3.dbo.Group289 (QQNum);
CREATE INDEX ix_QQNum_Group222 On GroupData3.dbo.Group222 (QQNum);
CREATE INDEX ix_QQNum_Group290 On GroupData3.dbo.Group290 (QQNum);
CREATE INDEX ix_QQNum_Group223 On GroupData3.dbo.Group223 (QQNum);
CREATE INDEX ix_QQNum_Group291 On GroupData3.dbo.Group291 (QQNum);
CREATE INDEX ix_QQNum_Group224 On GroupData3.dbo.Group224 (QQNum);
CREATE INDEX ix_QQNum_Group292 On GroupData3.dbo.Group292 (QQNum);
CREATE INDEX ix_QQNum_Group225 On GroupData3.dbo.Group225 (QQNum);
CREATE INDEX ix_QQNum_Group293 On GroupData3.dbo.Group293 (QQNum);
CREATE INDEX ix_QQNum_Group226 On GroupData3.dbo.Group226 (QQNum);
CREATE INDEX ix_QQNum_Group294 On GroupData3.dbo.Group294 (QQNum);
CREATE INDEX ix_QQNum_Group227 On GroupData3.dbo.Group227 (QQNum);
CREATE INDEX ix_QQNum_Group295 On GroupData3.dbo.Group295 (QQNum);
CREATE INDEX ix_QQNum_Group228 On GroupData3.dbo.Group228 (QQNum);
CREATE INDEX ix_QQNum_Group296 On GroupData3.dbo.Group296 (QQNum);
CREATE INDEX ix_QQNum_Group229 On GroupData3.dbo.Group229 (QQNum);
CREATE INDEX ix_QQNum_Group297 On GroupData3.dbo.Group297 (QQNum);
CREATE INDEX ix_QQNum_Group230 On GroupData3.dbo.Group230 (QQNum);
CREATE INDEX ix_QQNum_Group298 On GroupData3.dbo.Group298 (QQNum);
CREATE INDEX ix_QQNum_Group231 On GroupData3.dbo.Group231 (QQNum);
CREATE INDEX ix_QQNum_Group299 On GroupData3.dbo.Group299 (QQNum);
CREATE INDEX ix_QQNum_Group232 On GroupData3.dbo.Group232 (QQNum);
CREATE INDEX ix_QQNum_Group300 On GroupData3.dbo.Group300 (QQNum);
CREATE INDEX ix_QQNum_Group233 On GroupData3.dbo.Group233 (QQNum);
CREATE INDEX ix_QQNum_Group234 On GroupData3.dbo.Group234 (QQNum);
CREATE INDEX ix_QQNum_Group235 On GroupData3.dbo.Group235 (QQNum);
CREATE INDEX ix_QQNum_Group236 On GroupData3.dbo.Group236 (QQNum);
CREATE INDEX ix_QQNum_Group237 On GroupData3.dbo.Group237 (QQNum);
CREATE INDEX ix_QQNum_Group238 On GroupData3.dbo.Group238 (QQNum);
CREATE INDEX ix_QQNum_Group239 On GroupData3.dbo.Group239 (QQNum);
CREATE INDEX ix_QQNum_Group240 On GroupData3.dbo.Group240 (QQNum);
CREATE INDEX ix_QQNum_Group241 On GroupData3.dbo.Group241 (QQNum);
CREATE INDEX ix_QQNum_Group242 On GroupData3.dbo.Group242 (QQNum);
CREATE INDEX ix_QQNum_Group243 On GroupData3.dbo.Group243 (QQNum);
CREATE INDEX ix_QQNum_Group244 On GroupData3.dbo.Group244 (QQNum);
CREATE INDEX ix_QQNum_Group245 On GroupData3.dbo.Group245 (QQNum);
CREATE INDEX ix_QQNum_Group246 On GroupData3.dbo.Group246 (QQNum);
CREATE INDEX ix_QQNum_Group247 On GroupData3.dbo.Group247 (QQNum);
CREATE INDEX ix_QQNum_Group248 On GroupData3.dbo.Group248 (QQNum);
CREATE INDEX ix_QQNum_Group249 On GroupData3.dbo.Group249 (QQNum);
CREATE INDEX ix_QQNum_Group250 On GroupData3.dbo.Group250 (QQNum);
CREATE INDEX ix_QQNum_Group251 On GroupData3.dbo.Group251 (QQNum);
CREATE INDEX ix_QQNum_Group252 On GroupData3.dbo.Group252 (QQNum);
CREATE INDEX ix_QQNum_Group253 On GroupData3.dbo.Group253 (QQNum);
CREATE INDEX ix_QQNum_Group254 On GroupData3.dbo.Group254 (QQNum);
CREATE INDEX ix_QQNum_Group255 On GroupData3.dbo.Group255 (QQNum);
CREATE INDEX ix_QQNum_Group256 On GroupData3.dbo.Group256 (QQNum);
CREATE INDEX ix_QQNum_Group257 On GroupData3.dbo.Group257 (QQNum);
CREATE INDEX ix_QQNum_Group258 On GroupData3.dbo.Group258 (QQNum);
CREATE INDEX ix_QQNum_Group259 On GroupData3.dbo.Group259 (QQNum);
CREATE INDEX ix_QQNum_Group260 On GroupData3.dbo.Group260 (QQNum);
CREATE INDEX ix_QQNum_Group261 On GroupData3.dbo.Group261 (QQNum);
CREATE INDEX ix_QQNum_Group262 On GroupData3.dbo.Group262 (QQNum);
CREATE INDEX ix_QQNum_Group263 On GroupData3.dbo.Group263 (QQNum);
CREATE INDEX ix_QQNum_Group264 On GroupData3.dbo.Group264 (QQNum);
CREATE INDEX ix_QQNum_Group265 On GroupData3.dbo.Group265 (QQNum);
CREATE INDEX ix_QQNum_Group266 On GroupData3.dbo.Group266 (QQNum);
CREATE INDEX ix_QQNum_Group267 On GroupData3.dbo.Group267 (QQNum);
CREATE INDEX ix_QQNum_Group268 On GroupData3.dbo.Group268 (QQNum);
CREATE INDEX ix_QQNum_Group201 On GroupData3.dbo.Group201 (QQNum);
CREATE INDEX ix_QQNum_Group269 On GroupData3.dbo.Group269 (QQNum);
CREATE INDEX ix_QQNum_Group202 On GroupData3.dbo.Group202 (QQNum);
CREATE INDEX ix_QQNum_Group270 On GroupData3.dbo.Group270 (QQNum);
CREATE INDEX ix_QQNum_Group203 On GroupData3.dbo.Group203 (QQNum);
CREATE INDEX ix_QQNum_Group271 On GroupData3.dbo.Group271 (QQNum);
CREATE INDEX ix_QQNum_Group204 On GroupData3.dbo.Group204 (QQNum);
CREATE INDEX ix_QQNum_Group272 On GroupData3.dbo.Group272 (QQNum);
CREATE INDEX ix_QQNum_Group205 On GroupData3.dbo.Group205 (QQNum);
CREATE INDEX ix_QQNum_Group273 On GroupData3.dbo.Group273 (QQNum);
CREATE INDEX ix_QQNum_Group206 On GroupData3.dbo.Group206 (QQNum);
CREATE INDEX ix_QQNum_Group374 On GroupData4.dbo.Group374 (QQNum);
CREATE INDEX ix_QQNum_Group307 On GroupData4.dbo.Group307 (QQNum);
CREATE INDEX ix_QQNum_Group375 On GroupData4.dbo.Group375 (QQNum);
CREATE INDEX ix_QQNum_Group308 On GroupData4.dbo.Group308 (QQNum);
CREATE INDEX ix_QQNum_Group376 On GroupData4.dbo.Group376 (QQNum);
CREATE INDEX ix_QQNum_Group309 On GroupData4.dbo.Group309 (QQNum);
CREATE INDEX ix_QQNum_Group377 On GroupData4.dbo.Group377 (QQNum);
CREATE INDEX ix_QQNum_Group310 On GroupData4.dbo.Group310 (QQNum);
CREATE INDEX ix_QQNum_Group378 On GroupData4.dbo.Group378 (QQNum);
CREATE INDEX ix_QQNum_Group311 On GroupData4.dbo.Group311 (QQNum);
CREATE INDEX ix_QQNum_Group379 On GroupData4.dbo.Group379 (QQNum);
CREATE INDEX ix_QQNum_Group312 On GroupData4.dbo.Group312 (QQNum);
CREATE INDEX ix_QQNum_Group380 On GroupData4.dbo.Group380 (QQNum);
CREATE INDEX ix_QQNum_Group313 On GroupData4.dbo.Group313 (QQNum);
CREATE INDEX ix_QQNum_Group381 On GroupData4.dbo.Group381 (QQNum);
CREATE INDEX ix_QQNum_Group314 On GroupData4.dbo.Group314 (QQNum);
CREATE INDEX ix_QQNum_Group382 On GroupData4.dbo.Group382 (QQNum);
CREATE INDEX ix_QQNum_Group315 On GroupData4.dbo.Group315 (QQNum);
CREATE INDEX ix_QQNum_Group383 On GroupData4.dbo.Group383 (QQNum);
CREATE INDEX ix_QQNum_Group316 On GroupData4.dbo.Group316 (QQNum);
CREATE INDEX ix_QQNum_Group384 On GroupData4.dbo.Group384 (QQNum);
CREATE INDEX ix_QQNum_Group317 On GroupData4.dbo.Group317 (QQNum);
CREATE INDEX ix_QQNum_Group385 On GroupData4.dbo.Group385 (QQNum);
CREATE INDEX ix_QQNum_Group318 On GroupData4.dbo.Group318 (QQNum);
CREATE INDEX ix_QQNum_Group386 On GroupData4.dbo.Group386 (QQNum);
CREATE INDEX ix_QQNum_Group319 On GroupData4.dbo.Group319 (QQNum);
CREATE INDEX ix_QQNum_Group387 On GroupData4.dbo.Group387 (QQNum);
CREATE INDEX ix_QQNum_Group320 On GroupData4.dbo.Group320 (QQNum);
CREATE INDEX ix_QQNum_Group388 On GroupData4.dbo.Group388 (QQNum);
CREATE INDEX ix_QQNum_Group321 On GroupData4.dbo.Group321 (QQNum);
CREATE INDEX ix_QQNum_Group389 On GroupData4.dbo.Group389 (QQNum);
CREATE INDEX ix_QQNum_Group322 On GroupData4.dbo.Group322 (QQNum);
CREATE INDEX ix_QQNum_Group390 On GroupData4.dbo.Group390 (QQNum);
CREATE INDEX ix_QQNum_Group323 On GroupData4.dbo.Group323 (QQNum);
CREATE INDEX ix_QQNum_Group391 On GroupData4.dbo.Group391 (QQNum);
CREATE INDEX ix_QQNum_Group324 On GroupData4.dbo.Group324 (QQNum);
CREATE INDEX ix_QQNum_Group392 On GroupData4.dbo.Group392 (QQNum);
CREATE INDEX ix_QQNum_Group325 On GroupData4.dbo.Group325 (QQNum);
CREATE INDEX ix_QQNum_Group393 On GroupData4.dbo.Group393 (QQNum);
CREATE INDEX ix_QQNum_Group326 On GroupData4.dbo.Group326 (QQNum);
CREATE INDEX ix_QQNum_Group394 On GroupData4.dbo.Group394 (QQNum);
CREATE INDEX ix_QQNum_Group327 On GroupData4.dbo.Group327 (QQNum);
CREATE INDEX ix_QQNum_Group395 On GroupData4.dbo.Group395 (QQNum);
CREATE INDEX ix_QQNum_Group328 On GroupData4.dbo.Group328 (QQNum);
CREATE INDEX ix_QQNum_Group396 On GroupData4.dbo.Group396 (QQNum);
CREATE INDEX ix_QQNum_Group329 On GroupData4.dbo.Group329 (QQNum);
CREATE INDEX ix_QQNum_Group397 On GroupData4.dbo.Group397 (QQNum);
CREATE INDEX ix_QQNum_Group330 On GroupData4.dbo.Group330 (QQNum);
CREATE INDEX ix_QQNum_Group398 On GroupData4.dbo.Group398 (QQNum);
CREATE INDEX ix_QQNum_Group331 On GroupData4.dbo.Group331 (QQNum);
CREATE INDEX ix_QQNum_Group399 On GroupData4.dbo.Group399 (QQNum);
CREATE INDEX ix_QQNum_Group332 On GroupData4.dbo.Group332 (QQNum);
CREATE INDEX ix_QQNum_Group400 On GroupData4.dbo.Group400 (QQNum);
CREATE INDEX ix_QQNum_Group333 On GroupData4.dbo.Group333 (QQNum);
CREATE INDEX ix_QQNum_Group334 On GroupData4.dbo.Group334 (QQNum);
CREATE INDEX ix_QQNum_Group335 On GroupData4.dbo.Group335 (QQNum);
CREATE INDEX ix_QQNum_Group336 On GroupData4.dbo.Group336 (QQNum);
CREATE INDEX ix_QQNum_Group337 On GroupData4.dbo.Group337 (QQNum);
CREATE INDEX ix_QQNum_Group338 On GroupData4.dbo.Group338 (QQNum);
CREATE INDEX ix_QQNum_Group339 On GroupData4.dbo.Group339 (QQNum);
CREATE INDEX ix_QQNum_Group340 On GroupData4.dbo.Group340 (QQNum);
CREATE INDEX ix_QQNum_Group341 On GroupData4.dbo.Group341 (QQNum);
CREATE INDEX ix_QQNum_Group342 On GroupData4.dbo.Group342 (QQNum);
CREATE INDEX ix_QQNum_Group343 On GroupData4.dbo.Group343 (QQNum);
CREATE INDEX ix_QQNum_Group344 On GroupData4.dbo.Group344 (QQNum);
CREATE INDEX ix_QQNum_Group345 On GroupData4.dbo.Group345 (QQNum);
CREATE INDEX ix_QQNum_Group346 On GroupData4.dbo.Group346 (QQNum);
CREATE INDEX ix_QQNum_Group347 On GroupData4.dbo.Group347 (QQNum);
CREATE INDEX ix_QQNum_Group348 On GroupData4.dbo.Group348 (QQNum);
CREATE INDEX ix_QQNum_Group349 On GroupData4.dbo.Group349 (QQNum);
CREATE INDEX ix_QQNum_Group350 On GroupData4.dbo.Group350 (QQNum);
CREATE INDEX ix_QQNum_Group351 On GroupData4.dbo.Group351 (QQNum);
CREATE INDEX ix_QQNum_Group352 On GroupData4.dbo.Group352 (QQNum);
CREATE INDEX ix_QQNum_Group353 On GroupData4.dbo.Group353 (QQNum);
CREATE INDEX ix_QQNum_Group354 On GroupData4.dbo.Group354 (QQNum);
CREATE INDEX ix_QQNum_Group355 On GroupData4.dbo.Group355 (QQNum);
CREATE INDEX ix_QQNum_Group356 On GroupData4.dbo.Group356 (QQNum);
CREATE INDEX ix_QQNum_Group357 On GroupData4.dbo.Group357 (QQNum);
CREATE INDEX ix_QQNum_Group358 On GroupData4.dbo.Group358 (QQNum);
CREATE INDEX ix_QQNum_Group359 On GroupData4.dbo.Group359 (QQNum);
CREATE INDEX ix_QQNum_Group360 On GroupData4.dbo.Group360 (QQNum);
CREATE INDEX ix_QQNum_Group361 On GroupData4.dbo.Group361 (QQNum);
CREATE INDEX ix_QQNum_Group362 On GroupData4.dbo.Group362 (QQNum);
CREATE INDEX ix_QQNum_Group363 On GroupData4.dbo.Group363 (QQNum);
CREATE INDEX ix_QQNum_Group364 On GroupData4.dbo.Group364 (QQNum);
CREATE INDEX ix_QQNum_Group365 On GroupData4.dbo.Group365 (QQNum);
CREATE INDEX ix_QQNum_Group366 On GroupData4.dbo.Group366 (QQNum);
CREATE INDEX ix_QQNum_Group367 On GroupData4.dbo.Group367 (QQNum);
CREATE INDEX ix_QQNum_Group368 On GroupData4.dbo.Group368 (QQNum);
CREATE INDEX ix_QQNum_Group301 On GroupData4.dbo.Group301 (QQNum);
CREATE INDEX ix_QQNum_Group369 On GroupData4.dbo.Group369 (QQNum);
CREATE INDEX ix_QQNum_Group302 On GroupData4.dbo.Group302 (QQNum);
CREATE INDEX ix_QQNum_Group370 On GroupData4.dbo.Group370 (QQNum);
CREATE INDEX ix_QQNum_Group303 On GroupData4.dbo.Group303 (QQNum);
CREATE INDEX ix_QQNum_Group371 On GroupData4.dbo.Group371 (QQNum);
CREATE INDEX ix_QQNum_Group304 On GroupData4.dbo.Group304 (QQNum);
CREATE INDEX ix_QQNum_Group372 On GroupData4.dbo.Group372 (QQNum);
CREATE INDEX ix_QQNum_Group305 On GroupData4.dbo.Group305 (QQNum);
CREATE INDEX ix_QQNum_Group373 On GroupData4.dbo.Group373 (QQNum);
CREATE INDEX ix_QQNum_Group306 On GroupData4.dbo.Group306 (QQNum);
CREATE INDEX ix_QQNum_Group474 On GroupData5.dbo.Group474 (QQNum);
CREATE INDEX ix_QQNum_Group407 On GroupData5.dbo.Group407 (QQNum);
CREATE INDEX ix_QQNum_Group475 On GroupData5.dbo.Group475 (QQNum);
CREATE INDEX ix_QQNum_Group408 On GroupData5.dbo.Group408 (QQNum);
CREATE INDEX ix_QQNum_Group476 On GroupData5.dbo.Group476 (QQNum);
CREATE INDEX ix_QQNum_Group409 On GroupData5.dbo.Group409 (QQNum);
CREATE INDEX ix_QQNum_Group477 On GroupData5.dbo.Group477 (QQNum);
CREATE INDEX ix_QQNum_Group410 On GroupData5.dbo.Group410 (QQNum);
CREATE INDEX ix_QQNum_Group478 On GroupData5.dbo.Group478 (QQNum);
CREATE INDEX ix_QQNum_Group411 On GroupData5.dbo.Group411 (QQNum);
CREATE INDEX ix_QQNum_Group479 On GroupData5.dbo.Group479 (QQNum);
CREATE INDEX ix_QQNum_Group412 On GroupData5.dbo.Group412 (QQNum);
CREATE INDEX ix_QQNum_Group480 On GroupData5.dbo.Group480 (QQNum);
CREATE INDEX ix_QQNum_Group413 On GroupData5.dbo.Group413 (QQNum);
CREATE INDEX ix_QQNum_Group481 On GroupData5.dbo.Group481 (QQNum);
CREATE INDEX ix_QQNum_Group414 On GroupData5.dbo.Group414 (QQNum);
CREATE INDEX ix_QQNum_Group482 On GroupData5.dbo.Group482 (QQNum);
CREATE INDEX ix_QQNum_Group415 On GroupData5.dbo.Group415 (QQNum);
CREATE INDEX ix_QQNum_Group483 On GroupData5.dbo.Group483 (QQNum);
CREATE INDEX ix_QQNum_Group416 On GroupData5.dbo.Group416 (QQNum);
CREATE INDEX ix_QQNum_Group484 On GroupData5.dbo.Group484 (QQNum);
CREATE INDEX ix_QQNum_Group417 On GroupData5.dbo.Group417 (QQNum);
CREATE INDEX ix_QQNum_Group485 On GroupData5.dbo.Group485 (QQNum);
CREATE INDEX ix_QQNum_Group418 On GroupData5.dbo.Group418 (QQNum);
CREATE INDEX ix_QQNum_Group486 On GroupData5.dbo.Group486 (QQNum);
CREATE INDEX ix_QQNum_Group419 On GroupData5.dbo.Group419 (QQNum);
CREATE INDEX ix_QQNum_Group487 On GroupData5.dbo.Group487 (QQNum);
CREATE INDEX ix_QQNum_Group420 On GroupData5.dbo.Group420 (QQNum);
CREATE INDEX ix_QQNum_Group488 On GroupData5.dbo.Group488 (QQNum);
CREATE INDEX ix_QQNum_Group421 On GroupData5.dbo.Group421 (QQNum);
CREATE INDEX ix_QQNum_Group489 On GroupData5.dbo.Group489 (QQNum);
CREATE INDEX ix_QQNum_Group422 On GroupData5.dbo.Group422 (QQNum);
CREATE INDEX ix_QQNum_Group490 On GroupData5.dbo.Group490 (QQNum);
CREATE INDEX ix_QQNum_Group423 On GroupData5.dbo.Group423 (QQNum);
CREATE INDEX ix_QQNum_Group491 On GroupData5.dbo.Group491 (QQNum);
CREATE INDEX ix_QQNum_Group424 On GroupData5.dbo.Group424 (QQNum);
CREATE INDEX ix_QQNum_Group492 On GroupData5.dbo.Group492 (QQNum);
CREATE INDEX ix_QQNum_Group425 On GroupData5.dbo.Group425 (QQNum);
CREATE INDEX ix_QQNum_Group493 On GroupData5.dbo.Group493 (QQNum);
CREATE INDEX ix_QQNum_Group426 On GroupData5.dbo.Group426 (QQNum);
CREATE INDEX ix_QQNum_Group494 On GroupData5.dbo.Group494 (QQNum);
CREATE INDEX ix_QQNum_Group427 On GroupData5.dbo.Group427 (QQNum);
CREATE INDEX ix_QQNum_Group495 On GroupData5.dbo.Group495 (QQNum);
CREATE INDEX ix_QQNum_Group428 On GroupData5.dbo.Group428 (QQNum);
CREATE INDEX ix_QQNum_Group496 On GroupData5.dbo.Group496 (QQNum);
CREATE INDEX ix_QQNum_Group429 On GroupData5.dbo.Group429 (QQNum);
CREATE INDEX ix_QQNum_Group497 On GroupData5.dbo.Group497 (QQNum);
CREATE INDEX ix_QQNum_Group430 On GroupData5.dbo.Group430 (QQNum);
CREATE INDEX ix_QQNum_Group498 On GroupData5.dbo.Group498 (QQNum);
CREATE INDEX ix_QQNum_Group431 On GroupData5.dbo.Group431 (QQNum);
CREATE INDEX ix_QQNum_Group499 On GroupData5.dbo.Group499 (QQNum);
CREATE INDEX ix_QQNum_Group432 On GroupData5.dbo.Group432 (QQNum);
CREATE INDEX ix_QQNum_Group500 On GroupData5.dbo.Group500 (QQNum);
CREATE INDEX ix_QQNum_Group433 On GroupData5.dbo.Group433 (QQNum);
CREATE INDEX ix_QQNum_Group434 On GroupData5.dbo.Group434 (QQNum);
CREATE INDEX ix_QQNum_Group435 On GroupData5.dbo.Group435 (QQNum);
CREATE INDEX ix_QQNum_Group436 On GroupData5.dbo.Group436 (QQNum);
CREATE INDEX ix_QQNum_Group437 On GroupData5.dbo.Group437 (QQNum);
CREATE INDEX ix_QQNum_Group438 On GroupData5.dbo.Group438 (QQNum);
CREATE INDEX ix_QQNum_Group439 On GroupData5.dbo.Group439 (QQNum);
CREATE INDEX ix_QQNum_Group440 On GroupData5.dbo.Group440 (QQNum);
CREATE INDEX ix_QQNum_Group441 On GroupData5.dbo.Group441 (QQNum);
CREATE INDEX ix_QQNum_Group442 On GroupData5.dbo.Group442 (QQNum);
CREATE INDEX ix_QQNum_Group443 On GroupData5.dbo.Group443 (QQNum);
CREATE INDEX ix_QQNum_Group444 On GroupData5.dbo.Group444 (QQNum);
CREATE INDEX ix_QQNum_Group445 On GroupData5.dbo.Group445 (QQNum);
CREATE INDEX ix_QQNum_Group446 On GroupData5.dbo.Group446 (QQNum);
CREATE INDEX ix_QQNum_Group447 On GroupData5.dbo.Group447 (QQNum);
CREATE INDEX ix_QQNum_Group448 On GroupData5.dbo.Group448 (QQNum);
CREATE INDEX ix_QQNum_Group449 On GroupData5.dbo.Group449 (QQNum);
CREATE INDEX ix_QQNum_Group450 On GroupData5.dbo.Group450 (QQNum);
CREATE INDEX ix_QQNum_Group451 On GroupData5.dbo.Group451 (QQNum);
CREATE INDEX ix_QQNum_Group452 On GroupData5.dbo.Group452 (QQNum);
CREATE INDEX ix_QQNum_Group453 On GroupData5.dbo.Group453 (QQNum);
CREATE INDEX ix_QQNum_Group454 On GroupData5.dbo.Group454 (QQNum);
CREATE INDEX ix_QQNum_Group455 On GroupData5.dbo.Group455 (QQNum);
CREATE INDEX ix_QQNum_Group456 On GroupData5.dbo.Group456 (QQNum);
CREATE INDEX ix_QQNum_Group457 On GroupData5.dbo.Group457 (QQNum);
CREATE INDEX ix_QQNum_Group458 On GroupData5.dbo.Group458 (QQNum);
CREATE INDEX ix_QQNum_Group459 On GroupData5.dbo.Group459 (QQNum);
CREATE INDEX ix_QQNum_Group460 On GroupData5.dbo.Group460 (QQNum);
CREATE INDEX ix_QQNum_Group461 On GroupData5.dbo.Group461 (QQNum);
CREATE INDEX ix_QQNum_Group462 On GroupData5.dbo.Group462 (QQNum);
CREATE INDEX ix_QQNum_Group463 On GroupData5.dbo.Group463 (QQNum);
CREATE INDEX ix_QQNum_Group464 On GroupData5.dbo.Group464 (QQNum);
CREATE INDEX ix_QQNum_Group465 On GroupData5.dbo.Group465 (QQNum);
CREATE INDEX ix_QQNum_Group466 On GroupData5.dbo.Group466 (QQNum);
CREATE INDEX ix_QQNum_Group467 On GroupData5.dbo.Group467 (QQNum);
CREATE INDEX ix_QQNum_Group468 On GroupData5.dbo.Group468 (QQNum);
CREATE INDEX ix_QQNum_Group401 On GroupData5.dbo.Group401 (QQNum);
CREATE INDEX ix_QQNum_Group469 On GroupData5.dbo.Group469 (QQNum);
CREATE INDEX ix_QQNum_Group402 On GroupData5.dbo.Group402 (QQNum);
CREATE INDEX ix_QQNum_Group470 On GroupData5.dbo.Group470 (QQNum);
CREATE INDEX ix_QQNum_Group403 On GroupData5.dbo.Group403 (QQNum);
CREATE INDEX ix_QQNum_Group471 On GroupData5.dbo.Group471 (QQNum);
CREATE INDEX ix_QQNum_Group404 On GroupData5.dbo.Group404 (QQNum);
CREATE INDEX ix_QQNum_Group472 On GroupData5.dbo.Group472 (QQNum);
CREATE INDEX ix_QQNum_Group405 On GroupData5.dbo.Group405 (QQNum);
CREATE INDEX ix_QQNum_Group473 On GroupData5.dbo.Group473 (QQNum);
CREATE INDEX ix_QQNum_Group406 On GroupData5.dbo.Group406 (QQNum);
CREATE INDEX ix_QQNum_Group574 On GroupData6.dbo.Group574 (QQNum);
CREATE INDEX ix_QQNum_Group507 On GroupData6.dbo.Group507 (QQNum);
CREATE INDEX ix_QQNum_Group575 On GroupData6.dbo.Group575 (QQNum);
CREATE INDEX ix_QQNum_Group508 On GroupData6.dbo.Group508 (QQNum);
CREATE INDEX ix_QQNum_Group576 On GroupData6.dbo.Group576 (QQNum);
CREATE INDEX ix_QQNum_Group509 On GroupData6.dbo.Group509 (QQNum);
CREATE INDEX ix_QQNum_Group577 On GroupData6.dbo.Group577 (QQNum);
CREATE INDEX ix_QQNum_Group510 On GroupData6.dbo.Group510 (QQNum);
CREATE INDEX ix_QQNum_Group578 On GroupData6.dbo.Group578 (QQNum);
CREATE INDEX ix_QQNum_Group511 On GroupData6.dbo.Group511 (QQNum);
CREATE INDEX ix_QQNum_Group579 On GroupData6.dbo.Group579 (QQNum);
CREATE INDEX ix_QQNum_Group512 On GroupData6.dbo.Group512 (QQNum);
CREATE INDEX ix_QQNum_Group580 On GroupData6.dbo.Group580 (QQNum);
CREATE INDEX ix_QQNum_Group513 On GroupData6.dbo.Group513 (QQNum);
CREATE INDEX ix_QQNum_Group581 On GroupData6.dbo.Group581 (QQNum);
CREATE INDEX ix_QQNum_Group514 On GroupData6.dbo.Group514 (QQNum);
CREATE INDEX ix_QQNum_Group582 On GroupData6.dbo.Group582 (QQNum);
CREATE INDEX ix_QQNum_Group515 On GroupData6.dbo.Group515 (QQNum);
CREATE INDEX ix_QQNum_Group583 On GroupData6.dbo.Group583 (QQNum);
CREATE INDEX ix_QQNum_Group516 On GroupData6.dbo.Group516 (QQNum);
CREATE INDEX ix_QQNum_Group584 On GroupData6.dbo.Group584 (QQNum);
CREATE INDEX ix_QQNum_Group517 On GroupData6.dbo.Group517 (QQNum);
CREATE INDEX ix_QQNum_Group585 On GroupData6.dbo.Group585 (QQNum);
CREATE INDEX ix_QQNum_Group518 On GroupData6.dbo.Group518 (QQNum);
CREATE INDEX ix_QQNum_Group586 On GroupData6.dbo.Group586 (QQNum);
CREATE INDEX ix_QQNum_Group519 On GroupData6.dbo.Group519 (QQNum);
CREATE INDEX ix_QQNum_Group587 On GroupData6.dbo.Group587 (QQNum);
CREATE INDEX ix_QQNum_Group520 On GroupData6.dbo.Group520 (QQNum);
CREATE INDEX ix_QQNum_Group588 On GroupData6.dbo.Group588 (QQNum);
CREATE INDEX ix_QQNum_Group521 On GroupData6.dbo.Group521 (QQNum);
CREATE INDEX ix_QQNum_Group589 On GroupData6.dbo.Group589 (QQNum);
CREATE INDEX ix_QQNum_Group522 On GroupData6.dbo.Group522 (QQNum);
CREATE INDEX ix_QQNum_Group590 On GroupData6.dbo.Group590 (QQNum);
CREATE INDEX ix_QQNum_Group523 On GroupData6.dbo.Group523 (QQNum);
CREATE INDEX ix_QQNum_Group591 On GroupData6.dbo.Group591 (QQNum);
CREATE INDEX ix_QQNum_Group524 On GroupData6.dbo.Group524 (QQNum);
CREATE INDEX ix_QQNum_Group592 On GroupData6.dbo.Group592 (QQNum);
CREATE INDEX ix_QQNum_Group525 On GroupData6.dbo.Group525 (QQNum);
CREATE INDEX ix_QQNum_Group593 On GroupData6.dbo.Group593 (QQNum);
CREATE INDEX ix_QQNum_Group526 On GroupData6.dbo.Group526 (QQNum);
CREATE INDEX ix_QQNum_Group594 On GroupData6.dbo.Group594 (QQNum);
CREATE INDEX ix_QQNum_Group527 On GroupData6.dbo.Group527 (QQNum);
CREATE INDEX ix_QQNum_Group595 On GroupData6.dbo.Group595 (QQNum);
CREATE INDEX ix_QQNum_Group528 On GroupData6.dbo.Group528 (QQNum);
CREATE INDEX ix_QQNum_Group596 On GroupData6.dbo.Group596 (QQNum);
CREATE INDEX ix_QQNum_Group529 On GroupData6.dbo.Group529 (QQNum);
CREATE INDEX ix_QQNum_Group597 On GroupData6.dbo.Group597 (QQNum);
CREATE INDEX ix_QQNum_Group530 On GroupData6.dbo.Group530 (QQNum);
CREATE INDEX ix_QQNum_Group598 On GroupData6.dbo.Group598 (QQNum);
CREATE INDEX ix_QQNum_Group531 On GroupData6.dbo.Group531 (QQNum);
CREATE INDEX ix_QQNum_Group599 On GroupData6.dbo.Group599 (QQNum);
CREATE INDEX ix_QQNum_Group532 On GroupData6.dbo.Group532 (QQNum);
CREATE INDEX ix_QQNum_Group600 On GroupData6.dbo.Group600 (QQNum);
CREATE INDEX ix_QQNum_Group533 On GroupData6.dbo.Group533 (QQNum);
CREATE INDEX ix_QQNum_Group534 On GroupData6.dbo.Group534 (QQNum);
CREATE INDEX ix_QQNum_Group535 On GroupData6.dbo.Group535 (QQNum);
CREATE INDEX ix_QQNum_Group536 On GroupData6.dbo.Group536 (QQNum);
CREATE INDEX ix_QQNum_Group537 On GroupData6.dbo.Group537 (QQNum);
CREATE INDEX ix_QQNum_Group538 On GroupData6.dbo.Group538 (QQNum);
CREATE INDEX ix_QQNum_Group539 On GroupData6.dbo.Group539 (QQNum);
CREATE INDEX ix_QQNum_Group540 On GroupData6.dbo.Group540 (QQNum);
CREATE INDEX ix_QQNum_Group541 On GroupData6.dbo.Group541 (QQNum);
CREATE INDEX ix_QQNum_Group542 On GroupData6.dbo.Group542 (QQNum);
CREATE INDEX ix_QQNum_Group543 On GroupData6.dbo.Group543 (QQNum);
CREATE INDEX ix_QQNum_Group544 On GroupData6.dbo.Group544 (QQNum);
CREATE INDEX ix_QQNum_Group545 On GroupData6.dbo.Group545 (QQNum);
CREATE INDEX ix_QQNum_Group546 On GroupData6.dbo.Group546 (QQNum);
CREATE INDEX ix_QQNum_Group547 On GroupData6.dbo.Group547 (QQNum);
CREATE INDEX ix_QQNum_Group548 On GroupData6.dbo.Group548 (QQNum);
CREATE INDEX ix_QQNum_Group549 On GroupData6.dbo.Group549 (QQNum);
CREATE INDEX ix_QQNum_Group550 On GroupData6.dbo.Group550 (QQNum);
CREATE INDEX ix_QQNum_Group551 On GroupData6.dbo.Group551 (QQNum);
CREATE INDEX ix_QQNum_Group552 On GroupData6.dbo.Group552 (QQNum);
CREATE INDEX ix_QQNum_Group553 On GroupData6.dbo.Group553 (QQNum);
CREATE INDEX ix_QQNum_Group554 On GroupData6.dbo.Group554 (QQNum);
CREATE INDEX ix_QQNum_Group555 On GroupData6.dbo.Group555 (QQNum);
CREATE INDEX ix_QQNum_Group556 On GroupData6.dbo.Group556 (QQNum);
CREATE INDEX ix_QQNum_Group557 On GroupData6.dbo.Group557 (QQNum);
CREATE INDEX ix_QQNum_Group558 On GroupData6.dbo.Group558 (QQNum);
CREATE INDEX ix_QQNum_Group559 On GroupData6.dbo.Group559 (QQNum);
CREATE INDEX ix_QQNum_Group560 On GroupData6.dbo.Group560 (QQNum);
CREATE INDEX ix_QQNum_Group561 On GroupData6.dbo.Group561 (QQNum);
CREATE INDEX ix_QQNum_Group562 On GroupData6.dbo.Group562 (QQNum);
CREATE INDEX ix_QQNum_Group563 On GroupData6.dbo.Group563 (QQNum);
CREATE INDEX ix_QQNum_Group564 On GroupData6.dbo.Group564 (QQNum);
CREATE INDEX ix_QQNum_Group565 On GroupData6.dbo.Group565 (QQNum);
CREATE INDEX ix_QQNum_Group566 On GroupData6.dbo.Group566 (QQNum);
CREATE INDEX ix_QQNum_Group567 On GroupData6.dbo.Group567 (QQNum);
CREATE INDEX ix_QQNum_Group568 On GroupData6.dbo.Group568 (QQNum);
CREATE INDEX ix_QQNum_Group501 On GroupData6.dbo.Group501 (QQNum);
CREATE INDEX ix_QQNum_Group569 On GroupData6.dbo.Group569 (QQNum);
CREATE INDEX ix_QQNum_Group502 On GroupData6.dbo.Group502 (QQNum);
CREATE INDEX ix_QQNum_Group570 On GroupData6.dbo.Group570 (QQNum);
CREATE INDEX ix_QQNum_Group503 On GroupData6.dbo.Group503 (QQNum);
CREATE INDEX ix_QQNum_Group571 On GroupData6.dbo.Group571 (QQNum);
CREATE INDEX ix_QQNum_Group504 On GroupData6.dbo.Group504 (QQNum);
CREATE INDEX ix_QQNum_Group572 On GroupData6.dbo.Group572 (QQNum);
CREATE INDEX ix_QQNum_Group505 On GroupData6.dbo.Group505 (QQNum);
CREATE INDEX ix_QQNum_Group573 On GroupData6.dbo.Group573 (QQNum);
CREATE INDEX ix_QQNum_Group506 On GroupData6.dbo.Group506 (QQNum);
CREATE INDEX ix_QQNum_Group674 On GroupData7.dbo.Group674 (QQNum);
CREATE INDEX ix_QQNum_Group607 On GroupData7.dbo.Group607 (QQNum);
CREATE INDEX ix_QQNum_Group675 On GroupData7.dbo.Group675 (QQNum);
CREATE INDEX ix_QQNum_Group608 On GroupData7.dbo.Group608 (QQNum);
CREATE INDEX ix_QQNum_Group676 On GroupData7.dbo.Group676 (QQNum);
CREATE INDEX ix_QQNum_Group609 On GroupData7.dbo.Group609 (QQNum);
CREATE INDEX ix_QQNum_Group677 On GroupData7.dbo.Group677 (QQNum);
CREATE INDEX ix_QQNum_Group610 On GroupData7.dbo.Group610 (QQNum);
CREATE INDEX ix_QQNum_Group678 On GroupData7.dbo.Group678 (QQNum);
CREATE INDEX ix_QQNum_Group611 On GroupData7.dbo.Group611 (QQNum);
CREATE INDEX ix_QQNum_Group679 On GroupData7.dbo.Group679 (QQNum);
CREATE INDEX ix_QQNum_Group612 On GroupData7.dbo.Group612 (QQNum);
CREATE INDEX ix_QQNum_Group680 On GroupData7.dbo.Group680 (QQNum);
CREATE INDEX ix_QQNum_Group613 On GroupData7.dbo.Group613 (QQNum);
CREATE INDEX ix_QQNum_Group681 On GroupData7.dbo.Group681 (QQNum);
CREATE INDEX ix_QQNum_Group614 On GroupData7.dbo.Group614 (QQNum);
CREATE INDEX ix_QQNum_Group682 On GroupData7.dbo.Group682 (QQNum);
CREATE INDEX ix_QQNum_Group615 On GroupData7.dbo.Group615 (QQNum);
CREATE INDEX ix_QQNum_Group683 On GroupData7.dbo.Group683 (QQNum);
CREATE INDEX ix_QQNum_Group616 On GroupData7.dbo.Group616 (QQNum);
CREATE INDEX ix_QQNum_Group684 On GroupData7.dbo.Group684 (QQNum);
CREATE INDEX ix_QQNum_Group617 On GroupData7.dbo.Group617 (QQNum);
CREATE INDEX ix_QQNum_Group685 On GroupData7.dbo.Group685 (QQNum);
CREATE INDEX ix_QQNum_Group618 On GroupData7.dbo.Group618 (QQNum);
CREATE INDEX ix_QQNum_Group686 On GroupData7.dbo.Group686 (QQNum);
CREATE INDEX ix_QQNum_Group619 On GroupData7.dbo.Group619 (QQNum);
CREATE INDEX ix_QQNum_Group687 On GroupData7.dbo.Group687 (QQNum);
CREATE INDEX ix_QQNum_Group620 On GroupData7.dbo.Group620 (QQNum);
CREATE INDEX ix_QQNum_Group688 On GroupData7.dbo.Group688 (QQNum);
CREATE INDEX ix_QQNum_Group621 On GroupData7.dbo.Group621 (QQNum);
CREATE INDEX ix_QQNum_Group689 On GroupData7.dbo.Group689 (QQNum);
CREATE INDEX ix_QQNum_Group622 On GroupData7.dbo.Group622 (QQNum);
CREATE INDEX ix_QQNum_Group690 On GroupData7.dbo.Group690 (QQNum);
CREATE INDEX ix_QQNum_Group623 On GroupData7.dbo.Group623 (QQNum);
CREATE INDEX ix_QQNum_Group691 On GroupData7.dbo.Group691 (QQNum);
CREATE INDEX ix_QQNum_Group624 On GroupData7.dbo.Group624 (QQNum);
CREATE INDEX ix_QQNum_Group692 On GroupData7.dbo.Group692 (QQNum);
CREATE INDEX ix_QQNum_Group625 On GroupData7.dbo.Group625 (QQNum);
CREATE INDEX ix_QQNum_Group693 On GroupData7.dbo.Group693 (QQNum);
CREATE INDEX ix_QQNum_Group626 On GroupData7.dbo.Group626 (QQNum);
CREATE INDEX ix_QQNum_Group694 On GroupData7.dbo.Group694 (QQNum);
CREATE INDEX ix_QQNum_Group627 On GroupData7.dbo.Group627 (QQNum);
CREATE INDEX ix_QQNum_Group695 On GroupData7.dbo.Group695 (QQNum);
CREATE INDEX ix_QQNum_Group628 On GroupData7.dbo.Group628 (QQNum);
CREATE INDEX ix_QQNum_Group696 On GroupData7.dbo.Group696 (QQNum);
CREATE INDEX ix_QQNum_Group629 On GroupData7.dbo.Group629 (QQNum);
CREATE INDEX ix_QQNum_Group697 On GroupData7.dbo.Group697 (QQNum);
CREATE INDEX ix_QQNum_Group630 On GroupData7.dbo.Group630 (QQNum);
CREATE INDEX ix_QQNum_Group698 On GroupData7.dbo.Group698 (QQNum);
CREATE INDEX ix_QQNum_Group631 On GroupData7.dbo.Group631 (QQNum);
CREATE INDEX ix_QQNum_Group699 On GroupData7.dbo.Group699 (QQNum);
CREATE INDEX ix_QQNum_Group632 On GroupData7.dbo.Group632 (QQNum);
CREATE INDEX ix_QQNum_Group700 On GroupData7.dbo.Group700 (QQNum);
CREATE INDEX ix_QQNum_Group633 On GroupData7.dbo.Group633 (QQNum);
CREATE INDEX ix_QQNum_Group634 On GroupData7.dbo.Group634 (QQNum);
CREATE INDEX ix_QQNum_Group635 On GroupData7.dbo.Group635 (QQNum);
CREATE INDEX ix_QQNum_Group636 On GroupData7.dbo.Group636 (QQNum);
CREATE INDEX ix_QQNum_Group637 On GroupData7.dbo.Group637 (QQNum);
CREATE INDEX ix_QQNum_Group638 On GroupData7.dbo.Group638 (QQNum);
CREATE INDEX ix_QQNum_Group639 On GroupData7.dbo.Group639 (QQNum);
CREATE INDEX ix_QQNum_Group640 On GroupData7.dbo.Group640 (QQNum);
CREATE INDEX ix_QQNum_Group641 On GroupData7.dbo.Group641 (QQNum);
CREATE INDEX ix_QQNum_Group642 On GroupData7.dbo.Group642 (QQNum);
CREATE INDEX ix_QQNum_Group643 On GroupData7.dbo.Group643 (QQNum);
CREATE INDEX ix_QQNum_Group644 On GroupData7.dbo.Group644 (QQNum);
CREATE INDEX ix_QQNum_Group645 On GroupData7.dbo.Group645 (QQNum);
CREATE INDEX ix_QQNum_Group646 On GroupData7.dbo.Group646 (QQNum);
CREATE INDEX ix_QQNum_Group647 On GroupData7.dbo.Group647 (QQNum);
CREATE INDEX ix_QQNum_Group648 On GroupData7.dbo.Group648 (QQNum);
CREATE INDEX ix_QQNum_Group649 On GroupData7.dbo.Group649 (QQNum);
CREATE INDEX ix_QQNum_Group650 On GroupData7.dbo.Group650 (QQNum);
CREATE INDEX ix_QQNum_Group651 On GroupData7.dbo.Group651 (QQNum);
CREATE INDEX ix_QQNum_Group652 On GroupData7.dbo.Group652 (QQNum);
CREATE INDEX ix_QQNum_Group653 On GroupData7.dbo.Group653 (QQNum);
CREATE INDEX ix_QQNum_Group654 On GroupData7.dbo.Group654 (QQNum);
CREATE INDEX ix_QQNum_Group655 On GroupData7.dbo.Group655 (QQNum);
CREATE INDEX ix_QQNum_Group656 On GroupData7.dbo.Group656 (QQNum);
CREATE INDEX ix_QQNum_Group657 On GroupData7.dbo.Group657 (QQNum);
CREATE INDEX ix_QQNum_Group658 On GroupData7.dbo.Group658 (QQNum);
CREATE INDEX ix_QQNum_Group659 On GroupData7.dbo.Group659 (QQNum);
CREATE INDEX ix_QQNum_Group660 On GroupData7.dbo.Group660 (QQNum);
CREATE INDEX ix_QQNum_Group661 On GroupData7.dbo.Group661 (QQNum);
CREATE INDEX ix_QQNum_Group662 On GroupData7.dbo.Group662 (QQNum);
CREATE INDEX ix_QQNum_Group663 On GroupData7.dbo.Group663 (QQNum);
CREATE INDEX ix_QQNum_Group664 On GroupData7.dbo.Group664 (QQNum);
CREATE INDEX ix_QQNum_Group665 On GroupData7.dbo.Group665 (QQNum);
CREATE INDEX ix_QQNum_Group666 On GroupData7.dbo.Group666 (QQNum);
CREATE INDEX ix_QQNum_Group667 On GroupData7.dbo.Group667 (QQNum);
CREATE INDEX ix_QQNum_Group668 On GroupData7.dbo.Group668 (QQNum);
CREATE INDEX ix_QQNum_Group601 On GroupData7.dbo.Group601 (QQNum);
CREATE INDEX ix_QQNum_Group669 On GroupData7.dbo.Group669 (QQNum);
CREATE INDEX ix_QQNum_Group602 On GroupData7.dbo.Group602 (QQNum);
CREATE INDEX ix_QQNum_Group670 On GroupData7.dbo.Group670 (QQNum);
CREATE INDEX ix_QQNum_Group603 On GroupData7.dbo.Group603 (QQNum);
CREATE INDEX ix_QQNum_Group671 On GroupData7.dbo.Group671 (QQNum);
CREATE INDEX ix_QQNum_Group604 On GroupData7.dbo.Group604 (QQNum);
CREATE INDEX ix_QQNum_Group672 On GroupData7.dbo.Group672 (QQNum);
CREATE INDEX ix_QQNum_Group605 On GroupData7.dbo.Group605 (QQNum);
CREATE INDEX ix_QQNum_Group673 On GroupData7.dbo.Group673 (QQNum);
CREATE INDEX ix_QQNum_Group606 On GroupData7.dbo.Group606 (QQNum);
CREATE INDEX ix_QQNum_Group774 On GroupData8.dbo.Group774 (QQNum);
CREATE INDEX ix_QQNum_Group707 On GroupData8.dbo.Group707 (QQNum);
CREATE INDEX ix_QQNum_Group775 On GroupData8.dbo.Group775 (QQNum);
CREATE INDEX ix_QQNum_Group708 On GroupData8.dbo.Group708 (QQNum);
CREATE INDEX ix_QQNum_Group776 On GroupData8.dbo.Group776 (QQNum);
CREATE INDEX ix_QQNum_Group709 On GroupData8.dbo.Group709 (QQNum);
CREATE INDEX ix_QQNum_Group777 On GroupData8.dbo.Group777 (QQNum);
CREATE INDEX ix_QQNum_Group710 On GroupData8.dbo.Group710 (QQNum);
CREATE INDEX ix_QQNum_Group778 On GroupData8.dbo.Group778 (QQNum);
CREATE INDEX ix_QQNum_Group711 On GroupData8.dbo.Group711 (QQNum);
CREATE INDEX ix_QQNum_Group779 On GroupData8.dbo.Group779 (QQNum);
CREATE INDEX ix_QQNum_Group712 On GroupData8.dbo.Group712 (QQNum);
CREATE INDEX ix_QQNum_Group780 On GroupData8.dbo.Group780 (QQNum);
CREATE INDEX ix_QQNum_Group713 On GroupData8.dbo.Group713 (QQNum);
CREATE INDEX ix_QQNum_Group781 On GroupData8.dbo.Group781 (QQNum);
CREATE INDEX ix_QQNum_Group714 On GroupData8.dbo.Group714 (QQNum);
CREATE INDEX ix_QQNum_Group782 On GroupData8.dbo.Group782 (QQNum);
CREATE INDEX ix_QQNum_Group715 On GroupData8.dbo.Group715 (QQNum);
CREATE INDEX ix_QQNum_Group783 On GroupData8.dbo.Group783 (QQNum);
CREATE INDEX ix_QQNum_Group716 On GroupData8.dbo.Group716 (QQNum);
CREATE INDEX ix_QQNum_Group784 On GroupData8.dbo.Group784 (QQNum);
CREATE INDEX ix_QQNum_Group717 On GroupData8.dbo.Group717 (QQNum);
CREATE INDEX ix_QQNum_Group785 On GroupData8.dbo.Group785 (QQNum);
CREATE INDEX ix_QQNum_Group718 On GroupData8.dbo.Group718 (QQNum);
CREATE INDEX ix_QQNum_Group786 On GroupData8.dbo.Group786 (QQNum);
CREATE INDEX ix_QQNum_Group719 On GroupData8.dbo.Group719 (QQNum);
CREATE INDEX ix_QQNum_Group787 On GroupData8.dbo.Group787 (QQNum);
CREATE INDEX ix_QQNum_Group720 On GroupData8.dbo.Group720 (QQNum);
CREATE INDEX ix_QQNum_Group788 On GroupData8.dbo.Group788 (QQNum);
CREATE INDEX ix_QQNum_Group721 On GroupData8.dbo.Group721 (QQNum);
CREATE INDEX ix_QQNum_Group789 On GroupData8.dbo.Group789 (QQNum);
CREATE INDEX ix_QQNum_Group722 On GroupData8.dbo.Group722 (QQNum);
CREATE INDEX ix_QQNum_Group790 On GroupData8.dbo.Group790 (QQNum);
CREATE INDEX ix_QQNum_Group723 On GroupData8.dbo.Group723 (QQNum);
CREATE INDEX ix_QQNum_Group791 On GroupData8.dbo.Group791 (QQNum);
CREATE INDEX ix_QQNum_Group724 On GroupData8.dbo.Group724 (QQNum);
CREATE INDEX ix_QQNum_Group792 On GroupData8.dbo.Group792 (QQNum);
CREATE INDEX ix_QQNum_Group725 On GroupData8.dbo.Group725 (QQNum);
CREATE INDEX ix_QQNum_Group793 On GroupData8.dbo.Group793 (QQNum);
CREATE INDEX ix_QQNum_Group726 On GroupData8.dbo.Group726 (QQNum);
CREATE INDEX ix_QQNum_Group794 On GroupData8.dbo.Group794 (QQNum);
CREATE INDEX ix_QQNum_Group727 On GroupData8.dbo.Group727 (QQNum);
CREATE INDEX ix_QQNum_Group795 On GroupData8.dbo.Group795 (QQNum);
CREATE INDEX ix_QQNum_Group728 On GroupData8.dbo.Group728 (QQNum);
CREATE INDEX ix_QQNum_Group796 On GroupData8.dbo.Group796 (QQNum);
CREATE INDEX ix_QQNum_Group729 On GroupData8.dbo.Group729 (QQNum);
CREATE INDEX ix_QQNum_Group797 On GroupData8.dbo.Group797 (QQNum);
CREATE INDEX ix_QQNum_Group730 On GroupData8.dbo.Group730 (QQNum);
CREATE INDEX ix_QQNum_Group798 On GroupData8.dbo.Group798 (QQNum);
CREATE INDEX ix_QQNum_Group731 On GroupData8.dbo.Group731 (QQNum);
CREATE INDEX ix_QQNum_Group799 On GroupData8.dbo.Group799 (QQNum);
CREATE INDEX ix_QQNum_Group732 On GroupData8.dbo.Group732 (QQNum);
CREATE INDEX ix_QQNum_Group800 On GroupData8.dbo.Group800 (QQNum);
CREATE INDEX ix_QQNum_Group733 On GroupData8.dbo.Group733 (QQNum);
CREATE INDEX ix_QQNum_Group734 On GroupData8.dbo.Group734 (QQNum);
CREATE INDEX ix_QQNum_Group735 On GroupData8.dbo.Group735 (QQNum);
CREATE INDEX ix_QQNum_Group736 On GroupData8.dbo.Group736 (QQNum);
CREATE INDEX ix_QQNum_Group737 On GroupData8.dbo.Group737 (QQNum);
CREATE INDEX ix_QQNum_Group738 On GroupData8.dbo.Group738 (QQNum);
CREATE INDEX ix_QQNum_Group739 On GroupData8.dbo.Group739 (QQNum);
CREATE INDEX ix_QQNum_Group740 On GroupData8.dbo.Group740 (QQNum);
CREATE INDEX ix_QQNum_Group741 On GroupData8.dbo.Group741 (QQNum);
CREATE INDEX ix_QQNum_Group742 On GroupData8.dbo.Group742 (QQNum);
CREATE INDEX ix_QQNum_Group743 On GroupData8.dbo.Group743 (QQNum);
CREATE INDEX ix_QQNum_Group744 On GroupData8.dbo.Group744 (QQNum);
CREATE INDEX ix_QQNum_Group745 On GroupData8.dbo.Group745 (QQNum);
CREATE INDEX ix_QQNum_Group746 On GroupData8.dbo.Group746 (QQNum);
CREATE INDEX ix_QQNum_Group747 On GroupData8.dbo.Group747 (QQNum);
CREATE INDEX ix_QQNum_Group748 On GroupData8.dbo.Group748 (QQNum);
CREATE INDEX ix_QQNum_Group749 On GroupData8.dbo.Group749 (QQNum);
CREATE INDEX ix_QQNum_Group750 On GroupData8.dbo.Group750 (QQNum);
CREATE INDEX ix_QQNum_Group751 On GroupData8.dbo.Group751 (QQNum);
CREATE INDEX ix_QQNum_Group752 On GroupData8.dbo.Group752 (QQNum);
CREATE INDEX ix_QQNum_Group753 On GroupData8.dbo.Group753 (QQNum);
CREATE INDEX ix_QQNum_Group754 On GroupData8.dbo.Group754 (QQNum);
CREATE INDEX ix_QQNum_Group755 On GroupData8.dbo.Group755 (QQNum);
CREATE INDEX ix_QQNum_Group756 On GroupData8.dbo.Group756 (QQNum);
CREATE INDEX ix_QQNum_Group757 On GroupData8.dbo.Group757 (QQNum);
CREATE INDEX ix_QQNum_Group758 On GroupData8.dbo.Group758 (QQNum);
CREATE INDEX ix_QQNum_Group759 On GroupData8.dbo.Group759 (QQNum);
CREATE INDEX ix_QQNum_Group760 On GroupData8.dbo.Group760 (QQNum);
CREATE INDEX ix_QQNum_Group761 On GroupData8.dbo.Group761 (QQNum);
CREATE INDEX ix_QQNum_Group762 On GroupData8.dbo.Group762 (QQNum);
CREATE INDEX ix_QQNum_Group763 On GroupData8.dbo.Group763 (QQNum);
CREATE INDEX ix_QQNum_Group764 On GroupData8.dbo.Group764 (QQNum);
CREATE INDEX ix_QQNum_Group765 On GroupData8.dbo.Group765 (QQNum);
CREATE INDEX ix_QQNum_Group766 On GroupData8.dbo.Group766 (QQNum);
CREATE INDEX ix_QQNum_Group767 On GroupData8.dbo.Group767 (QQNum);
CREATE INDEX ix_QQNum_Group768 On GroupData8.dbo.Group768 (QQNum);
CREATE INDEX ix_QQNum_Group701 On GroupData8.dbo.Group701 (QQNum);
CREATE INDEX ix_QQNum_Group769 On GroupData8.dbo.Group769 (QQNum);
CREATE INDEX ix_QQNum_Group702 On GroupData8.dbo.Group702 (QQNum);
CREATE INDEX ix_QQNum_Group770 On GroupData8.dbo.Group770 (QQNum);
CREATE INDEX ix_QQNum_Group703 On GroupData8.dbo.Group703 (QQNum);
CREATE INDEX ix_QQNum_Group771 On GroupData8.dbo.Group771 (QQNum);
CREATE INDEX ix_QQNum_Group704 On GroupData8.dbo.Group704 (QQNum);
CREATE INDEX ix_QQNum_Group772 On GroupData8.dbo.Group772 (QQNum);
CREATE INDEX ix_QQNum_Group705 On GroupData8.dbo.Group705 (QQNum);
CREATE INDEX ix_QQNum_Group773 On GroupData8.dbo.Group773 (QQNum);
CREATE INDEX ix_QQNum_Group706 On GroupData8.dbo.Group706 (QQNum);
CREATE INDEX ix_QQNum_Group874 On GroupData9.dbo.Group874 (QQNum);
CREATE INDEX ix_QQNum_Group807 On GroupData9.dbo.Group807 (QQNum);
CREATE INDEX ix_QQNum_Group875 On GroupData9.dbo.Group875 (QQNum);
CREATE INDEX ix_QQNum_Group808 On GroupData9.dbo.Group808 (QQNum);
CREATE INDEX ix_QQNum_Group876 On GroupData9.dbo.Group876 (QQNum);
CREATE INDEX ix_QQNum_Group809 On GroupData9.dbo.Group809 (QQNum);
CREATE INDEX ix_QQNum_Group877 On GroupData9.dbo.Group877 (QQNum);
CREATE INDEX ix_QQNum_Group810 On GroupData9.dbo.Group810 (QQNum);
CREATE INDEX ix_QQNum_Group878 On GroupData9.dbo.Group878 (QQNum);
CREATE INDEX ix_QQNum_Group811 On GroupData9.dbo.Group811 (QQNum);
CREATE INDEX ix_QQNum_Group879 On GroupData9.dbo.Group879 (QQNum);
CREATE INDEX ix_QQNum_Group812 On GroupData9.dbo.Group812 (QQNum);
CREATE INDEX ix_QQNum_Group880 On GroupData9.dbo.Group880 (QQNum);
CREATE INDEX ix_QQNum_Group813 On GroupData9.dbo.Group813 (QQNum);
CREATE INDEX ix_QQNum_Group881 On GroupData9.dbo.Group881 (QQNum);
CREATE INDEX ix_QQNum_Group814 On GroupData9.dbo.Group814 (QQNum);
CREATE INDEX ix_QQNum_Group882 On GroupData9.dbo.Group882 (QQNum);
CREATE INDEX ix_QQNum_Group815 On GroupData9.dbo.Group815 (QQNum);
CREATE INDEX ix_QQNum_Group883 On GroupData9.dbo.Group883 (QQNum);
CREATE INDEX ix_QQNum_Group816 On GroupData9.dbo.Group816 (QQNum);
CREATE INDEX ix_QQNum_Group884 On GroupData9.dbo.Group884 (QQNum);
CREATE INDEX ix_QQNum_Group817 On GroupData9.dbo.Group817 (QQNum);
CREATE INDEX ix_QQNum_Group885 On GroupData9.dbo.Group885 (QQNum);
CREATE INDEX ix_QQNum_Group818 On GroupData9.dbo.Group818 (QQNum);
CREATE INDEX ix_QQNum_Group886 On GroupData9.dbo.Group886 (QQNum);
CREATE INDEX ix_QQNum_Group819 On GroupData9.dbo.Group819 (QQNum);
CREATE INDEX ix_QQNum_Group887 On GroupData9.dbo.Group887 (QQNum);
CREATE INDEX ix_QQNum_Group820 On GroupData9.dbo.Group820 (QQNum);
CREATE INDEX ix_QQNum_Group888 On GroupData9.dbo.Group888 (QQNum);
CREATE INDEX ix_QQNum_Group821 On GroupData9.dbo.Group821 (QQNum);
CREATE INDEX ix_QQNum_Group889 On GroupData9.dbo.Group889 (QQNum);
CREATE INDEX ix_QQNum_Group822 On GroupData9.dbo.Group822 (QQNum);
CREATE INDEX ix_QQNum_Group890 On GroupData9.dbo.Group890 (QQNum);
CREATE INDEX ix_QQNum_Group823 On GroupData9.dbo.Group823 (QQNum);
CREATE INDEX ix_QQNum_Group891 On GroupData9.dbo.Group891 (QQNum);
CREATE INDEX ix_QQNum_Group824 On GroupData9.dbo.Group824 (QQNum);
CREATE INDEX ix_QQNum_Group892 On GroupData9.dbo.Group892 (QQNum);
CREATE INDEX ix_QQNum_Group825 On GroupData9.dbo.Group825 (QQNum);
CREATE INDEX ix_QQNum_Group893 On GroupData9.dbo.Group893 (QQNum);
CREATE INDEX ix_QQNum_Group826 On GroupData9.dbo.Group826 (QQNum);
CREATE INDEX ix_QQNum_Group894 On GroupData9.dbo.Group894 (QQNum);
CREATE INDEX ix_QQNum_Group827 On GroupData9.dbo.Group827 (QQNum);
CREATE INDEX ix_QQNum_Group895 On GroupData9.dbo.Group895 (QQNum);
CREATE INDEX ix_QQNum_Group828 On GroupData9.dbo.Group828 (QQNum);
CREATE INDEX ix_QQNum_Group896 On GroupData9.dbo.Group896 (QQNum);
CREATE INDEX ix_QQNum_Group829 On GroupData9.dbo.Group829 (QQNum);
CREATE INDEX ix_QQNum_Group897 On GroupData9.dbo.Group897 (QQNum);
CREATE INDEX ix_QQNum_Group830 On GroupData9.dbo.Group830 (QQNum);
CREATE INDEX ix_QQNum_Group898 On GroupData9.dbo.Group898 (QQNum);
CREATE INDEX ix_QQNum_Group831 On GroupData9.dbo.Group831 (QQNum);
CREATE INDEX ix_QQNum_Group899 On GroupData9.dbo.Group899 (QQNum);
CREATE INDEX ix_QQNum_Group832 On GroupData9.dbo.Group832 (QQNum);
CREATE INDEX ix_QQNum_Group900 On GroupData9.dbo.Group900 (QQNum);
CREATE INDEX ix_QQNum_Group833 On GroupData9.dbo.Group833 (QQNum);
CREATE INDEX ix_QQNum_Group834 On GroupData9.dbo.Group834 (QQNum);
CREATE INDEX ix_QQNum_Group835 On GroupData9.dbo.Group835 (QQNum);
CREATE INDEX ix_QQNum_Group836 On GroupData9.dbo.Group836 (QQNum);
CREATE INDEX ix_QQNum_Group837 On GroupData9.dbo.Group837 (QQNum);
CREATE INDEX ix_QQNum_Group838 On GroupData9.dbo.Group838 (QQNum);
CREATE INDEX ix_QQNum_Group839 On GroupData9.dbo.Group839 (QQNum);
CREATE INDEX ix_QQNum_Group840 On GroupData9.dbo.Group840 (QQNum);
CREATE INDEX ix_QQNum_Group841 On GroupData9.dbo.Group841 (QQNum);
CREATE INDEX ix_QQNum_Group842 On GroupData9.dbo.Group842 (QQNum);
CREATE INDEX ix_QQNum_Group843 On GroupData9.dbo.Group843 (QQNum);
CREATE INDEX ix_QQNum_Group844 On GroupData9.dbo.Group844 (QQNum);
CREATE INDEX ix_QQNum_Group845 On GroupData9.dbo.Group845 (QQNum);
CREATE INDEX ix_QQNum_Group846 On GroupData9.dbo.Group846 (QQNum);
CREATE INDEX ix_QQNum_Group847 On GroupData9.dbo.Group847 (QQNum);
CREATE INDEX ix_QQNum_Group848 On GroupData9.dbo.Group848 (QQNum);
CREATE INDEX ix_QQNum_Group849 On GroupData9.dbo.Group849 (QQNum);
CREATE INDEX ix_QQNum_Group850 On GroupData9.dbo.Group850 (QQNum);
CREATE INDEX ix_QQNum_Group851 On GroupData9.dbo.Group851 (QQNum);
CREATE INDEX ix_QQNum_Group852 On GroupData9.dbo.Group852 (QQNum);
CREATE INDEX ix_QQNum_Group853 On GroupData9.dbo.Group853 (QQNum);
CREATE INDEX ix_QQNum_Group854 On GroupData9.dbo.Group854 (QQNum);
CREATE INDEX ix_QQNum_Group855 On GroupData9.dbo.Group855 (QQNum);
CREATE INDEX ix_QQNum_Group856 On GroupData9.dbo.Group856 (QQNum);
CREATE INDEX ix_QQNum_Group857 On GroupData9.dbo.Group857 (QQNum);
CREATE INDEX ix_QQNum_Group858 On GroupData9.dbo.Group858 (QQNum);
CREATE INDEX ix_QQNum_Group859 On GroupData9.dbo.Group859 (QQNum);
CREATE INDEX ix_QQNum_Group860 On GroupData9.dbo.Group860 (QQNum);
CREATE INDEX ix_QQNum_Group861 On GroupData9.dbo.Group861 (QQNum);
CREATE INDEX ix_QQNum_Group862 On GroupData9.dbo.Group862 (QQNum);
CREATE INDEX ix_QQNum_Group863 On GroupData9.dbo.Group863 (QQNum);
CREATE INDEX ix_QQNum_Group864 On GroupData9.dbo.Group864 (QQNum);
CREATE INDEX ix_QQNum_Group865 On GroupData9.dbo.Group865 (QQNum);
CREATE INDEX ix_QQNum_Group866 On GroupData9.dbo.Group866 (QQNum);
CREATE INDEX ix_QQNum_Group867 On GroupData9.dbo.Group867 (QQNum);
CREATE INDEX ix_QQNum_Group868 On GroupData9.dbo.Group868 (QQNum);
CREATE INDEX ix_QQNum_Group801 On GroupData9.dbo.Group801 (QQNum);
CREATE INDEX ix_QQNum_Group869 On GroupData9.dbo.Group869 (QQNum);
CREATE INDEX ix_QQNum_Group802 On GroupData9.dbo.Group802 (QQNum);
CREATE INDEX ix_QQNum_Group870 On GroupData9.dbo.Group870 (QQNum);
CREATE INDEX ix_QQNum_Group803 On GroupData9.dbo.Group803 (QQNum);
CREATE INDEX ix_QQNum_Group871 On GroupData9.dbo.Group871 (QQNum);
CREATE INDEX ix_QQNum_Group804 On GroupData9.dbo.Group804 (QQNum);
CREATE INDEX ix_QQNum_Group872 On GroupData9.dbo.Group872 (QQNum);
CREATE INDEX ix_QQNum_Group805 On GroupData9.dbo.Group805 (QQNum);
CREATE INDEX ix_QQNum_Group873 On GroupData9.dbo.Group873 (QQNum);
CREATE INDEX ix_QQNum_Group806 On GroupData9.dbo.Group806 (QQNum);
CREATE INDEX ix_QQNum_Group974 On GroupData10.dbo.Group974 (QQNum);
CREATE INDEX ix_QQNum_Group907 On GroupData10.dbo.Group907 (QQNum);
CREATE INDEX ix_QQNum_Group975 On GroupData10.dbo.Group975 (QQNum);
CREATE INDEX ix_QQNum_Group908 On GroupData10.dbo.Group908 (QQNum);
CREATE INDEX ix_QQNum_Group976 On GroupData10.dbo.Group976 (QQNum);
CREATE INDEX ix_QQNum_Group909 On GroupData10.dbo.Group909 (QQNum);
CREATE INDEX ix_QQNum_Group977 On GroupData10.dbo.Group977 (QQNum);
CREATE INDEX ix_QQNum_Group910 On GroupData10.dbo.Group910 (QQNum);
CREATE INDEX ix_QQNum_Group978 On GroupData10.dbo.Group978 (QQNum);
CREATE INDEX ix_QQNum_Group911 On GroupData10.dbo.Group911 (QQNum);
CREATE INDEX ix_QQNum_Group979 On GroupData10.dbo.Group979 (QQNum);
CREATE INDEX ix_QQNum_Group912 On GroupData10.dbo.Group912 (QQNum);
CREATE INDEX ix_QQNum_Group980 On GroupData10.dbo.Group980 (QQNum);
CREATE INDEX ix_QQNum_Group913 On GroupData10.dbo.Group913 (QQNum);
CREATE INDEX ix_QQNum_Group981 On GroupData10.dbo.Group981 (QQNum);
CREATE INDEX ix_QQNum_Group914 On GroupData10.dbo.Group914 (QQNum);
CREATE INDEX ix_QQNum_Group982 On GroupData10.dbo.Group982 (QQNum);
CREATE INDEX ix_QQNum_Group915 On GroupData10.dbo.Group915 (QQNum);
CREATE INDEX ix_QQNum_Group983 On GroupData10.dbo.Group983 (QQNum);
CREATE INDEX ix_QQNum_Group916 On GroupData10.dbo.Group916 (QQNum);
CREATE INDEX ix_QQNum_Group984 On GroupData10.dbo.Group984 (QQNum);
CREATE INDEX ix_QQNum_Group917 On GroupData10.dbo.Group917 (QQNum);
CREATE INDEX ix_QQNum_Group985 On GroupData10.dbo.Group985 (QQNum);
CREATE INDEX ix_QQNum_Group918 On GroupData10.dbo.Group918 (QQNum);
CREATE INDEX ix_QQNum_Group986 On GroupData10.dbo.Group986 (QQNum);
CREATE INDEX ix_QQNum_Group919 On GroupData10.dbo.Group919 (QQNum);
CREATE INDEX ix_QQNum_Group987 On GroupData10.dbo.Group987 (QQNum);
CREATE INDEX ix_QQNum_Group920 On GroupData10.dbo.Group920 (QQNum);
CREATE INDEX ix_QQNum_Group988 On GroupData10.dbo.Group988 (QQNum);
CREATE INDEX ix_QQNum_Group921 On GroupData10.dbo.Group921 (QQNum);
CREATE INDEX ix_QQNum_Group989 On GroupData10.dbo.Group989 (QQNum);
CREATE INDEX ix_QQNum_Group922 On GroupData10.dbo.Group922 (QQNum);
CREATE INDEX ix_QQNum_Group990 On GroupData10.dbo.Group990 (QQNum);
CREATE INDEX ix_QQNum_Group923 On GroupData10.dbo.Group923 (QQNum);
CREATE INDEX ix_QQNum_Group991 On GroupData10.dbo.Group991 (QQNum);
CREATE INDEX ix_QQNum_Group924 On GroupData10.dbo.Group924 (QQNum);
CREATE INDEX ix_QQNum_Group992 On GroupData10.dbo.Group992 (QQNum);
CREATE INDEX ix_QQNum_Group925 On GroupData10.dbo.Group925 (QQNum);
CREATE INDEX ix_QQNum_Group993 On GroupData10.dbo.Group993 (QQNum);
CREATE INDEX ix_QQNum_Group926 On GroupData10.dbo.Group926 (QQNum);
CREATE INDEX ix_QQNum_Group994 On GroupData10.dbo.Group994 (QQNum);
CREATE INDEX ix_QQNum_Group927 On GroupData10.dbo.Group927 (QQNum);
CREATE INDEX ix_QQNum_Group995 On GroupData10.dbo.Group995 (QQNum);
CREATE INDEX ix_QQNum_Group928 On GroupData10.dbo.Group928 (QQNum);
CREATE INDEX ix_QQNum_Group996 On GroupData10.dbo.Group996 (QQNum);
CREATE INDEX ix_QQNum_Group929 On GroupData10.dbo.Group929 (QQNum);
CREATE INDEX ix_QQNum_Group997 On GroupData10.dbo.Group997 (QQNum);
CREATE INDEX ix_QQNum_Group930 On GroupData10.dbo.Group930 (QQNum);
CREATE INDEX ix_QQNum_Group998 On GroupData10.dbo.Group998 (QQNum);
CREATE INDEX ix_QQNum_Group931 On GroupData10.dbo.Group931 (QQNum);
CREATE INDEX ix_QQNum_Group999 On GroupData10.dbo.Group999 (QQNum);
CREATE INDEX ix_QQNum_Group932 On GroupData10.dbo.Group932 (QQNum);
CREATE INDEX ix_QQNum_Group1000 On GroupData10.dbo.Group1000 (QQNum);
CREATE INDEX ix_QQNum_Group933 On GroupData10.dbo.Group933 (QQNum);
CREATE INDEX ix_QQNum_Group934 On GroupData10.dbo.Group934 (QQNum);
CREATE INDEX ix_QQNum_Group935 On GroupData10.dbo.Group935 (QQNum);
CREATE INDEX ix_QQNum_Group936 On GroupData10.dbo.Group936 (QQNum);
CREATE INDEX ix_QQNum_Group937 On GroupData10.dbo.Group937 (QQNum);
CREATE INDEX ix_QQNum_Group938 On GroupData10.dbo.Group938 (QQNum);
CREATE INDEX ix_QQNum_Group939 On GroupData10.dbo.Group939 (QQNum);
CREATE INDEX ix_QQNum_Group940 On GroupData10.dbo.Group940 (QQNum);
CREATE INDEX ix_QQNum_Group941 On GroupData10.dbo.Group941 (QQNum);
CREATE INDEX ix_QQNum_Group942 On GroupData10.dbo.Group942 (QQNum);
CREATE INDEX ix_QQNum_Group943 On GroupData10.dbo.Group943 (QQNum);
CREATE INDEX ix_QQNum_Group944 On GroupData10.dbo.Group944 (QQNum);
CREATE INDEX ix_QQNum_Group945 On GroupData10.dbo.Group945 (QQNum);
CREATE INDEX ix_QQNum_Group946 On GroupData10.dbo.Group946 (QQNum);
CREATE INDEX ix_QQNum_Group947 On GroupData10.dbo.Group947 (QQNum);
CREATE INDEX ix_QQNum_Group948 On GroupData10.dbo.Group948 (QQNum);
CREATE INDEX ix_QQNum_Group949 On GroupData10.dbo.Group949 (QQNum);
CREATE INDEX ix_QQNum_Group950 On GroupData10.dbo.Group950 (QQNum);
CREATE INDEX ix_QQNum_Group951 On GroupData10.dbo.Group951 (QQNum);
CREATE INDEX ix_QQNum_Group952 On GroupData10.dbo.Group952 (QQNum);
CREATE INDEX ix_QQNum_Group953 On GroupData10.dbo.Group953 (QQNum);
CREATE INDEX ix_QQNum_Group954 On GroupData10.dbo.Group954 (QQNum);
CREATE INDEX ix_QQNum_Group955 On GroupData10.dbo.Group955 (QQNum);
CREATE INDEX ix_QQNum_Group956 On GroupData10.dbo.Group956 (QQNum);
CREATE INDEX ix_QQNum_Group957 On GroupData10.dbo.Group957 (QQNum);
CREATE INDEX ix_QQNum_Group958 On GroupData10.dbo.Group958 (QQNum);
CREATE INDEX ix_QQNum_Group959 On GroupData10.dbo.Group959 (QQNum);
CREATE INDEX ix_QQNum_Group960 On GroupData10.dbo.Group960 (QQNum);
CREATE INDEX ix_QQNum_Group961 On GroupData10.dbo.Group961 (QQNum);
CREATE INDEX ix_QQNum_Group962 On GroupData10.dbo.Group962 (QQNum);
CREATE INDEX ix_QQNum_Group963 On GroupData10.dbo.Group963 (QQNum);
CREATE INDEX ix_QQNum_Group964 On GroupData10.dbo.Group964 (QQNum);
CREATE INDEX ix_QQNum_Group965 On GroupData10.dbo.Group965 (QQNum);
CREATE INDEX ix_QQNum_Group966 On GroupData10.dbo.Group966 (QQNum);
CREATE INDEX ix_QQNum_Group967 On GroupData10.dbo.Group967 (QQNum);
CREATE INDEX ix_QQNum_Group968 On GroupData10.dbo.Group968 (QQNum);
CREATE INDEX ix_QQNum_Group901 On GroupData10.dbo.Group901 (QQNum);
CREATE INDEX ix_QQNum_Group969 On GroupData10.dbo.Group969 (QQNum);
CREATE INDEX ix_QQNum_Group902 On GroupData10.dbo.Group902 (QQNum);
CREATE INDEX ix_QQNum_Group970 On GroupData10.dbo.Group970 (QQNum);
CREATE INDEX ix_QQNum_Group903 On GroupData10.dbo.Group903 (QQNum);
CREATE INDEX ix_QQNum_Group971 On GroupData10.dbo.Group971 (QQNum);
CREATE INDEX ix_QQNum_Group904 On GroupData10.dbo.Group904 (QQNum);
CREATE INDEX ix_QQNum_Group972 On GroupData10.dbo.Group972 (QQNum);
CREATE INDEX ix_QQNum_Group905 On GroupData10.dbo.Group905 (QQNum);
CREATE INDEX ix_QQNum_Group973 On GroupData10.dbo.Group973 (QQNum);
CREATE INDEX ix_QQNum_Group906 On GroupData10.dbo.Group906 (QQNum);
CREATE INDEX ix_QQNum_Group1074 On GroupData11.dbo.Group1074 (QQNum);
CREATE INDEX ix_QQNum_Group1007 On GroupData11.dbo.Group1007 (QQNum);
CREATE INDEX ix_QQNum_Group1075 On GroupData11.dbo.Group1075 (QQNum);
CREATE INDEX ix_QQNum_Group1008 On GroupData11.dbo.Group1008 (QQNum);
CREATE INDEX ix_QQNum_Group1076 On GroupData11.dbo.Group1076 (QQNum);
CREATE INDEX ix_QQNum_Group1009 On GroupData11.dbo.Group1009 (QQNum);
CREATE INDEX ix_QQNum_Group1077 On GroupData11.dbo.Group1077 (QQNum);
CREATE INDEX ix_QQNum_Group1010 On GroupData11.dbo.Group1010 (QQNum);
CREATE INDEX ix_QQNum_Group1078 On GroupData11.dbo.Group1078 (QQNum);
CREATE INDEX ix_QQNum_Group1011 On GroupData11.dbo.Group1011 (QQNum);
CREATE INDEX ix_QQNum_Group1079 On GroupData11.dbo.Group1079 (QQNum);
CREATE INDEX ix_QQNum_Group1012 On GroupData11.dbo.Group1012 (QQNum);
CREATE INDEX ix_QQNum_Group1080 On GroupData11.dbo.Group1080 (QQNum);
CREATE INDEX ix_QQNum_Group1013 On GroupData11.dbo.Group1013 (QQNum);
CREATE INDEX ix_QQNum_Group1081 On GroupData11.dbo.Group1081 (QQNum);
CREATE INDEX ix_QQNum_Group1014 On GroupData11.dbo.Group1014 (QQNum);
CREATE INDEX ix_QQNum_Group1082 On GroupData11.dbo.Group1082 (QQNum);
CREATE INDEX ix_QQNum_Group1015 On GroupData11.dbo.Group1015 (QQNum);
CREATE INDEX ix_QQNum_Group1083 On GroupData11.dbo.Group1083 (QQNum);
CREATE INDEX ix_QQNum_Group1016 On GroupData11.dbo.Group1016 (QQNum);
CREATE INDEX ix_QQNum_Group1084 On GroupData11.dbo.Group1084 (QQNum);
CREATE INDEX ix_QQNum_Group1017 On GroupData11.dbo.Group1017 (QQNum);
CREATE INDEX ix_QQNum_Group1085 On GroupData11.dbo.Group1085 (QQNum);
CREATE INDEX ix_QQNum_Group1018 On GroupData11.dbo.Group1018 (QQNum);
CREATE INDEX ix_QQNum_Group1086 On GroupData11.dbo.Group1086 (QQNum);
CREATE INDEX ix_QQNum_Group1019 On GroupData11.dbo.Group1019 (QQNum);
CREATE INDEX ix_QQNum_Group1087 On GroupData11.dbo.Group1087 (QQNum);
CREATE INDEX ix_QQNum_Group1020 On GroupData11.dbo.Group1020 (QQNum);
CREATE INDEX ix_QQNum_Group1088 On GroupData11.dbo.Group1088 (QQNum);
CREATE INDEX ix_QQNum_Group1021 On GroupData11.dbo.Group1021 (QQNum);
CREATE INDEX ix_QQNum_Group1089 On GroupData11.dbo.Group1089 (QQNum);
CREATE INDEX ix_QQNum_Group1022 On GroupData11.dbo.Group1022 (QQNum);
CREATE INDEX ix_QQNum_Group1090 On GroupData11.dbo.Group1090 (QQNum);
CREATE INDEX ix_QQNum_Group1023 On GroupData11.dbo.Group1023 (QQNum);
CREATE INDEX ix_QQNum_Group1091 On GroupData11.dbo.Group1091 (QQNum);
CREATE INDEX ix_QQNum_Group1024 On GroupData11.dbo.Group1024 (QQNum);
CREATE INDEX ix_QQNum_Group1092 On GroupData11.dbo.Group1092 (QQNum);
CREATE INDEX ix_QQNum_Group1025 On GroupData11.dbo.Group1025 (QQNum);
CREATE INDEX ix_QQNum_Group1093 On GroupData11.dbo.Group1093 (QQNum);
CREATE INDEX ix_QQNum_Group1026 On GroupData11.dbo.Group1026 (QQNum);
CREATE INDEX ix_QQNum_Group1094 On GroupData11.dbo.Group1094 (QQNum);
CREATE INDEX ix_QQNum_Group1027 On GroupData11.dbo.Group1027 (QQNum);
CREATE INDEX ix_QQNum_Group1095 On GroupData11.dbo.Group1095 (QQNum);
CREATE INDEX ix_QQNum_Group1028 On GroupData11.dbo.Group1028 (QQNum);
CREATE INDEX ix_QQNum_Group1096 On GroupData11.dbo.Group1096 (QQNum);
CREATE INDEX ix_QQNum_Group1029 On GroupData11.dbo.Group1029 (QQNum);
CREATE INDEX ix_QQNum_Group1097 On GroupData11.dbo.Group1097 (QQNum);
CREATE INDEX ix_QQNum_Group1030 On GroupData11.dbo.Group1030 (QQNum);
CREATE INDEX ix_QQNum_Group1098 On GroupData11.dbo.Group1098 (QQNum);
CREATE INDEX ix_QQNum_Group1031 On GroupData11.dbo.Group1031 (QQNum);
CREATE INDEX ix_QQNum_Group1099 On GroupData11.dbo.Group1099 (QQNum);
CREATE INDEX ix_QQNum_Group1032 On GroupData11.dbo.Group1032 (QQNum);
CREATE INDEX ix_QQNum_Group1100 On GroupData11.dbo.Group1100 (QQNum);
CREATE INDEX ix_QQNum_Group1033 On GroupData11.dbo.Group1033 (QQNum);
CREATE INDEX ix_QQNum_Group1034 On GroupData11.dbo.Group1034 (QQNum);
CREATE INDEX ix_QQNum_Group1035 On GroupData11.dbo.Group1035 (QQNum);
CREATE INDEX ix_QQNum_Group1036 On GroupData11.dbo.Group1036 (QQNum);
CREATE INDEX ix_QQNum_Group1037 On GroupData11.dbo.Group1037 (QQNum);
CREATE INDEX ix_QQNum_Group1038 On GroupData11.dbo.Group1038 (QQNum);
CREATE INDEX ix_QQNum_Group1039 On GroupData11.dbo.Group1039 (QQNum);
CREATE INDEX ix_QQNum_Group1040 On GroupData11.dbo.Group1040 (QQNum);
CREATE INDEX ix_QQNum_Group1041 On GroupData11.dbo.Group1041 (QQNum);
CREATE INDEX ix_QQNum_Group1042 On GroupData11.dbo.Group1042 (QQNum);
CREATE INDEX ix_QQNum_Group1043 On GroupData11.dbo.Group1043 (QQNum);
CREATE INDEX ix_QQNum_Group1044 On GroupData11.dbo.Group1044 (QQNum);
CREATE INDEX ix_QQNum_Group1045 On GroupData11.dbo.Group1045 (QQNum);
CREATE INDEX ix_QQNum_Group1046 On GroupData11.dbo.Group1046 (QQNum);
CREATE INDEX ix_QQNum_Group1047 On GroupData11.dbo.Group1047 (QQNum);
CREATE INDEX ix_QQNum_Group1048 On GroupData11.dbo.Group1048 (QQNum);
CREATE INDEX ix_QQNum_Group1049 On GroupData11.dbo.Group1049 (QQNum);
CREATE INDEX ix_QQNum_Group1050 On GroupData11.dbo.Group1050 (QQNum);
CREATE INDEX ix_QQNum_Group1051 On GroupData11.dbo.Group1051 (QQNum);
CREATE INDEX ix_QQNum_Group1052 On GroupData11.dbo.Group1052 (QQNum);
CREATE INDEX ix_QQNum_Group1053 On GroupData11.dbo.Group1053 (QQNum);
CREATE INDEX ix_QQNum_Group1054 On GroupData11.dbo.Group1054 (QQNum);
CREATE INDEX ix_QQNum_Group1055 On GroupData11.dbo.Group1055 (QQNum);
CREATE INDEX ix_QQNum_Group1056 On GroupData11.dbo.Group1056 (QQNum);
CREATE INDEX ix_QQNum_Group1057 On GroupData11.dbo.Group1057 (QQNum);
CREATE INDEX ix_QQNum_Group1058 On GroupData11.dbo.Group1058 (QQNum);
CREATE INDEX ix_QQNum_Group1059 On GroupData11.dbo.Group1059 (QQNum);
CREATE INDEX ix_QQNum_Group1060 On GroupData11.dbo.Group1060 (QQNum);
CREATE INDEX ix_QQNum_Group1061 On GroupData11.dbo.Group1061 (QQNum);
CREATE INDEX ix_QQNum_Group1062 On GroupData11.dbo.Group1062 (QQNum);
CREATE INDEX ix_QQNum_Group1063 On GroupData11.dbo.Group1063 (QQNum);
CREATE INDEX ix_QQNum_Group1064 On GroupData11.dbo.Group1064 (QQNum);
CREATE INDEX ix_QQNum_Group1065 On GroupData11.dbo.Group1065 (QQNum);
CREATE INDEX ix_QQNum_Group1066 On GroupData11.dbo.Group1066 (QQNum);
CREATE INDEX ix_QQNum_Group1067 On GroupData11.dbo.Group1067 (QQNum);
CREATE INDEX ix_QQNum_Group1068 On GroupData11.dbo.Group1068 (QQNum);
CREATE INDEX ix_QQNum_Group1001 On GroupData11.dbo.Group1001 (QQNum);
CREATE INDEX ix_QQNum_Group1069 On GroupData11.dbo.Group1069 (QQNum);
CREATE INDEX ix_QQNum_Group1002 On GroupData11.dbo.Group1002 (QQNum);
CREATE INDEX ix_QQNum_Group1070 On GroupData11.dbo.Group1070 (QQNum);
CREATE INDEX ix_QQNum_Group1003 On GroupData11.dbo.Group1003 (QQNum);
CREATE INDEX ix_QQNum_Group1071 On GroupData11.dbo.Group1071 (QQNum);
CREATE INDEX ix_QQNum_Group1004 On GroupData11.dbo.Group1004 (QQNum);
CREATE INDEX ix_QQNum_Group1072 On GroupData11.dbo.Group1072 (QQNum);
CREATE INDEX ix_QQNum_Group1005 On GroupData11.dbo.Group1005 (QQNum);
CREATE INDEX ix_QQNum_Group1073 On GroupData11.dbo.Group1073 (QQNum);
CREATE INDEX ix_QQNum_Group1006 On GroupData11.dbo.Group1006 (QQNum);

建立完索引之后就是查询

  • 根据QQ号码查询群信息
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
declare @QQNum bigint = (12345678)
declare @sql nvarchar(4000)
declare @dbIdx int = 1

-- Author: <NOBODY>
-- Email: <[email protected]>
-- Create date: <2018-03-07>
-- Description: <输入QQ号,输出其所加群>
-- Note: <支持bigint长度的QQ号>

if OBJECT_ID('tempdb.dbo.#QunList') is not null
drop table #QunList
if OBJECT_ID('tempdb.dbo.#QunDetail') is not null
drop table #QunDetail

create table #QunList
(
QQNum int,
Nick nvarchar(20),
Age int,
Gender int,
Auth int,
QunNum int,
Title nvarchar(22),
QunText nvarchar(80)
)
create table #QunDetail
(
QunNum int,
Title nvarchar(22),
QunText nvarchar(80)
)

-- Search QunList

while @dbIdx <= 11
begin
declare @tblIdx int = 1
declare @tblName nvarchar(50)

while @tblIdx <= 100
begin
set @tblName = 'GroupData' + CONVERT(nvarchar(2), @dbIdx) + '.dbo.Group'
set @tblName += CONVERT(nvarchar(5), (@dbIdx - 1) * 100 + @tblIdx)

set @sql = 'select QQNum, Nick, Age,Gender, Auth, QunNum from '
set @sql += @tblName + ' where QQNum=' + CONVERT(nvarchar(15), @QQNum)

insert into #QunList(QQNum, Nick,Age,Gender,Auth,QunNum) exec(@sql)

print @tblname + ' OK'

set @tblIdx += 1
end

set @dbIdx += 1
end

-- Search QunDetail

declare @QunNum int
declare cur_Qun cursor
for select QunNum from #QunList

open cur_Qun
fetch next from cur_Qun into @QunNum

while @@FETCH_STATUS = 0
begin
set @sql = 'select QunNum,Title,QunText from QunInfo' + CONVERT(nvarchar(5), @QunNum / 10000000 + 1) + '.dbo.'
set @sql += 'QunList' + CONVERT(nvarchar(10), @QunNum / 1000000 + 1) + ' where QunNum=' + Convert(nvarchar(20),@QunNum)

insert into #QunDetail exec(@sql)

fetch next from cur_Qun into @QunNum
end

close cur_Qun
deallocate cur_Qun

-- combine QunList with QunDetail

update #QunList set Title = #QunDetail.Title,QunText=#QunDetail.QunText
from #QunDetail
where #QunList.QunNum = #QunDetail.QunNum

select * from #QunList

根据群号查询群详细信息

首先创建一个存储过程,方便查询

1
2
3
4
5
6
7
8
9
10
11
CREATE PROCEDURE QUNCY_CX @QunNum int=null
as
BEGIN
declare @sql varchar(8000)
--群成员
set @sql = 'select * from GroupData' + CONVERT(varchar(5), @QunNum / 10000000 + 1) + '.dbo.'
set @sql += 'Group' + CONVERT(varchar(10), @QunNum / 100000 + 1) + ' where QunNum=' + Convert(varchar(20),@QunNum)
exec(@sql)
print(@sql)
END
GO

之后使用下面命令查询就可以

EXEC QUNCY_CX 12345678

根据姓名查询所有QQ

首先建立索引

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
CREATE INDEX ix_QQNick_Group7 On GroupData1.dbo.Group7 (Nick);  
CREATE INDEX ix_QQNick_Group75 On GroupData1.dbo.Group75 (Nick);
CREATE INDEX ix_QQNick_Group8 On GroupData1.dbo.Group8 (Nick);
CREATE INDEX ix_QQNick_Group76 On GroupData1.dbo.Group76 (Nick);
CREATE INDEX ix_QQNick_Group9 On GroupData1.dbo.Group9 (Nick);
CREATE INDEX ix_QQNick_Group77 On GroupData1.dbo.Group77 (Nick);
CREATE INDEX ix_QQNick_Group10 On GroupData1.dbo.Group10 (Nick);
CREATE INDEX ix_QQNick_Group78 On GroupData1.dbo.Group78 (Nick);
CREATE INDEX ix_QQNick_Group11 On GroupData1.dbo.Group11 (Nick);
CREATE INDEX ix_QQNick_Group79 On GroupData1.dbo.Group79 (Nick);
CREATE INDEX ix_QQNick_Group12 On GroupData1.dbo.Group12 (Nick);
CREATE INDEX ix_QQNick_Group80 On GroupData1.dbo.Group80 (Nick);
CREATE INDEX ix_QQNick_Group13 On GroupData1.dbo.Group13 (Nick);
CREATE INDEX ix_QQNick_Group81 On GroupData1.dbo.Group81 (Nick);
CREATE INDEX ix_QQNick_Group14 On GroupData1.dbo.Group14 (Nick);
CREATE INDEX ix_QQNick_Group82 On GroupData1.dbo.Group82 (Nick);
CREATE INDEX ix_QQNick_Group15 On GroupData1.dbo.Group15 (Nick);
CREATE INDEX ix_QQNick_Group83 On GroupData1.dbo.Group83 (Nick);
CREATE INDEX ix_QQNick_Group16 On GroupData1.dbo.Group16 (Nick);
CREATE INDEX ix_QQNick_Group84 On GroupData1.dbo.Group84 (Nick);
CREATE INDEX ix_QQNick_Group17 On GroupData1.dbo.Group17 (Nick);
CREATE INDEX ix_QQNick_Group85 On GroupData1.dbo.Group85 (Nick);
CREATE INDEX ix_QQNick_Group18 On GroupData1.dbo.Group18 (Nick);
CREATE INDEX ix_QQNick_Group86 On GroupData1.dbo.Group86 (Nick);
CREATE INDEX ix_QQNick_Group19 On GroupData1.dbo.Group19 (Nick);
CREATE INDEX ix_QQNick_Group87 On GroupData1.dbo.Group87 (Nick);
CREATE INDEX ix_QQNick_Group20 On GroupData1.dbo.Group20 (Nick);
CREATE INDEX ix_QQNick_Group88 On GroupData1.dbo.Group88 (Nick);
CREATE INDEX ix_QQNick_Group21 On GroupData1.dbo.Group21 (Nick);
CREATE INDEX ix_QQNick_Group89 On GroupData1.dbo.Group89 (Nick);
CREATE INDEX ix_QQNick_Group22 On GroupData1.dbo.Group22 (Nick);
CREATE INDEX ix_QQNick_Group90 On GroupData1.dbo.Group90 (Nick);
CREATE INDEX ix_QQNick_Group23 On GroupData1.dbo.Group23 (Nick);
CREATE INDEX ix_QQNick_Group91 On GroupData1.dbo.Group91 (Nick);
CREATE INDEX ix_QQNick_Group24 On GroupData1.dbo.Group24 (Nick);
CREATE INDEX ix_QQNick_Group92 On GroupData1.dbo.Group92 (Nick);
CREATE INDEX ix_QQNick_Group25 On GroupData1.dbo.Group25 (Nick);
CREATE INDEX ix_QQNick_Group93 On GroupData1.dbo.Group93 (Nick);
CREATE INDEX ix_QQNick_Group26 On GroupData1.dbo.Group26 (Nick);
CREATE INDEX ix_QQNick_Group94 On GroupData1.dbo.Group94 (Nick);
CREATE INDEX ix_QQNick_Group27 On GroupData1.dbo.Group27 (Nick);
CREATE INDEX ix_QQNick_Group95 On GroupData1.dbo.Group95 (Nick);
CREATE INDEX ix_QQNick_Group28 On GroupData1.dbo.Group28 (Nick);
CREATE INDEX ix_QQNick_Group96 On GroupData1.dbo.Group96 (Nick);
CREATE INDEX ix_QQNick_Group29 On GroupData1.dbo.Group29 (Nick);
CREATE INDEX ix_QQNick_Group97 On GroupData1.dbo.Group97 (Nick);
CREATE INDEX ix_QQNick_Group30 On GroupData1.dbo.Group30 (Nick);
CREATE INDEX ix_QQNick_Group98 On GroupData1.dbo.Group98 (Nick);
CREATE INDEX ix_QQNick_Group31 On GroupData1.dbo.Group31 (Nick);
CREATE INDEX ix_QQNick_Group99 On GroupData1.dbo.Group99 (Nick);
CREATE INDEX ix_QQNick_Group32 On GroupData1.dbo.Group32 (Nick);
CREATE INDEX ix_QQNick_Group100 On GroupData1.dbo.Group100 (Nick);
CREATE INDEX ix_QQNick_Group33 On GroupData1.dbo.Group33 (Nick);
CREATE INDEX ix_QQNick_Group34 On GroupData1.dbo.Group34 (Nick);
CREATE INDEX ix_QQNick_Group35 On GroupData1.dbo.Group35 (Nick);
CREATE INDEX ix_QQNick_Group36 On GroupData1.dbo.Group36 (Nick);
CREATE INDEX ix_QQNick_Group37 On GroupData1.dbo.Group37 (Nick);
CREATE INDEX ix_QQNick_Group38 On GroupData1.dbo.Group38 (Nick);
CREATE INDEX ix_QQNick_Group39 On GroupData1.dbo.Group39 (Nick);
CREATE INDEX ix_QQNick_Group40 On GroupData1.dbo.Group40 (Nick);
CREATE INDEX ix_QQNick_Group41 On GroupData1.dbo.Group41 (Nick);
CREATE INDEX ix_QQNick_Group42 On GroupData1.dbo.Group42 (Nick);
CREATE INDEX ix_QQNick_Group43 On GroupData1.dbo.Group43 (Nick);
CREATE INDEX ix_QQNick_Group44 On GroupData1.dbo.Group44 (Nick);
CREATE INDEX ix_QQNick_Group45 On GroupData1.dbo.Group45 (Nick);
CREATE INDEX ix_QQNick_Group46 On GroupData1.dbo.Group46 (Nick);
CREATE INDEX ix_QQNick_Group47 On GroupData1.dbo.Group47 (Nick);
CREATE INDEX ix_QQNick_Group48 On GroupData1.dbo.Group48 (Nick);
CREATE INDEX ix_QQNick_Group49 On GroupData1.dbo.Group49 (Nick);
CREATE INDEX ix_QQNick_Group50 On GroupData1.dbo.Group50 (Nick);
CREATE INDEX ix_QQNick_Group51 On GroupData1.dbo.Group51 (Nick);
CREATE INDEX ix_QQNick_Group52 On GroupData1.dbo.Group52 (Nick);
CREATE INDEX ix_QQNick_Group53 On GroupData1.dbo.Group53 (Nick);
CREATE INDEX ix_QQNick_Group54 On GroupData1.dbo.Group54 (Nick);
CREATE INDEX ix_QQNick_Group55 On GroupData1.dbo.Group55 (Nick);
CREATE INDEX ix_QQNick_Group56 On GroupData1.dbo.Group56 (Nick);
CREATE INDEX ix_QQNick_Group57 On GroupData1.dbo.Group57 (Nick);
CREATE INDEX ix_QQNick_Group58 On GroupData1.dbo.Group58 (Nick);
CREATE INDEX ix_QQNick_Group59 On GroupData1.dbo.Group59 (Nick);
CREATE INDEX ix_QQNick_Group60 On GroupData1.dbo.Group60 (Nick);
CREATE INDEX ix_QQNick_Group61 On GroupData1.dbo.Group61 (Nick);
CREATE INDEX ix_QQNick_Group62 On GroupData1.dbo.Group62 (Nick);
CREATE INDEX ix_QQNick_Group63 On GroupData1.dbo.Group63 (Nick);
CREATE INDEX ix_QQNick_Group64 On GroupData1.dbo.Group64 (Nick);
CREATE INDEX ix_QQNick_Group65 On GroupData1.dbo.Group65 (Nick);
CREATE INDEX ix_QQNick_Group66 On GroupData1.dbo.Group66 (Nick);
CREATE INDEX ix_QQNick_Group67 On GroupData1.dbo.Group67 (Nick);
CREATE INDEX ix_QQNick_Group68 On GroupData1.dbo.Group68 (Nick);
CREATE INDEX ix_QQNick_Group1 On GroupData1.dbo.Group1 (Nick);
CREATE INDEX ix_QQNick_Group69 On GroupData1.dbo.Group69 (Nick);
CREATE INDEX ix_QQNick_Group2 On GroupData1.dbo.Group2 (Nick);
CREATE INDEX ix_QQNick_Group70 On GroupData1.dbo.Group70 (Nick);
CREATE INDEX ix_QQNick_Group3 On GroupData1.dbo.Group3 (Nick);
CREATE INDEX ix_QQNick_Group71 On GroupData1.dbo.Group71 (Nick);
CREATE INDEX ix_QQNick_Group4 On GroupData1.dbo.Group4 (Nick);
CREATE INDEX ix_QQNick_Group72 On GroupData1.dbo.Group72 (Nick);
CREATE INDEX ix_QQNick_Group5 On GroupData1.dbo.Group5 (Nick);
CREATE INDEX ix_QQNick_Group73 On GroupData1.dbo.Group73 (Nick);
CREATE INDEX ix_QQNick_Group6 On GroupData1.dbo.Group6 (Nick);
CREATE INDEX ix_QQNick_Group174 On GroupData2.dbo.Group174 (Nick);
CREATE INDEX ix_QQNick_Group107 On GroupData2.dbo.Group107 (Nick);
CREATE INDEX ix_QQNick_Group175 On GroupData2.dbo.Group175 (Nick);
CREATE INDEX ix_QQNick_Group108 On GroupData2.dbo.Group108 (Nick);
CREATE INDEX ix_QQNick_Group176 On GroupData2.dbo.Group176 (Nick);
CREATE INDEX ix_QQNick_Group109 On GroupData2.dbo.Group109 (Nick);
CREATE INDEX ix_QQNick_Group177 On GroupData2.dbo.Group177 (Nick);
CREATE INDEX ix_QQNick_Group110 On GroupData2.dbo.Group110 (Nick);
CREATE INDEX ix_QQNick_Group178 On GroupData2.dbo.Group178 (Nick);
CREATE INDEX ix_QQNick_Group111 On GroupData2.dbo.Group111 (Nick);
CREATE INDEX ix_QQNick_Group179 On GroupData2.dbo.Group179 (Nick);
CREATE INDEX ix_QQNick_Group112 On GroupData2.dbo.Group112 (Nick);
CREATE INDEX ix_QQNick_Group180 On GroupData2.dbo.Group180 (Nick);
CREATE INDEX ix_QQNick_Group113 On GroupData2.dbo.Group113 (Nick);
CREATE INDEX ix_QQNick_Group181 On GroupData2.dbo.Group181 (Nick);
CREATE INDEX ix_QQNick_Group114 On GroupData2.dbo.Group114 (Nick);
CREATE INDEX ix_QQNick_Group182 On GroupData2.dbo.Group182 (Nick);
CREATE INDEX ix_QQNick_Group115 On GroupData2.dbo.Group115 (Nick);
CREATE INDEX ix_QQNick_Group183 On GroupData2.dbo.Group183 (Nick);
CREATE INDEX ix_QQNick_Group116 On GroupData2.dbo.Group116 (Nick);
CREATE INDEX ix_QQNick_Group184 On GroupData2.dbo.Group184 (Nick);
CREATE INDEX ix_QQNick_Group117 On GroupData2.dbo.Group117 (Nick);
CREATE INDEX ix_QQNick_Group185 On GroupData2.dbo.Group185 (Nick);
CREATE INDEX ix_QQNick_Group118 On GroupData2.dbo.Group118 (Nick);
CREATE INDEX ix_QQNick_Group186 On GroupData2.dbo.Group186 (Nick);
CREATE INDEX ix_QQNick_Group119 On GroupData2.dbo.Group119 (Nick);
CREATE INDEX ix_QQNick_Group187 On GroupData2.dbo.Group187 (Nick);
CREATE INDEX ix_QQNick_Group120 On GroupData2.dbo.Group120 (Nick);
CREATE INDEX ix_QQNick_Group188 On GroupData2.dbo.Group188 (Nick);
CREATE INDEX ix_QQNick_Group121 On GroupData2.dbo.Group121 (Nick);
CREATE INDEX ix_QQNick_Group189 On GroupData2.dbo.Group189 (Nick);
CREATE INDEX ix_QQNick_Group122 On GroupData2.dbo.Group122 (Nick);
CREATE INDEX ix_QQNick_Group190 On GroupData2.dbo.Group190 (Nick);
CREATE INDEX ix_QQNick_Group123 On GroupData2.dbo.Group123 (Nick);
CREATE INDEX ix_QQNick_Group191 On GroupData2.dbo.Group191 (Nick);
CREATE INDEX ix_QQNick_Group124 On GroupData2.dbo.Group124 (Nick);
CREATE INDEX ix_QQNick_Group192 On GroupData2.dbo.Group192 (Nick);
CREATE INDEX ix_QQNick_Group125 On GroupData2.dbo.Group125 (Nick);
CREATE INDEX ix_QQNick_Group193 On GroupData2.dbo.Group193 (Nick);
CREATE INDEX ix_QQNick_Group126 On GroupData2.dbo.Group126 (Nick);
CREATE INDEX ix_QQNick_Group194 On GroupData2.dbo.Group194 (Nick);
CREATE INDEX ix_QQNick_Group127 On GroupData2.dbo.Group127 (Nick);
CREATE INDEX ix_QQNick_Group195 On GroupData2.dbo.Group195 (Nick);
CREATE INDEX ix_QQNick_Group128 On GroupData2.dbo.Group128 (Nick);
CREATE INDEX ix_QQNick_Group196 On GroupData2.dbo.Group196 (Nick);
CREATE INDEX ix_QQNick_Group129 On GroupData2.dbo.Group129 (Nick);
CREATE INDEX ix_QQNick_Group197 On GroupData2.dbo.Group197 (Nick);
CREATE INDEX ix_QQNick_Group130 On GroupData2.dbo.Group130 (Nick);
CREATE INDEX ix_QQNick_Group198 On GroupData2.dbo.Group198 (Nick);
CREATE INDEX ix_QQNick_Group131 On GroupData2.dbo.Group131 (Nick);
CREATE INDEX ix_QQNick_Group199 On GroupData2.dbo.Group199 (Nick);
CREATE INDEX ix_QQNick_Group132 On GroupData2.dbo.Group132 (Nick);
CREATE INDEX ix_QQNick_Group200 On GroupData2.dbo.Group200 (Nick);
CREATE INDEX ix_QQNick_Group133 On GroupData2.dbo.Group133 (Nick);
CREATE INDEX ix_QQNick_Group134 On GroupData2.dbo.Group134 (Nick);
CREATE INDEX ix_QQNick_Group135 On GroupData2.dbo.Group135 (Nick);
CREATE INDEX ix_QQNick_Group136 On GroupData2.dbo.Group136 (Nick);
CREATE INDEX ix_QQNick_Group137 On GroupData2.dbo.Group137 (Nick);
CREATE INDEX ix_QQNick_Group138 On GroupData2.dbo.Group138 (Nick);
CREATE INDEX ix_QQNick_Group139 On GroupData2.dbo.Group139 (Nick);
CREATE INDEX ix_QQNick_Group140 On GroupData2.dbo.Group140 (Nick);
CREATE INDEX ix_QQNick_Group141 On GroupData2.dbo.Group141 (Nick);
CREATE INDEX ix_QQNick_Group142 On GroupData2.dbo.Group142 (Nick);
CREATE INDEX ix_QQNick_Group143 On GroupData2.dbo.Group143 (Nick);
CREATE INDEX ix_QQNick_Group144 On GroupData2.dbo.Group144 (Nick);
CREATE INDEX ix_QQNick_Group145 On GroupData2.dbo.Group145 (Nick);
CREATE INDEX ix_QQNick_Group146 On GroupData2.dbo.Group146 (Nick);
CREATE INDEX ix_QQNick_Group147 On GroupData2.dbo.Group147 (Nick);
CREATE INDEX ix_QQNick_Group148 On GroupData2.dbo.Group148 (Nick);
CREATE INDEX ix_QQNick_Group149 On GroupData2.dbo.Group149 (Nick);
CREATE INDEX ix_QQNick_Group150 On GroupData2.dbo.Group150 (Nick);
CREATE INDEX ix_QQNick_Group151 On GroupData2.dbo.Group151 (Nick);
CREATE INDEX ix_QQNick_Group152 On GroupData2.dbo.Group152 (Nick);
CREATE INDEX ix_QQNick_Group153 On GroupData2.dbo.Group153 (Nick);
CREATE INDEX ix_QQNick_Group154 On GroupData2.dbo.Group154 (Nick);
CREATE INDEX ix_QQNick_Group155 On GroupData2.dbo.Group155 (Nick);
CREATE INDEX ix_QQNick_Group156 On GroupData2.dbo.Group156 (Nick);
CREATE INDEX ix_QQNick_Group157 On GroupData2.dbo.Group157 (Nick);
CREATE INDEX ix_QQNick_Group158 On GroupData2.dbo.Group158 (Nick);
CREATE INDEX ix_QQNick_Group159 On GroupData2.dbo.Group159 (Nick);
CREATE INDEX ix_QQNick_Group160 On GroupData2.dbo.Group160 (Nick);
CREATE INDEX ix_QQNick_Group161 On GroupData2.dbo.Group161 (Nick);
CREATE INDEX ix_QQNick_Group162 On GroupData2.dbo.Group162 (Nick);
CREATE INDEX ix_QQNick_Group163 On GroupData2.dbo.Group163 (Nick);
CREATE INDEX ix_QQNick_Group164 On GroupData2.dbo.Group164 (Nick);
CREATE INDEX ix_QQNick_Group165 On GroupData2.dbo.Group165 (Nick);
CREATE INDEX ix_QQNick_Group166 On GroupData2.dbo.Group166 (Nick);
CREATE INDEX ix_QQNick_Group167 On GroupData2.dbo.Group167 (Nick);
CREATE INDEX ix_QQNick_Group168 On GroupData2.dbo.Group168 (Nick);
CREATE INDEX ix_QQNick_Group101 On GroupData2.dbo.Group101 (Nick);
CREATE INDEX ix_QQNick_Group169 On GroupData2.dbo.Group169 (Nick);
CREATE INDEX ix_QQNick_Group102 On GroupData2.dbo.Group102 (Nick);
CREATE INDEX ix_QQNick_Group170 On GroupData2.dbo.Group170 (Nick);
CREATE INDEX ix_QQNick_Group103 On GroupData2.dbo.Group103 (Nick);
CREATE INDEX ix_QQNick_Group171 On GroupData2.dbo.Group171 (Nick);
CREATE INDEX ix_QQNick_Group104 On GroupData2.dbo.Group104 (Nick);
CREATE INDEX ix_QQNick_Group172 On GroupData2.dbo.Group172 (Nick);
CREATE INDEX ix_QQNick_Group105 On GroupData2.dbo.Group105 (Nick);
CREATE INDEX ix_QQNick_Group173 On GroupData2.dbo.Group173 (Nick);
CREATE INDEX ix_QQNick_Group106 On GroupData2.dbo.Group106 (Nick);
CREATE INDEX ix_QQNick_Group274 On GroupData3.dbo.Group274 (Nick);
CREATE INDEX ix_QQNick_Group207 On GroupData3.dbo.Group207 (Nick);
CREATE INDEX ix_QQNick_Group275 On GroupData3.dbo.Group275 (Nick);
CREATE INDEX ix_QQNick_Group208 On GroupData3.dbo.Group208 (Nick);
CREATE INDEX ix_QQNick_Group276 On GroupData3.dbo.Group276 (Nick);
CREATE INDEX ix_QQNick_Group209 On GroupData3.dbo.Group209 (Nick);
CREATE INDEX ix_QQNick_Group277 On GroupData3.dbo.Group277 (Nick);
CREATE INDEX ix_QQNick_Group210 On GroupData3.dbo.Group210 (Nick);
CREATE INDEX ix_QQNick_Group278 On GroupData3.dbo.Group278 (Nick);
CREATE INDEX ix_QQNick_Group211 On GroupData3.dbo.Group211 (Nick);
CREATE INDEX ix_QQNick_Group279 On GroupData3.dbo.Group279 (Nick);
CREATE INDEX ix_QQNick_Group212 On GroupData3.dbo.Group212 (Nick);
CREATE INDEX ix_QQNick_Group280 On GroupData3.dbo.Group280 (Nick);
CREATE INDEX ix_QQNick_Group213 On GroupData3.dbo.Group213 (Nick);
CREATE INDEX ix_QQNick_Group281 On GroupData3.dbo.Group281 (Nick);
CREATE INDEX ix_QQNick_Group214 On GroupData3.dbo.Group214 (Nick);
CREATE INDEX ix_QQNick_Group282 On GroupData3.dbo.Group282 (Nick);
CREATE INDEX ix_QQNick_Group215 On GroupData3.dbo.Group215 (Nick);
CREATE INDEX ix_QQNick_Group283 On GroupData3.dbo.Group283 (Nick);
CREATE INDEX ix_QQNick_Group216 On GroupData3.dbo.Group216 (Nick);
CREATE INDEX ix_QQNick_Group284 On GroupData3.dbo.Group284 (Nick);
CREATE INDEX ix_QQNick_Group217 On GroupData3.dbo.Group217 (Nick);
CREATE INDEX ix_QQNick_Group285 On GroupData3.dbo.Group285 (Nick);
CREATE INDEX ix_QQNick_Group218 On GroupData3.dbo.Group218 (Nick);
CREATE INDEX ix_QQNick_Group286 On GroupData3.dbo.Group286 (Nick);
CREATE INDEX ix_QQNick_Group219 On GroupData3.dbo.Group219 (Nick);
CREATE INDEX ix_QQNick_Group287 On GroupData3.dbo.Group287 (Nick);
CREATE INDEX ix_QQNick_Group220 On GroupData3.dbo.Group220 (Nick);
CREATE INDEX ix_QQNick_Group288 On GroupData3.dbo.Group288 (Nick);
CREATE INDEX ix_QQNick_Group221 On GroupData3.dbo.Group221 (Nick);
CREATE INDEX ix_QQNick_Group289 On GroupData3.dbo.Group289 (Nick);
CREATE INDEX ix_QQNick_Group222 On GroupData3.dbo.Group222 (Nick);
CREATE INDEX ix_QQNick_Group290 On GroupData3.dbo.Group290 (Nick);
CREATE INDEX ix_QQNick_Group223 On GroupData3.dbo.Group223 (Nick);
CREATE INDEX ix_QQNick_Group291 On GroupData3.dbo.Group291 (Nick);
CREATE INDEX ix_QQNick_Group224 On GroupData3.dbo.Group224 (Nick);
CREATE INDEX ix_QQNick_Group292 On GroupData3.dbo.Group292 (Nick);
CREATE INDEX ix_QQNick_Group225 On GroupData3.dbo.Group225 (Nick);
CREATE INDEX ix_QQNick_Group293 On GroupData3.dbo.Group293 (Nick);
CREATE INDEX ix_QQNick_Group226 On GroupData3.dbo.Group226 (Nick);
CREATE INDEX ix_QQNick_Group294 On GroupData3.dbo.Group294 (Nick);
CREATE INDEX ix_QQNick_Group227 On GroupData3.dbo.Group227 (Nick);
CREATE INDEX ix_QQNick_Group295 On GroupData3.dbo.Group295 (Nick);
CREATE INDEX ix_QQNick_Group228 On GroupData3.dbo.Group228 (Nick);
CREATE INDEX ix_QQNick_Group296 On GroupData3.dbo.Group296 (Nick);
CREATE INDEX ix_QQNick_Group229 On GroupData3.dbo.Group229 (Nick);
CREATE INDEX ix_QQNick_Group297 On GroupData3.dbo.Group297 (Nick);
CREATE INDEX ix_QQNick_Group230 On GroupData3.dbo.Group230 (Nick);
CREATE INDEX ix_QQNick_Group298 On GroupData3.dbo.Group298 (Nick);
CREATE INDEX ix_QQNick_Group231 On GroupData3.dbo.Group231 (Nick);
CREATE INDEX ix_QQNick_Group299 On GroupData3.dbo.Group299 (Nick);
CREATE INDEX ix_QQNick_Group232 On GroupData3.dbo.Group232 (Nick);
CREATE INDEX ix_QQNick_Group300 On GroupData3.dbo.Group300 (Nick);
CREATE INDEX ix_QQNick_Group233 On GroupData3.dbo.Group233 (Nick);
CREATE INDEX ix_QQNick_Group234 On GroupData3.dbo.Group234 (Nick);
CREATE INDEX ix_QQNick_Group235 On GroupData3.dbo.Group235 (Nick);
CREATE INDEX ix_QQNick_Group236 On GroupData3.dbo.Group236 (Nick);
CREATE INDEX ix_QQNick_Group237 On GroupData3.dbo.Group237 (Nick);
CREATE INDEX ix_QQNick_Group238 On GroupData3.dbo.Group238 (Nick);
CREATE INDEX ix_QQNick_Group239 On GroupData3.dbo.Group239 (Nick);
CREATE INDEX ix_QQNick_Group240 On GroupData3.dbo.Group240 (Nick);
CREATE INDEX ix_QQNick_Group241 On GroupData3.dbo.Group241 (Nick);
CREATE INDEX ix_QQNick_Group242 On GroupData3.dbo.Group242 (Nick);
CREATE INDEX ix_QQNick_Group243 On GroupData3.dbo.Group243 (Nick);
CREATE INDEX ix_QQNick_Group244 On GroupData3.dbo.Group244 (Nick);
CREATE INDEX ix_QQNick_Group245 On GroupData3.dbo.Group245 (Nick);
CREATE INDEX ix_QQNick_Group246 On GroupData3.dbo.Group246 (Nick);
CREATE INDEX ix_QQNick_Group247 On GroupData3.dbo.Group247 (Nick);
CREATE INDEX ix_QQNick_Group248 On GroupData3.dbo.Group248 (Nick);
CREATE INDEX ix_QQNick_Group249 On GroupData3.dbo.Group249 (Nick);
CREATE INDEX ix_QQNick_Group250 On GroupData3.dbo.Group250 (Nick);
CREATE INDEX ix_QQNick_Group251 On GroupData3.dbo.Group251 (Nick);
CREATE INDEX ix_QQNick_Group252 On GroupData3.dbo.Group252 (Nick);
CREATE INDEX ix_QQNick_Group253 On GroupData3.dbo.Group253 (Nick);
CREATE INDEX ix_QQNick_Group254 On GroupData3.dbo.Group254 (Nick);
CREATE INDEX ix_QQNick_Group255 On GroupData3.dbo.Group255 (Nick);
CREATE INDEX ix_QQNick_Group256 On GroupData3.dbo.Group256 (Nick);
CREATE INDEX ix_QQNick_Group257 On GroupData3.dbo.Group257 (Nick);
CREATE INDEX ix_QQNick_Group258 On GroupData3.dbo.Group258 (Nick);
CREATE INDEX ix_QQNick_Group259 On GroupData3.dbo.Group259 (Nick);
CREATE INDEX ix_QQNick_Group260 On GroupData3.dbo.Group260 (Nick);
CREATE INDEX ix_QQNick_Group261 On GroupData3.dbo.Group261 (Nick);
CREATE INDEX ix_QQNick_Group262 On GroupData3.dbo.Group262 (Nick);
CREATE INDEX ix_QQNick_Group263 On GroupData3.dbo.Group263 (Nick);
CREATE INDEX ix_QQNick_Group264 On GroupData3.dbo.Group264 (Nick);
CREATE INDEX ix_QQNick_Group265 On GroupData3.dbo.Group265 (Nick);
CREATE INDEX ix_QQNick_Group266 On GroupData3.dbo.Group266 (Nick);
CREATE INDEX ix_QQNick_Group267 On GroupData3.dbo.Group267 (Nick);
CREATE INDEX ix_QQNick_Group268 On GroupData3.dbo.Group268 (Nick);
CREATE INDEX ix_QQNick_Group201 On GroupData3.dbo.Group201 (Nick);
CREATE INDEX ix_QQNick_Group269 On GroupData3.dbo.Group269 (Nick);
CREATE INDEX ix_QQNick_Group202 On GroupData3.dbo.Group202 (Nick);
CREATE INDEX ix_QQNick_Group270 On GroupData3.dbo.Group270 (Nick);
CREATE INDEX ix_QQNick_Group203 On GroupData3.dbo.Group203 (Nick);
CREATE INDEX ix_QQNick_Group271 On GroupData3.dbo.Group271 (Nick);
CREATE INDEX ix_QQNick_Group204 On GroupData3.dbo.Group204 (Nick);
CREATE INDEX ix_QQNick_Group272 On GroupData3.dbo.Group272 (Nick);
CREATE INDEX ix_QQNick_Group205 On GroupData3.dbo.Group205 (Nick);
CREATE INDEX ix_QQNick_Group273 On GroupData3.dbo.Group273 (Nick);
CREATE INDEX ix_QQNick_Group206 On GroupData3.dbo.Group206 (Nick);
CREATE INDEX ix_QQNick_Group374 On GroupData4.dbo.Group374 (Nick);
CREATE INDEX ix_QQNick_Group307 On GroupData4.dbo.Group307 (Nick);
CREATE INDEX ix_QQNick_Group375 On GroupData4.dbo.Group375 (Nick);
CREATE INDEX ix_QQNick_Group308 On GroupData4.dbo.Group308 (Nick);
CREATE INDEX ix_QQNick_Group376 On GroupData4.dbo.Group376 (Nick);
CREATE INDEX ix_QQNick_Group309 On GroupData4.dbo.Group309 (Nick);
CREATE INDEX ix_QQNick_Group377 On GroupData4.dbo.Group377 (Nick);
CREATE INDEX ix_QQNick_Group310 On GroupData4.dbo.Group310 (Nick);
CREATE INDEX ix_QQNick_Group378 On GroupData4.dbo.Group378 (Nick);
CREATE INDEX ix_QQNick_Group311 On GroupData4.dbo.Group311 (Nick);
CREATE INDEX ix_QQNick_Group379 On GroupData4.dbo.Group379 (Nick);
CREATE INDEX ix_QQNick_Group312 On GroupData4.dbo.Group312 (Nick);
CREATE INDEX ix_QQNick_Group380 On GroupData4.dbo.Group380 (Nick);
CREATE INDEX ix_QQNick_Group313 On GroupData4.dbo.Group313 (Nick);
CREATE INDEX ix_QQNick_Group381 On GroupData4.dbo.Group381 (Nick);
CREATE INDEX ix_QQNick_Group314 On GroupData4.dbo.Group314 (Nick);
CREATE INDEX ix_QQNick_Group382 On GroupData4.dbo.Group382 (Nick);
CREATE INDEX ix_QQNick_Group315 On GroupData4.dbo.Group315 (Nick);
CREATE INDEX ix_QQNick_Group383 On GroupData4.dbo.Group383 (Nick);
CREATE INDEX ix_QQNick_Group316 On GroupData4.dbo.Group316 (Nick);
CREATE INDEX ix_QQNick_Group384 On GroupData4.dbo.Group384 (Nick);
CREATE INDEX ix_QQNick_Group317 On GroupData4.dbo.Group317 (Nick);
CREATE INDEX ix_QQNick_Group385 On GroupData4.dbo.Group385 (Nick);
CREATE INDEX ix_QQNick_Group318 On GroupData4.dbo.Group318 (Nick);
CREATE INDEX ix_QQNick_Group386 On GroupData4.dbo.Group386 (Nick);
CREATE INDEX ix_QQNick_Group319 On GroupData4.dbo.Group319 (Nick);
CREATE INDEX ix_QQNick_Group387 On GroupData4.dbo.Group387 (Nick);
CREATE INDEX ix_QQNick_Group320 On GroupData4.dbo.Group320 (Nick);
CREATE INDEX ix_QQNick_Group388 On GroupData4.dbo.Group388 (Nick);
CREATE INDEX ix_QQNick_Group321 On GroupData4.dbo.Group321 (Nick);
CREATE INDEX ix_QQNick_Group389 On GroupData4.dbo.Group389 (Nick);
CREATE INDEX ix_QQNick_Group322 On GroupData4.dbo.Group322 (Nick);
CREATE INDEX ix_QQNick_Group390 On GroupData4.dbo.Group390 (Nick);
CREATE INDEX ix_QQNick_Group323 On GroupData4.dbo.Group323 (Nick);
CREATE INDEX ix_QQNick_Group391 On GroupData4.dbo.Group391 (Nick);
CREATE INDEX ix_QQNick_Group324 On GroupData4.dbo.Group324 (Nick);
CREATE INDEX ix_QQNick_Group392 On GroupData4.dbo.Group392 (Nick);
CREATE INDEX ix_QQNick_Group325 On GroupData4.dbo.Group325 (Nick);
CREATE INDEX ix_QQNick_Group393 On GroupData4.dbo.Group393 (Nick);
CREATE INDEX ix_QQNick_Group326 On GroupData4.dbo.Group326 (Nick);
CREATE INDEX ix_QQNick_Group394 On GroupData4.dbo.Group394 (Nick);
CREATE INDEX ix_QQNick_Group327 On GroupData4.dbo.Group327 (Nick);
CREATE INDEX ix_QQNick_Group395 On GroupData4.dbo.Group395 (Nick);
CREATE INDEX ix_QQNick_Group328 On GroupData4.dbo.Group328 (Nick);
CREATE INDEX ix_QQNick_Group396 On GroupData4.dbo.Group396 (Nick);
CREATE INDEX ix_QQNick_Group329 On GroupData4.dbo.Group329 (Nick);
CREATE INDEX ix_QQNick_Group397 On GroupData4.dbo.Group397 (Nick);
CREATE INDEX ix_QQNick_Group330 On GroupData4.dbo.Group330 (Nick);
CREATE INDEX ix_QQNick_Group398 On GroupData4.dbo.Group398 (Nick);
CREATE INDEX ix_QQNick_Group331 On GroupData4.dbo.Group331 (Nick);
CREATE INDEX ix_QQNick_Group399 On GroupData4.dbo.Group399 (Nick);
CREATE INDEX ix_QQNick_Group332 On GroupData4.dbo.Group332 (Nick);
CREATE INDEX ix_QQNick_Group400 On GroupData4.dbo.Group400 (Nick);
CREATE INDEX ix_QQNick_Group333 On GroupData4.dbo.Group333 (Nick);
CREATE INDEX ix_QQNick_Group334 On GroupData4.dbo.Group334 (Nick);
CREATE INDEX ix_QQNick_Group335 On GroupData4.dbo.Group335 (Nick);
CREATE INDEX ix_QQNick_Group336 On GroupData4.dbo.Group336 (Nick);
CREATE INDEX ix_QQNick_Group337 On GroupData4.dbo.Group337 (Nick);
CREATE INDEX ix_QQNick_Group338 On GroupData4.dbo.Group338 (Nick);
CREATE INDEX ix_QQNick_Group339 On GroupData4.dbo.Group339 (Nick);
CREATE INDEX ix_QQNick_Group340 On GroupData4.dbo.Group340 (Nick);
CREATE INDEX ix_QQNick_Group341 On GroupData4.dbo.Group341 (Nick);
CREATE INDEX ix_QQNick_Group342 On GroupData4.dbo.Group342 (Nick);
CREATE INDEX ix_QQNick_Group343 On GroupData4.dbo.Group343 (Nick);
CREATE INDEX ix_QQNick_Group344 On GroupData4.dbo.Group344 (Nick);
CREATE INDEX ix_QQNick_Group345 On GroupData4.dbo.Group345 (Nick);
CREATE INDEX ix_QQNick_Group346 On GroupData4.dbo.Group346 (Nick);
CREATE INDEX ix_QQNick_Group347 On GroupData4.dbo.Group347 (Nick);
CREATE INDEX ix_QQNick_Group348 On GroupData4.dbo.Group348 (Nick);
CREATE INDEX ix_QQNick_Group349 On GroupData4.dbo.Group349 (Nick);
CREATE INDEX ix_QQNick_Group350 On GroupData4.dbo.Group350 (Nick);
CREATE INDEX ix_QQNick_Group351 On GroupData4.dbo.Group351 (Nick);
CREATE INDEX ix_QQNick_Group352 On GroupData4.dbo.Group352 (Nick);
CREATE INDEX ix_QQNick_Group353 On GroupData4.dbo.Group353 (Nick);
CREATE INDEX ix_QQNick_Group354 On GroupData4.dbo.Group354 (Nick);
CREATE INDEX ix_QQNick_Group355 On GroupData4.dbo.Group355 (Nick);
CREATE INDEX ix_QQNick_Group356 On GroupData4.dbo.Group356 (Nick);
CREATE INDEX ix_QQNick_Group357 On GroupData4.dbo.Group357 (Nick);
CREATE INDEX ix_QQNick_Group358 On GroupData4.dbo.Group358 (Nick);
CREATE INDEX ix_QQNick_Group359 On GroupData4.dbo.Group359 (Nick);
CREATE INDEX ix_QQNick_Group360 On GroupData4.dbo.Group360 (Nick);
CREATE INDEX ix_QQNick_Group361 On GroupData4.dbo.Group361 (Nick);
CREATE INDEX ix_QQNick_Group362 On GroupData4.dbo.Group362 (Nick);
CREATE INDEX ix_QQNick_Group363 On GroupData4.dbo.Group363 (Nick);
CREATE INDEX ix_QQNick_Group364 On GroupData4.dbo.Group364 (Nick);
CREATE INDEX ix_QQNick_Group365 On GroupData4.dbo.Group365 (Nick);
CREATE INDEX ix_QQNick_Group366 On GroupData4.dbo.Group366 (Nick);
CREATE INDEX ix_QQNick_Group367 On GroupData4.dbo.Group367 (Nick);
CREATE INDEX ix_QQNick_Group368 On GroupData4.dbo.Group368 (Nick);
CREATE INDEX ix_QQNick_Group301 On GroupData4.dbo.Group301 (Nick);
CREATE INDEX ix_QQNick_Group369 On GroupData4.dbo.Group369 (Nick);
CREATE INDEX ix_QQNick_Group302 On GroupData4.dbo.Group302 (Nick);
CREATE INDEX ix_QQNick_Group370 On GroupData4.dbo.Group370 (Nick);
CREATE INDEX ix_QQNick_Group303 On GroupData4.dbo.Group303 (Nick);
CREATE INDEX ix_QQNick_Group371 On GroupData4.dbo.Group371 (Nick);
CREATE INDEX ix_QQNick_Group304 On GroupData4.dbo.Group304 (Nick);
CREATE INDEX ix_QQNick_Group372 On GroupData4.dbo.Group372 (Nick);
CREATE INDEX ix_QQNick_Group305 On GroupData4.dbo.Group305 (Nick);
CREATE INDEX ix_QQNick_Group373 On GroupData4.dbo.Group373 (Nick);
CREATE INDEX ix_QQNick_Group306 On GroupData4.dbo.Group306 (Nick);
CREATE INDEX ix_QQNick_Group474 On GroupData5.dbo.Group474 (Nick);
CREATE INDEX ix_QQNick_Group407 On GroupData5.dbo.Group407 (Nick);
CREATE INDEX ix_QQNick_Group475 On GroupData5.dbo.Group475 (Nick);
CREATE INDEX ix_QQNick_Group408 On GroupData5.dbo.Group408 (Nick);
CREATE INDEX ix_QQNick_Group476 On GroupData5.dbo.Group476 (Nick);
CREATE INDEX ix_QQNick_Group409 On GroupData5.dbo.Group409 (Nick);
CREATE INDEX ix_QQNick_Group477 On GroupData5.dbo.Group477 (Nick);
CREATE INDEX ix_QQNick_Group410 On GroupData5.dbo.Group410 (Nick);
CREATE INDEX ix_QQNick_Group478 On GroupData5.dbo.Group478 (Nick);
CREATE INDEX ix_QQNick_Group411 On GroupData5.dbo.Group411 (Nick);
CREATE INDEX ix_QQNick_Group479 On GroupData5.dbo.Group479 (Nick);
CREATE INDEX ix_QQNick_Group412 On GroupData5.dbo.Group412 (Nick);
CREATE INDEX ix_QQNick_Group480 On GroupData5.dbo.Group480 (Nick);
CREATE INDEX ix_QQNick_Group413 On GroupData5.dbo.Group413 (Nick);
CREATE INDEX ix_QQNick_Group481 On GroupData5.dbo.Group481 (Nick);
CREATE INDEX ix_QQNick_Group414 On GroupData5.dbo.Group414 (Nick);
CREATE INDEX ix_QQNick_Group482 On GroupData5.dbo.Group482 (Nick);
CREATE INDEX ix_QQNick_Group415 On GroupData5.dbo.Group415 (Nick);
CREATE INDEX ix_QQNick_Group483 On GroupData5.dbo.Group483 (Nick);
CREATE INDEX ix_QQNick_Group416 On GroupData5.dbo.Group416 (Nick);
CREATE INDEX ix_QQNick_Group484 On GroupData5.dbo.Group484 (Nick);
CREATE INDEX ix_QQNick_Group417 On GroupData5.dbo.Group417 (Nick);
CREATE INDEX ix_QQNick_Group485 On GroupData5.dbo.Group485 (Nick);
CREATE INDEX ix_QQNick_Group418 On GroupData5.dbo.Group418 (Nick);
CREATE INDEX ix_QQNick_Group486 On GroupData5.dbo.Group486 (Nick);
CREATE INDEX ix_QQNick_Group419 On GroupData5.dbo.Group419 (Nick);
CREATE INDEX ix_QQNick_Group487 On GroupData5.dbo.Group487 (Nick);
CREATE INDEX ix_QQNick_Group420 On GroupData5.dbo.Group420 (Nick);
CREATE INDEX ix_QQNick_Group488 On GroupData5.dbo.Group488 (Nick);
CREATE INDEX ix_QQNick_Group421 On GroupData5.dbo.Group421 (Nick);
CREATE INDEX ix_QQNick_Group489 On GroupData5.dbo.Group489 (Nick);
CREATE INDEX ix_QQNick_Group422 On GroupData5.dbo.Group422 (Nick);
CREATE INDEX ix_QQNick_Group490 On GroupData5.dbo.Group490 (Nick);
CREATE INDEX ix_QQNick_Group423 On GroupData5.dbo.Group423 (Nick);
CREATE INDEX ix_QQNick_Group491 On GroupData5.dbo.Group491 (Nick);
CREATE INDEX ix_QQNick_Group424 On GroupData5.dbo.Group424 (Nick);
CREATE INDEX ix_QQNick_Group492 On GroupData5.dbo.Group492 (Nick);
CREATE INDEX ix_QQNick_Group425 On GroupData5.dbo.Group425 (Nick);
CREATE INDEX ix_QQNick_Group493 On GroupData5.dbo.Group493 (Nick);
CREATE INDEX ix_QQNick_Group426 On GroupData5.dbo.Group426 (Nick);
CREATE INDEX ix_QQNick_Group494 On GroupData5.dbo.Group494 (Nick);
CREATE INDEX ix_QQNick_Group427 On GroupData5.dbo.Group427 (Nick);
CREATE INDEX ix_QQNick_Group495 On GroupData5.dbo.Group495 (Nick);
CREATE INDEX ix_QQNick_Group428 On GroupData5.dbo.Group428 (Nick);
CREATE INDEX ix_QQNick_Group496 On GroupData5.dbo.Group496 (Nick);
CREATE INDEX ix_QQNick_Group429 On GroupData5.dbo.Group429 (Nick);
CREATE INDEX ix_QQNick_Group497 On GroupData5.dbo.Group497 (Nick);
CREATE INDEX ix_QQNick_Group430 On GroupData5.dbo.Group430 (Nick);
CREATE INDEX ix_QQNick_Group498 On GroupData5.dbo.Group498 (Nick);
CREATE INDEX ix_QQNick_Group431 On GroupData5.dbo.Group431 (Nick);
CREATE INDEX ix_QQNick_Group499 On GroupData5.dbo.Group499 (Nick);
CREATE INDEX ix_QQNick_Group432 On GroupData5.dbo.Group432 (Nick);
CREATE INDEX ix_QQNick_Group500 On GroupData5.dbo.Group500 (Nick);
CREATE INDEX ix_QQNick_Group433 On GroupData5.dbo.Group433 (Nick);
CREATE INDEX ix_QQNick_Group434 On GroupData5.dbo.Group434 (Nick);
CREATE INDEX ix_QQNick_Group435 On GroupData5.dbo.Group435 (Nick);
CREATE INDEX ix_QQNick_Group436 On GroupData5.dbo.Group436 (Nick);
CREATE INDEX ix_QQNick_Group437 On GroupData5.dbo.Group437 (Nick);
CREATE INDEX ix_QQNick_Group438 On GroupData5.dbo.Group438 (Nick);
CREATE INDEX ix_QQNick_Group439 On GroupData5.dbo.Group439 (Nick);
CREATE INDEX ix_QQNick_Group440 On GroupData5.dbo.Group440 (Nick);
CREATE INDEX ix_QQNick_Group441 On GroupData5.dbo.Group441 (Nick);
CREATE INDEX ix_QQNick_Group442 On GroupData5.dbo.Group442 (Nick);
CREATE INDEX ix_QQNick_Group443 On GroupData5.dbo.Group443 (Nick);
CREATE INDEX ix_QQNick_Group444 On GroupData5.dbo.Group444 (Nick);
CREATE INDEX ix_QQNick_Group445 On GroupData5.dbo.Group445 (Nick);
CREATE INDEX ix_QQNick_Group446 On GroupData5.dbo.Group446 (Nick);
CREATE INDEX ix_QQNick_Group447 On GroupData5.dbo.Group447 (Nick);
CREATE INDEX ix_QQNick_Group448 On GroupData5.dbo.Group448 (Nick);
CREATE INDEX ix_QQNick_Group449 On GroupData5.dbo.Group449 (Nick);
CREATE INDEX ix_QQNick_Group450 On GroupData5.dbo.Group450 (Nick);
CREATE INDEX ix_QQNick_Group451 On GroupData5.dbo.Group451 (Nick);
CREATE INDEX ix_QQNick_Group452 On GroupData5.dbo.Group452 (Nick);
CREATE INDEX ix_QQNick_Group453 On GroupData5.dbo.Group453 (Nick);
CREATE INDEX ix_QQNick_Group454 On GroupData5.dbo.Group454 (Nick);
CREATE INDEX ix_QQNick_Group455 On GroupData5.dbo.Group455 (Nick);
CREATE INDEX ix_QQNick_Group456 On GroupData5.dbo.Group456 (Nick);
CREATE INDEX ix_QQNick_Group457 On GroupData5.dbo.Group457 (Nick);
CREATE INDEX ix_QQNick_Group458 On GroupData5.dbo.Group458 (Nick);
CREATE INDEX ix_QQNick_Group459 On GroupData5.dbo.Group459 (Nick);
CREATE INDEX ix_QQNick_Group460 On GroupData5.dbo.Group460 (Nick);
CREATE INDEX ix_QQNick_Group461 On GroupData5.dbo.Group461 (Nick);
CREATE INDEX ix_QQNick_Group462 On GroupData5.dbo.Group462 (Nick);
CREATE INDEX ix_QQNick_Group463 On GroupData5.dbo.Group463 (Nick);
CREATE INDEX ix_QQNick_Group464 On GroupData5.dbo.Group464 (Nick);
CREATE INDEX ix_QQNick_Group465 On GroupData5.dbo.Group465 (Nick);
CREATE INDEX ix_QQNick_Group466 On GroupData5.dbo.Group466 (Nick);
CREATE INDEX ix_QQNick_Group467 On GroupData5.dbo.Group467 (Nick);
CREATE INDEX ix_QQNick_Group468 On GroupData5.dbo.Group468 (Nick);
CREATE INDEX ix_QQNick_Group401 On GroupData5.dbo.Group401 (Nick);
CREATE INDEX ix_QQNick_Group469 On GroupData5.dbo.Group469 (Nick);
CREATE INDEX ix_QQNick_Group402 On GroupData5.dbo.Group402 (Nick);
CREATE INDEX ix_QQNick_Group470 On GroupData5.dbo.Group470 (Nick);
CREATE INDEX ix_QQNick_Group403 On GroupData5.dbo.Group403 (Nick);
CREATE INDEX ix_QQNick_Group471 On GroupData5.dbo.Group471 (Nick);
CREATE INDEX ix_QQNick_Group404 On GroupData5.dbo.Group404 (Nick);
CREATE INDEX ix_QQNick_Group472 On GroupData5.dbo.Group472 (Nick);
CREATE INDEX ix_QQNick_Group405 On GroupData5.dbo.Group405 (Nick);
CREATE INDEX ix_QQNick_Group473 On GroupData5.dbo.Group473 (Nick);
CREATE INDEX ix_QQNick_Group406 On GroupData5.dbo.Group406 (Nick);
CREATE INDEX ix_QQNick_Group574 On GroupData6.dbo.Group574 (Nick);
CREATE INDEX ix_QQNick_Group507 On GroupData6.dbo.Group507 (Nick);
CREATE INDEX ix_QQNick_Group575 On GroupData6.dbo.Group575 (Nick);
CREATE INDEX ix_QQNick_Group508 On GroupData6.dbo.Group508 (Nick);
CREATE INDEX ix_QQNick_Group576 On GroupData6.dbo.Group576 (Nick);
CREATE INDEX ix_QQNick_Group509 On GroupData6.dbo.Group509 (Nick);
CREATE INDEX ix_QQNick_Group577 On GroupData6.dbo.Group577 (Nick);
CREATE INDEX ix_QQNick_Group510 On GroupData6.dbo.Group510 (Nick);
CREATE INDEX ix_QQNick_Group578 On GroupData6.dbo.Group578 (Nick);
CREATE INDEX ix_QQNick_Group511 On GroupData6.dbo.Group511 (Nick);
CREATE INDEX ix_QQNick_Group579 On GroupData6.dbo.Group579 (Nick);
CREATE INDEX ix_QQNick_Group512 On GroupData6.dbo.Group512 (Nick);
CREATE INDEX ix_QQNick_Group580 On GroupData6.dbo.Group580 (Nick);
CREATE INDEX ix_QQNick_Group513 On GroupData6.dbo.Group513 (Nick);
CREATE INDEX ix_QQNick_Group581 On GroupData6.dbo.Group581 (Nick);
CREATE INDEX ix_QQNick_Group514 On GroupData6.dbo.Group514 (Nick);
CREATE INDEX ix_QQNick_Group582 On GroupData6.dbo.Group582 (Nick);
CREATE INDEX ix_QQNick_Group515 On GroupData6.dbo.Group515 (Nick);
CREATE INDEX ix_QQNick_Group583 On GroupData6.dbo.Group583 (Nick);
CREATE INDEX ix_QQNick_Group516 On GroupData6.dbo.Group516 (Nick);
CREATE INDEX ix_QQNick_Group584 On GroupData6.dbo.Group584 (Nick);
CREATE INDEX ix_QQNick_Group517 On GroupData6.dbo.Group517 (Nick);
CREATE INDEX ix_QQNick_Group585 On GroupData6.dbo.Group585 (Nick);
CREATE INDEX ix_QQNick_Group518 On GroupData6.dbo.Group518 (Nick);
CREATE INDEX ix_QQNick_Group586 On GroupData6.dbo.Group586 (Nick);
CREATE INDEX ix_QQNick_Group519 On GroupData6.dbo.Group519 (Nick);
CREATE INDEX ix_QQNick_Group587 On GroupData6.dbo.Group587 (Nick);
CREATE INDEX ix_QQNick_Group520 On GroupData6.dbo.Group520 (Nick);
CREATE INDEX ix_QQNick_Group588 On GroupData6.dbo.Group588 (Nick);
CREATE INDEX ix_QQNick_Group521 On GroupData6.dbo.Group521 (Nick);
CREATE INDEX ix_QQNick_Group589 On GroupData6.dbo.Group589 (Nick);
CREATE INDEX ix_QQNick_Group522 On GroupData6.dbo.Group522 (Nick);
CREATE INDEX ix_QQNick_Group590 On GroupData6.dbo.Group590 (Nick);
CREATE INDEX ix_QQNick_Group523 On GroupData6.dbo.Group523 (Nick);
CREATE INDEX ix_QQNick_Group591 On GroupData6.dbo.Group591 (Nick);
CREATE INDEX ix_QQNick_Group524 On GroupData6.dbo.Group524 (Nick);
CREATE INDEX ix_QQNick_Group592 On GroupData6.dbo.Group592 (Nick);
CREATE INDEX ix_QQNick_Group525 On GroupData6.dbo.Group525 (Nick);
CREATE INDEX ix_QQNick_Group593 On GroupData6.dbo.Group593 (Nick);
CREATE INDEX ix_QQNick_Group526 On GroupData6.dbo.Group526 (Nick);
CREATE INDEX ix_QQNick_Group594 On GroupData6.dbo.Group594 (Nick);
CREATE INDEX ix_QQNick_Group527 On GroupData6.dbo.Group527 (Nick);
CREATE INDEX ix_QQNick_Group595 On GroupData6.dbo.Group595 (Nick);
CREATE INDEX ix_QQNick_Group528 On GroupData6.dbo.Group528 (Nick);
CREATE INDEX ix_QQNick_Group596 On GroupData6.dbo.Group596 (Nick);
CREATE INDEX ix_QQNick_Group529 On GroupData6.dbo.Group529 (Nick);
CREATE INDEX ix_QQNick_Group597 On GroupData6.dbo.Group597 (Nick);
CREATE INDEX ix_QQNick_Group530 On GroupData6.dbo.Group530 (Nick);
CREATE INDEX ix_QQNick_Group598 On GroupData6.dbo.Group598 (Nick);
CREATE INDEX ix_QQNick_Group531 On GroupData6.dbo.Group531 (Nick);
CREATE INDEX ix_QQNick_Group599 On GroupData6.dbo.Group599 (Nick);
CREATE INDEX ix_QQNick_Group532 On GroupData6.dbo.Group532 (Nick);
CREATE INDEX ix_QQNick_Group600 On GroupData6.dbo.Group600 (Nick);
CREATE INDEX ix_QQNick_Group533 On GroupData6.dbo.Group533 (Nick);
CREATE INDEX ix_QQNick_Group534 On GroupData6.dbo.Group534 (Nick);
CREATE INDEX ix_QQNick_Group535 On GroupData6.dbo.Group535 (Nick);
CREATE INDEX ix_QQNick_Group536 On GroupData6.dbo.Group536 (Nick);
CREATE INDEX ix_QQNick_Group537 On GroupData6.dbo.Group537 (Nick);
CREATE INDEX ix_QQNick_Group538 On GroupData6.dbo.Group538 (Nick);
CREATE INDEX ix_QQNick_Group539 On GroupData6.dbo.Group539 (Nick);
CREATE INDEX ix_QQNick_Group540 On GroupData6.dbo.Group540 (Nick);
CREATE INDEX ix_QQNick_Group541 On GroupData6.dbo.Group541 (Nick);
CREATE INDEX ix_QQNick_Group542 On GroupData6.dbo.Group542 (Nick);
CREATE INDEX ix_QQNick_Group543 On GroupData6.dbo.Group543 (Nick);
CREATE INDEX ix_QQNick_Group544 On GroupData6.dbo.Group544 (Nick);
CREATE INDEX ix_QQNick_Group545 On GroupData6.dbo.Group545 (Nick);
CREATE INDEX ix_QQNick_Group546 On GroupData6.dbo.Group546 (Nick);
CREATE INDEX ix_QQNick_Group547 On GroupData6.dbo.Group547 (Nick);
CREATE INDEX ix_QQNick_Group548 On GroupData6.dbo.Group548 (Nick);
CREATE INDEX ix_QQNick_Group549 On GroupData6.dbo.Group549 (Nick);
CREATE INDEX ix_QQNick_Group550 On GroupData6.dbo.Group550 (Nick);
CREATE INDEX ix_QQNick_Group551 On GroupData6.dbo.Group551 (Nick);
CREATE INDEX ix_QQNick_Group552 On GroupData6.dbo.Group552 (Nick);
CREATE INDEX ix_QQNick_Group553 On GroupData6.dbo.Group553 (Nick);
CREATE INDEX ix_QQNick_Group554 On GroupData6.dbo.Group554 (Nick);
CREATE INDEX ix_QQNick_Group555 On GroupData6.dbo.Group555 (Nick);
CREATE INDEX ix_QQNick_Group556 On GroupData6.dbo.Group556 (Nick);
CREATE INDEX ix_QQNick_Group557 On GroupData6.dbo.Group557 (Nick);
CREATE INDEX ix_QQNick_Group558 On GroupData6.dbo.Group558 (Nick);
CREATE INDEX ix_QQNick_Group559 On GroupData6.dbo.Group559 (Nick);
CREATE INDEX ix_QQNick_Group560 On GroupData6.dbo.Group560 (Nick);
CREATE INDEX ix_QQNick_Group561 On GroupData6.dbo.Group561 (Nick);
CREATE INDEX ix_QQNick_Group562 On GroupData6.dbo.Group562 (Nick);
CREATE INDEX ix_QQNick_Group563 On GroupData6.dbo.Group563 (Nick);
CREATE INDEX ix_QQNick_Group564 On GroupData6.dbo.Group564 (Nick);
CREATE INDEX ix_QQNick_Group565 On GroupData6.dbo.Group565 (Nick);
CREATE INDEX ix_QQNick_Group566 On GroupData6.dbo.Group566 (Nick);
CREATE INDEX ix_QQNick_Group567 On GroupData6.dbo.Group567 (Nick);
CREATE INDEX ix_QQNick_Group568 On GroupData6.dbo.Group568 (Nick);
CREATE INDEX ix_QQNick_Group501 On GroupData6.dbo.Group501 (Nick);
CREATE INDEX ix_QQNick_Group569 On GroupData6.dbo.Group569 (Nick);
CREATE INDEX ix_QQNick_Group502 On GroupData6.dbo.Group502 (Nick);
CREATE INDEX ix_QQNick_Group570 On GroupData6.dbo.Group570 (Nick);
CREATE INDEX ix_QQNick_Group503 On GroupData6.dbo.Group503 (Nick);
CREATE INDEX ix_QQNick_Group571 On GroupData6.dbo.Group571 (Nick);
CREATE INDEX ix_QQNick_Group504 On GroupData6.dbo.Group504 (Nick);
CREATE INDEX ix_QQNick_Group572 On GroupData6.dbo.Group572 (Nick);
CREATE INDEX ix_QQNick_Group505 On GroupData6.dbo.Group505 (Nick);
CREATE INDEX ix_QQNick_Group573 On GroupData6.dbo.Group573 (Nick);
CREATE INDEX ix_QQNick_Group506 On GroupData6.dbo.Group506 (Nick);
CREATE INDEX ix_QQNick_Group674 On GroupData7.dbo.Group674 (Nick);
CREATE INDEX ix_QQNick_Group607 On GroupData7.dbo.Group607 (Nick);
CREATE INDEX ix_QQNick_Group675 On GroupData7.dbo.Group675 (Nick);
CREATE INDEX ix_QQNick_Group608 On GroupData7.dbo.Group608 (Nick);
CREATE INDEX ix_QQNick_Group676 On GroupData7.dbo.Group676 (Nick);
CREATE INDEX ix_QQNick_Group609 On GroupData7.dbo.Group609 (Nick);
CREATE INDEX ix_QQNick_Group677 On GroupData7.dbo.Group677 (Nick);
CREATE INDEX ix_QQNick_Group610 On GroupData7.dbo.Group610 (Nick);
CREATE INDEX ix_QQNick_Group678 On GroupData7.dbo.Group678 (Nick);
CREATE INDEX ix_QQNick_Group611 On GroupData7.dbo.Group611 (Nick);
CREATE INDEX ix_QQNick_Group679 On GroupData7.dbo.Group679 (Nick);
CREATE INDEX ix_QQNick_Group612 On GroupData7.dbo.Group612 (Nick);
CREATE INDEX ix_QQNick_Group680 On GroupData7.dbo.Group680 (Nick);
CREATE INDEX ix_QQNick_Group613 On GroupData7.dbo.Group613 (Nick);
CREATE INDEX ix_QQNick_Group681 On GroupData7.dbo.Group681 (Nick);
CREATE INDEX ix_QQNick_Group614 On GroupData7.dbo.Group614 (Nick);
CREATE INDEX ix_QQNick_Group682 On GroupData7.dbo.Group682 (Nick);
CREATE INDEX ix_QQNick_Group615 On GroupData7.dbo.Group615 (Nick);
CREATE INDEX ix_QQNick_Group683 On GroupData7.dbo.Group683 (Nick);
CREATE INDEX ix_QQNick_Group616 On GroupData7.dbo.Group616 (Nick);
CREATE INDEX ix_QQNick_Group684 On GroupData7.dbo.Group684 (Nick);
CREATE INDEX ix_QQNick_Group617 On GroupData7.dbo.Group617 (Nick);
CREATE INDEX ix_QQNick_Group685 On GroupData7.dbo.Group685 (Nick);
CREATE INDEX ix_QQNick_Group618 On GroupData7.dbo.Group618 (Nick);
CREATE INDEX ix_QQNick_Group686 On GroupData7.dbo.Group686 (Nick);
CREATE INDEX ix_QQNick_Group619 On GroupData7.dbo.Group619 (Nick);
CREATE INDEX ix_QQNick_Group687 On GroupData7.dbo.Group687 (Nick);
CREATE INDEX ix_QQNick_Group620 On GroupData7.dbo.Group620 (Nick);
CREATE INDEX ix_QQNick_Group688 On GroupData7.dbo.Group688 (Nick);
CREATE INDEX ix_QQNick_Group621 On GroupData7.dbo.Group621 (Nick);
CREATE INDEX ix_QQNick_Group689 On GroupData7.dbo.Group689 (Nick);
CREATE INDEX ix_QQNick_Group622 On GroupData7.dbo.Group622 (Nick);
CREATE INDEX ix_QQNick_Group690 On GroupData7.dbo.Group690 (Nick);
CREATE INDEX ix_QQNick_Group623 On GroupData7.dbo.Group623 (Nick);
CREATE INDEX ix_QQNick_Group691 On GroupData7.dbo.Group691 (Nick);
CREATE INDEX ix_QQNick_Group624 On GroupData7.dbo.Group624 (Nick);
CREATE INDEX ix_QQNick_Group692 On GroupData7.dbo.Group692 (Nick);
CREATE INDEX ix_QQNick_Group625 On GroupData7.dbo.Group625 (Nick);
CREATE INDEX ix_QQNick_Group693 On GroupData7.dbo.Group693 (Nick);
CREATE INDEX ix_QQNick_Group626 On GroupData7.dbo.Group626 (Nick);
CREATE INDEX ix_QQNick_Group694 On GroupData7.dbo.Group694 (Nick);
CREATE INDEX ix_QQNick_Group627 On GroupData7.dbo.Group627 (Nick);
CREATE INDEX ix_QQNick_Group695 On GroupData7.dbo.Group695 (Nick);
CREATE INDEX ix_QQNick_Group628 On GroupData7.dbo.Group628 (Nick);
CREATE INDEX ix_QQNick_Group696 On GroupData7.dbo.Group696 (Nick);
CREATE INDEX ix_QQNick_Group629 On GroupData7.dbo.Group629 (Nick);
CREATE INDEX ix_QQNick_Group697 On GroupData7.dbo.Group697 (Nick);
CREATE INDEX ix_QQNick_Group630 On GroupData7.dbo.Group630 (Nick);
CREATE INDEX ix_QQNick_Group698 On GroupData7.dbo.Group698 (Nick);
CREATE INDEX ix_QQNick_Group631 On GroupData7.dbo.Group631 (Nick);
CREATE INDEX ix_QQNick_Group699 On GroupData7.dbo.Group699 (Nick);
CREATE INDEX ix_QQNick_Group632 On GroupData7.dbo.Group632 (Nick);
CREATE INDEX ix_QQNick_Group700 On GroupData7.dbo.Group700 (Nick);
CREATE INDEX ix_QQNick_Group633 On GroupData7.dbo.Group633 (Nick);
CREATE INDEX ix_QQNick_Group634 On GroupData7.dbo.Group634 (Nick);
CREATE INDEX ix_QQNick_Group635 On GroupData7.dbo.Group635 (Nick);
CREATE INDEX ix_QQNick_Group636 On GroupData7.dbo.Group636 (Nick);
CREATE INDEX ix_QQNick_Group637 On GroupData7.dbo.Group637 (Nick);
CREATE INDEX ix_QQNick_Group638 On GroupData7.dbo.Group638 (Nick);
CREATE INDEX ix_QQNick_Group639 On GroupData7.dbo.Group639 (Nick);
CREATE INDEX ix_QQNick_Group640 On GroupData7.dbo.Group640 (Nick);
CREATE INDEX ix_QQNick_Group641 On GroupData7.dbo.Group641 (Nick);
CREATE INDEX ix_QQNick_Group642 On GroupData7.dbo.Group642 (Nick);
CREATE INDEX ix_QQNick_Group643 On GroupData7.dbo.Group643 (Nick);
CREATE INDEX ix_QQNick_Group644 On GroupData7.dbo.Group644 (Nick);
CREATE INDEX ix_QQNick_Group645 On GroupData7.dbo.Group645 (Nick);
CREATE INDEX ix_QQNick_Group646 On GroupData7.dbo.Group646 (Nick);
CREATE INDEX ix_QQNick_Group647 On GroupData7.dbo.Group647 (Nick);
CREATE INDEX ix_QQNick_Group648 On GroupData7.dbo.Group648 (Nick);
CREATE INDEX ix_QQNick_Group649 On GroupData7.dbo.Group649 (Nick);
CREATE INDEX ix_QQNick_Group650 On GroupData7.dbo.Group650 (Nick);
CREATE INDEX ix_QQNick_Group651 On GroupData7.dbo.Group651 (Nick);
CREATE INDEX ix_QQNick_Group652 On GroupData7.dbo.Group652 (Nick);
CREATE INDEX ix_QQNick_Group653 On GroupData7.dbo.Group653 (Nick);
CREATE INDEX ix_QQNick_Group654 On GroupData7.dbo.Group654 (Nick);
CREATE INDEX ix_QQNick_Group655 On GroupData7.dbo.Group655 (Nick);
CREATE INDEX ix_QQNick_Group656 On GroupData7.dbo.Group656 (Nick);
CREATE INDEX ix_QQNick_Group657 On GroupData7.dbo.Group657 (Nick);
CREATE INDEX ix_QQNick_Group658 On GroupData7.dbo.Group658 (Nick);
CREATE INDEX ix_QQNick_Group659 On GroupData7.dbo.Group659 (Nick);
CREATE INDEX ix_QQNick_Group660 On GroupData7.dbo.Group660 (Nick);
CREATE INDEX ix_QQNick_Group661 On GroupData7.dbo.Group661 (Nick);
CREATE INDEX ix_QQNick_Group662 On GroupData7.dbo.Group662 (Nick);
CREATE INDEX ix_QQNick_Group663 On GroupData7.dbo.Group663 (Nick);
CREATE INDEX ix_QQNick_Group664 On GroupData7.dbo.Group664 (Nick);
CREATE INDEX ix_QQNick_Group665 On GroupData7.dbo.Group665 (Nick);
CREATE INDEX ix_QQNick_Group666 On GroupData7.dbo.Group666 (Nick);
CREATE INDEX ix_QQNick_Group667 On GroupData7.dbo.Group667 (Nick);
CREATE INDEX ix_QQNick_Group668 On GroupData7.dbo.Group668 (Nick);
CREATE INDEX ix_QQNick_Group601 On GroupData7.dbo.Group601 (Nick);
CREATE INDEX ix_QQNick_Group669 On GroupData7.dbo.Group669 (Nick);
CREATE INDEX ix_QQNick_Group602 On GroupData7.dbo.Group602 (Nick);
CREATE INDEX ix_QQNick_Group670 On GroupData7.dbo.Group670 (Nick);
CREATE INDEX ix_QQNick_Group603 On GroupData7.dbo.Group603 (Nick);
CREATE INDEX ix_QQNick_Group671 On GroupData7.dbo.Group671 (Nick);
CREATE INDEX ix_QQNick_Group604 On GroupData7.dbo.Group604 (Nick);
CREATE INDEX ix_QQNick_Group672 On GroupData7.dbo.Group672 (Nick);
CREATE INDEX ix_QQNick_Group605 On GroupData7.dbo.Group605 (Nick);
CREATE INDEX ix_QQNick_Group673 On GroupData7.dbo.Group673 (Nick);
CREATE INDEX ix_QQNick_Group606 On GroupData7.dbo.Group606 (Nick);
CREATE INDEX ix_QQNick_Group774 On GroupData8.dbo.Group774 (Nick);
CREATE INDEX ix_QQNick_Group707 On GroupData8.dbo.Group707 (Nick);
CREATE INDEX ix_QQNick_Group775 On GroupData8.dbo.Group775 (Nick);
CREATE INDEX ix_QQNick_Group708 On GroupData8.dbo.Group708 (Nick);
CREATE INDEX ix_QQNick_Group776 On GroupData8.dbo.Group776 (Nick);
CREATE INDEX ix_QQNick_Group709 On GroupData8.dbo.Group709 (Nick);
CREATE INDEX ix_QQNick_Group777 On GroupData8.dbo.Group777 (Nick);
CREATE INDEX ix_QQNick_Group710 On GroupData8.dbo.Group710 (Nick);
CREATE INDEX ix_QQNick_Group778 On GroupData8.dbo.Group778 (Nick);
CREATE INDEX ix_QQNick_Group711 On GroupData8.dbo.Group711 (Nick);
CREATE INDEX ix_QQNick_Group779 On GroupData8.dbo.Group779 (Nick);
CREATE INDEX ix_QQNick_Group712 On GroupData8.dbo.Group712 (Nick);
CREATE INDEX ix_QQNick_Group780 On GroupData8.dbo.Group780 (Nick);
CREATE INDEX ix_QQNick_Group713 On GroupData8.dbo.Group713 (Nick);
CREATE INDEX ix_QQNick_Group781 On GroupData8.dbo.Group781 (Nick);
CREATE INDEX ix_QQNick_Group714 On GroupData8.dbo.Group714 (Nick);
CREATE INDEX ix_QQNick_Group782 On GroupData8.dbo.Group782 (Nick);
CREATE INDEX ix_QQNick_Group715 On GroupData8.dbo.Group715 (Nick);
CREATE INDEX ix_QQNick_Group783 On GroupData8.dbo.Group783 (Nick);
CREATE INDEX ix_QQNick_Group716 On GroupData8.dbo.Group716 (Nick);
CREATE INDEX ix_QQNick_Group784 On GroupData8.dbo.Group784 (Nick);
CREATE INDEX ix_QQNick_Group717 On GroupData8.dbo.Group717 (Nick);
CREATE INDEX ix_QQNick_Group785 On GroupData8.dbo.Group785 (Nick);
CREATE INDEX ix_QQNick_Group718 On GroupData8.dbo.Group718 (Nick);
CREATE INDEX ix_QQNick_Group786 On GroupData8.dbo.Group786 (Nick);
CREATE INDEX ix_QQNick_Group719 On GroupData8.dbo.Group719 (Nick);
CREATE INDEX ix_QQNick_Group787 On GroupData8.dbo.Group787 (Nick);
CREATE INDEX ix_QQNick_Group720 On GroupData8.dbo.Group720 (Nick);
CREATE INDEX ix_QQNick_Group788 On GroupData8.dbo.Group788 (Nick);
CREATE INDEX ix_QQNick_Group721 On GroupData8.dbo.Group721 (Nick);
CREATE INDEX ix_QQNick_Group789 On GroupData8.dbo.Group789 (Nick);
CREATE INDEX ix_QQNick_Group722 On GroupData8.dbo.Group722 (Nick);
CREATE INDEX ix_QQNick_Group790 On GroupData8.dbo.Group790 (Nick);
CREATE INDEX ix_QQNick_Group723 On GroupData8.dbo.Group723 (Nick);
CREATE INDEX ix_QQNick_Group791 On GroupData8.dbo.Group791 (Nick);
CREATE INDEX ix_QQNick_Group724 On GroupData8.dbo.Group724 (Nick);
CREATE INDEX ix_QQNick_Group792 On GroupData8.dbo.Group792 (Nick);
CREATE INDEX ix_QQNick_Group725 On GroupData8.dbo.Group725 (Nick);
CREATE INDEX ix_QQNick_Group793 On GroupData8.dbo.Group793 (Nick);
CREATE INDEX ix_QQNick_Group726 On GroupData8.dbo.Group726 (Nick);
CREATE INDEX ix_QQNick_Group794 On GroupData8.dbo.Group794 (Nick);
CREATE INDEX ix_QQNick_Group727 On GroupData8.dbo.Group727 (Nick);
CREATE INDEX ix_QQNick_Group795 On GroupData8.dbo.Group795 (Nick);
CREATE INDEX ix_QQNick_Group728 On GroupData8.dbo.Group728 (Nick);
CREATE INDEX ix_QQNick_Group796 On GroupData8.dbo.Group796 (Nick);
CREATE INDEX ix_QQNick_Group729 On GroupData8.dbo.Group729 (Nick);
CREATE INDEX ix_QQNick_Group797 On GroupData8.dbo.Group797 (Nick);
CREATE INDEX ix_QQNick_Group730 On GroupData8.dbo.Group730 (Nick);
CREATE INDEX ix_QQNick_Group798 On GroupData8.dbo.Group798 (Nick);
CREATE INDEX ix_QQNick_Group731 On GroupData8.dbo.Group731 (Nick);
CREATE INDEX ix_QQNick_Group799 On GroupData8.dbo.Group799 (Nick);
CREATE INDEX ix_QQNick_Group732 On GroupData8.dbo.Group732 (Nick);
CREATE INDEX ix_QQNick_Group800 On GroupData8.dbo.Group800 (Nick);
CREATE INDEX ix_QQNick_Group733 On GroupData8.dbo.Group733 (Nick);
CREATE INDEX ix_QQNick_Group734 On GroupData8.dbo.Group734 (Nick);
CREATE INDEX ix_QQNick_Group735 On GroupData8.dbo.Group735 (Nick);
CREATE INDEX ix_QQNick_Group736 On GroupData8.dbo.Group736 (Nick);
CREATE INDEX ix_QQNick_Group737 On GroupData8.dbo.Group737 (Nick);
CREATE INDEX ix_QQNick_Group738 On GroupData8.dbo.Group738 (Nick);
CREATE INDEX ix_QQNick_Group739 On GroupData8.dbo.Group739 (Nick);
CREATE INDEX ix_QQNick_Group740 On GroupData8.dbo.Group740 (Nick);
CREATE INDEX ix_QQNick_Group741 On GroupData8.dbo.Group741 (Nick);
CREATE INDEX ix_QQNick_Group742 On GroupData8.dbo.Group742 (Nick);
CREATE INDEX ix_QQNick_Group743 On GroupData8.dbo.Group743 (Nick);
CREATE INDEX ix_QQNick_Group744 On GroupData8.dbo.Group744 (Nick);
CREATE INDEX ix_QQNick_Group745 On GroupData8.dbo.Group745 (Nick);
CREATE INDEX ix_QQNick_Group746 On GroupData8.dbo.Group746 (Nick);
CREATE INDEX ix_QQNick_Group747 On GroupData8.dbo.Group747 (Nick);
CREATE INDEX ix_QQNick_Group748 On GroupData8.dbo.Group748 (Nick);
CREATE INDEX ix_QQNick_Group749 On GroupData8.dbo.Group749 (Nick);
CREATE INDEX ix_QQNick_Group750 On GroupData8.dbo.Group750 (Nick);
CREATE INDEX ix_QQNick_Group751 On GroupData8.dbo.Group751 (Nick);
CREATE INDEX ix_QQNick_Group752 On GroupData8.dbo.Group752 (Nick);
CREATE INDEX ix_QQNick_Group753 On GroupData8.dbo.Group753 (Nick);
CREATE INDEX ix_QQNick_Group754 On GroupData8.dbo.Group754 (Nick);
CREATE INDEX ix_QQNick_Group755 On GroupData8.dbo.Group755 (Nick);
CREATE INDEX ix_QQNick_Group756 On GroupData8.dbo.Group756 (Nick);
CREATE INDEX ix_QQNick_Group757 On GroupData8.dbo.Group757 (Nick);
CREATE INDEX ix_QQNick_Group758 On GroupData8.dbo.Group758 (Nick);
CREATE INDEX ix_QQNick_Group759 On GroupData8.dbo.Group759 (Nick);
CREATE INDEX ix_QQNick_Group760 On GroupData8.dbo.Group760 (Nick);
CREATE INDEX ix_QQNick_Group761 On GroupData8.dbo.Group761 (Nick);
CREATE INDEX ix_QQNick_Group762 On GroupData8.dbo.Group762 (Nick);
CREATE INDEX ix_QQNick_Group763 On GroupData8.dbo.Group763 (Nick);
CREATE INDEX ix_QQNick_Group764 On GroupData8.dbo.Group764 (Nick);
CREATE INDEX ix_QQNick_Group765 On GroupData8.dbo.Group765 (Nick);
CREATE INDEX ix_QQNick_Group766 On GroupData8.dbo.Group766 (Nick);
CREATE INDEX ix_QQNick_Group767 On GroupData8.dbo.Group767 (Nick);
CREATE INDEX ix_QQNick_Group768 On GroupData8.dbo.Group768 (Nick);
CREATE INDEX ix_QQNick_Group701 On GroupData8.dbo.Group701 (Nick);
CREATE INDEX ix_QQNick_Group769 On GroupData8.dbo.Group769 (Nick);
CREATE INDEX ix_QQNick_Group702 On GroupData8.dbo.Group702 (Nick);
CREATE INDEX ix_QQNick_Group770 On GroupData8.dbo.Group770 (Nick);
CREATE INDEX ix_QQNick_Group703 On GroupData8.dbo.Group703 (Nick);
CREATE INDEX ix_QQNick_Group771 On GroupData8.dbo.Group771 (Nick);
CREATE INDEX ix_QQNick_Group704 On GroupData8.dbo.Group704 (Nick);
CREATE INDEX ix_QQNick_Group772 On GroupData8.dbo.Group772 (Nick);
CREATE INDEX ix_QQNick_Group705 On GroupData8.dbo.Group705 (Nick);
CREATE INDEX ix_QQNick_Group773 On GroupData8.dbo.Group773 (Nick);
CREATE INDEX ix_QQNick_Group706 On GroupData8.dbo.Group706 (Nick);
CREATE INDEX ix_QQNick_Group874 On GroupData9.dbo.Group874 (Nick);
CREATE INDEX ix_QQNick_Group807 On GroupData9.dbo.Group807 (Nick);
CREATE INDEX ix_QQNick_Group875 On GroupData9.dbo.Group875 (Nick);
CREATE INDEX ix_QQNick_Group808 On GroupData9.dbo.Group808 (Nick);
CREATE INDEX ix_QQNick_Group876 On GroupData9.dbo.Group876 (Nick);
CREATE INDEX ix_QQNick_Group809 On GroupData9.dbo.Group809 (Nick);
CREATE INDEX ix_QQNick_Group877 On GroupData9.dbo.Group877 (Nick);
CREATE INDEX ix_QQNick_Group810 On GroupData9.dbo.Group810 (Nick);
CREATE INDEX ix_QQNick_Group878 On GroupData9.dbo.Group878 (Nick);
CREATE INDEX ix_QQNick_Group811 On GroupData9.dbo.Group811 (Nick);
CREATE INDEX ix_QQNick_Group879 On GroupData9.dbo.Group879 (Nick);
CREATE INDEX ix_QQNick_Group812 On GroupData9.dbo.Group812 (Nick);
CREATE INDEX ix_QQNick_Group880 On GroupData9.dbo.Group880 (Nick);
CREATE INDEX ix_QQNick_Group813 On GroupData9.dbo.Group813 (Nick);
CREATE INDEX ix_QQNick_Group881 On GroupData9.dbo.Group881 (Nick);
CREATE INDEX ix_QQNick_Group814 On GroupData9.dbo.Group814 (Nick);
CREATE INDEX ix_QQNick_Group882 On GroupData9.dbo.Group882 (Nick);
CREATE INDEX ix_QQNick_Group815 On GroupData9.dbo.Group815 (Nick);
CREATE INDEX ix_QQNick_Group883 On GroupData9.dbo.Group883 (Nick);
CREATE INDEX ix_QQNick_Group816 On GroupData9.dbo.Group816 (Nick);
CREATE INDEX ix_QQNick_Group884 On GroupData9.dbo.Group884 (Nick);
CREATE INDEX ix_QQNick_Group817 On GroupData9.dbo.Group817 (Nick);
CREATE INDEX ix_QQNick_Group885 On GroupData9.dbo.Group885 (Nick);
CREATE INDEX ix_QQNick_Group818 On GroupData9.dbo.Group818 (Nick);
CREATE INDEX ix_QQNick_Group886 On GroupData9.dbo.Group886 (Nick);
CREATE INDEX ix_QQNick_Group819 On GroupData9.dbo.Group819 (Nick);
CREATE INDEX ix_QQNick_Group887 On GroupData9.dbo.Group887 (Nick);
CREATE INDEX ix_QQNick_Group820 On GroupData9.dbo.Group820 (Nick);
CREATE INDEX ix_QQNick_Group888 On GroupData9.dbo.Group888 (Nick);
CREATE INDEX ix_QQNick_Group821 On GroupData9.dbo.Group821 (Nick);
CREATE INDEX ix_QQNick_Group889 On GroupData9.dbo.Group889 (Nick);
CREATE INDEX ix_QQNick_Group822 On GroupData9.dbo.Group822 (Nick);
CREATE INDEX ix_QQNick_Group890 On GroupData9.dbo.Group890 (Nick);
CREATE INDEX ix_QQNick_Group823 On GroupData9.dbo.Group823 (Nick);
CREATE INDEX ix_QQNick_Group891 On GroupData9.dbo.Group891 (Nick);
CREATE INDEX ix_QQNick_Group824 On GroupData9.dbo.Group824 (Nick);
CREATE INDEX ix_QQNick_Group892 On GroupData9.dbo.Group892 (Nick);
CREATE INDEX ix_QQNick_Group825 On GroupData9.dbo.Group825 (Nick);
CREATE INDEX ix_QQNick_Group893 On GroupData9.dbo.Group893 (Nick);
CREATE INDEX ix_QQNick_Group826 On GroupData9.dbo.Group826 (Nick);
CREATE INDEX ix_QQNick_Group894 On GroupData9.dbo.Group894 (Nick);
CREATE INDEX ix_QQNick_Group827 On GroupData9.dbo.Group827 (Nick);
CREATE INDEX ix_QQNick_Group895 On GroupData9.dbo.Group895 (Nick);
CREATE INDEX ix_QQNick_Group828 On GroupData9.dbo.Group828 (Nick);
CREATE INDEX ix_QQNick_Group896 On GroupData9.dbo.Group896 (Nick);
CREATE INDEX ix_QQNick_Group829 On GroupData9.dbo.Group829 (Nick);
CREATE INDEX ix_QQNick_Group897 On GroupData9.dbo.Group897 (Nick);
CREATE INDEX ix_QQNick_Group830 On GroupData9.dbo.Group830 (Nick);
CREATE INDEX ix_QQNick_Group898 On GroupData9.dbo.Group898 (Nick);
CREATE INDEX ix_QQNick_Group831 On GroupData9.dbo.Group831 (Nick);
CREATE INDEX ix_QQNick_Group899 On GroupData9.dbo.Group899 (Nick);
CREATE INDEX ix_QQNick_Group832 On GroupData9.dbo.Group832 (Nick);
CREATE INDEX ix_QQNick_Group900 On GroupData9.dbo.Group900 (Nick);
CREATE INDEX ix_QQNick_Group833 On GroupData9.dbo.Group833 (Nick);
CREATE INDEX ix_QQNick_Group834 On GroupData9.dbo.Group834 (Nick);
CREATE INDEX ix_QQNick_Group835 On GroupData9.dbo.Group835 (Nick);
CREATE INDEX ix_QQNick_Group836 On GroupData9.dbo.Group836 (Nick);
CREATE INDEX ix_QQNick_Group837 On GroupData9.dbo.Group837 (Nick);
CREATE INDEX ix_QQNick_Group838 On GroupData9.dbo.Group838 (Nick);
CREATE INDEX ix_QQNick_Group839 On GroupData9.dbo.Group839 (Nick);
CREATE INDEX ix_QQNick_Group840 On GroupData9.dbo.Group840 (Nick);
CREATE INDEX ix_QQNick_Group841 On GroupData9.dbo.Group841 (Nick);
CREATE INDEX ix_QQNick_Group842 On GroupData9.dbo.Group842 (Nick);
CREATE INDEX ix_QQNick_Group843 On GroupData9.dbo.Group843 (Nick);
CREATE INDEX ix_QQNick_Group844 On GroupData9.dbo.Group844 (Nick);
CREATE INDEX ix_QQNick_Group845 On GroupData9.dbo.Group845 (Nick);
CREATE INDEX ix_QQNick_Group846 On GroupData9.dbo.Group846 (Nick);
CREATE INDEX ix_QQNick_Group847 On GroupData9.dbo.Group847 (Nick);
CREATE INDEX ix_QQNick_Group848 On GroupData9.dbo.Group848 (Nick);
CREATE INDEX ix_QQNick_Group849 On GroupData9.dbo.Group849 (Nick);
CREATE INDEX ix_QQNick_Group850 On GroupData9.dbo.Group850 (Nick);
CREATE INDEX ix_QQNick_Group851 On GroupData9.dbo.Group851 (Nick);
CREATE INDEX ix_QQNick_Group852 On GroupData9.dbo.Group852 (Nick);
CREATE INDEX ix_QQNick_Group853 On GroupData9.dbo.Group853 (Nick);
CREATE INDEX ix_QQNick_Group854 On GroupData9.dbo.Group854 (Nick);
CREATE INDEX ix_QQNick_Group855 On GroupData9.dbo.Group855 (Nick);
CREATE INDEX ix_QQNick_Group856 On GroupData9.dbo.Group856 (Nick);
CREATE INDEX ix_QQNick_Group857 On GroupData9.dbo.Group857 (Nick);
CREATE INDEX ix_QQNick_Group858 On GroupData9.dbo.Group858 (Nick);
CREATE INDEX ix_QQNick_Group859 On GroupData9.dbo.Group859 (Nick);
CREATE INDEX ix_QQNick_Group860 On GroupData9.dbo.Group860 (Nick);
CREATE INDEX ix_QQNick_Group861 On GroupData9.dbo.Group861 (Nick);
CREATE INDEX ix_QQNick_Group862 On GroupData9.dbo.Group862 (Nick);
CREATE INDEX ix_QQNick_Group863 On GroupData9.dbo.Group863 (Nick);
CREATE INDEX ix_QQNick_Group864 On GroupData9.dbo.Group864 (Nick);
CREATE INDEX ix_QQNick_Group865 On GroupData9.dbo.Group865 (Nick);
CREATE INDEX ix_QQNick_Group866 On GroupData9.dbo.Group866 (Nick);
CREATE INDEX ix_QQNick_Group867 On GroupData9.dbo.Group867 (Nick);
CREATE INDEX ix_QQNick_Group868 On GroupData9.dbo.Group868 (Nick);
CREATE INDEX ix_QQNick_Group801 On GroupData9.dbo.Group801 (Nick);
CREATE INDEX ix_QQNick_Group869 On GroupData9.dbo.Group869 (Nick);
CREATE INDEX ix_QQNick_Group802 On GroupData9.dbo.Group802 (Nick);
CREATE INDEX ix_QQNick_Group870 On GroupData9.dbo.Group870 (Nick);
CREATE INDEX ix_QQNick_Group803 On GroupData9.dbo.Group803 (Nick);
CREATE INDEX ix_QQNick_Group871 On GroupData9.dbo.Group871 (Nick);
CREATE INDEX ix_QQNick_Group804 On GroupData9.dbo.Group804 (Nick);
CREATE INDEX ix_QQNick_Group872 On GroupData9.dbo.Group872 (Nick);
CREATE INDEX ix_QQNick_Group805 On GroupData9.dbo.Group805 (Nick);
CREATE INDEX ix_QQNick_Group873 On GroupData9.dbo.Group873 (Nick);
CREATE INDEX ix_QQNick_Group806 On GroupData9.dbo.Group806 (Nick);
CREATE INDEX ix_QQNick_Group974 On GroupData10.dbo.Group974 (Nick);
CREATE INDEX ix_QQNick_Group907 On GroupData10.dbo.Group907 (Nick);
CREATE INDEX ix_QQNick_Group975 On GroupData10.dbo.Group975 (Nick);
CREATE INDEX ix_QQNick_Group908 On GroupData10.dbo.Group908 (Nick);
CREATE INDEX ix_QQNick_Group976 On GroupData10.dbo.Group976 (Nick);
CREATE INDEX ix_QQNick_Group909 On GroupData10.dbo.Group909 (Nick);
CREATE INDEX ix_QQNick_Group977 On GroupData10.dbo.Group977 (Nick);
CREATE INDEX ix_QQNick_Group910 On GroupData10.dbo.Group910 (Nick);
CREATE INDEX ix_QQNick_Group978 On GroupData10.dbo.Group978 (Nick);
CREATE INDEX ix_QQNick_Group911 On GroupData10.dbo.Group911 (Nick);
CREATE INDEX ix_QQNick_Group979 On GroupData10.dbo.Group979 (Nick);
CREATE INDEX ix_QQNick_Group912 On GroupData10.dbo.Group912 (Nick);
CREATE INDEX ix_QQNick_Group980 On GroupData10.dbo.Group980 (Nick);
CREATE INDEX ix_QQNick_Group913 On GroupData10.dbo.Group913 (Nick);
CREATE INDEX ix_QQNick_Group981 On GroupData10.dbo.Group981 (Nick);
CREATE INDEX ix_QQNick_Group914 On GroupData10.dbo.Group914 (Nick);
CREATE INDEX ix_QQNick_Group982 On GroupData10.dbo.Group982 (Nick);
CREATE INDEX ix_QQNick_Group915 On GroupData10.dbo.Group915 (Nick);
CREATE INDEX ix_QQNick_Group983 On GroupData10.dbo.Group983 (Nick);
CREATE INDEX ix_QQNick_Group916 On GroupData10.dbo.Group916 (Nick);
CREATE INDEX ix_QQNick_Group984 On GroupData10.dbo.Group984 (Nick);
CREATE INDEX ix_QQNick_Group917 On GroupData10.dbo.Group917 (Nick);
CREATE INDEX ix_QQNick_Group985 On GroupData10.dbo.Group985 (Nick);
CREATE INDEX ix_QQNick_Group918 On GroupData10.dbo.Group918 (Nick);
CREATE INDEX ix_QQNick_Group986 On GroupData10.dbo.Group986 (Nick);
CREATE INDEX ix_QQNick_Group919 On GroupData10.dbo.Group919 (Nick);
CREATE INDEX ix_QQNick_Group987 On GroupData10.dbo.Group987 (Nick);
CREATE INDEX ix_QQNick_Group920 On GroupData10.dbo.Group920 (Nick);
CREATE INDEX ix_QQNick_Group988 On GroupData10.dbo.Group988 (Nick);
CREATE INDEX ix_QQNick_Group921 On GroupData10.dbo.Group921 (Nick);
CREATE INDEX ix_QQNick_Group989 On GroupData10.dbo.Group989 (Nick);
CREATE INDEX ix_QQNick_Group922 On GroupData10.dbo.Group922 (Nick);
CREATE INDEX ix_QQNick_Group990 On GroupData10.dbo.Group990 (Nick);
CREATE INDEX ix_QQNick_Group923 On GroupData10.dbo.Group923 (Nick);
CREATE INDEX ix_QQNick_Group991 On GroupData10.dbo.Group991 (Nick);
CREATE INDEX ix_QQNick_Group924 On GroupData10.dbo.Group924 (Nick);
CREATE INDEX ix_QQNick_Group992 On GroupData10.dbo.Group992 (Nick);
CREATE INDEX ix_QQNick_Group925 On GroupData10.dbo.Group925 (Nick);
CREATE INDEX ix_QQNick_Group993 On GroupData10.dbo.Group993 (Nick);
CREATE INDEX ix_QQNick_Group926 On GroupData10.dbo.Group926 (Nick);
CREATE INDEX ix_QQNick_Group994 On GroupData10.dbo.Group994 (Nick);
CREATE INDEX ix_QQNick_Group927 On GroupData10.dbo.Group927 (Nick);
CREATE INDEX ix_QQNick_Group995 On GroupData10.dbo.Group995 (Nick);
CREATE INDEX ix_QQNick_Group928 On GroupData10.dbo.Group928 (Nick);
CREATE INDEX ix_QQNick_Group996 On GroupData10.dbo.Group996 (Nick);
CREATE INDEX ix_QQNick_Group929 On GroupData10.dbo.Group929 (Nick);
CREATE INDEX ix_QQNick_Group997 On GroupData10.dbo.Group997 (Nick);
CREATE INDEX ix_QQNick_Group930 On GroupData10.dbo.Group930 (Nick);
CREATE INDEX ix_QQNick_Group998 On GroupData10.dbo.Group998 (Nick);
CREATE INDEX ix_QQNick_Group931 On GroupData10.dbo.Group931 (Nick);
CREATE INDEX ix_QQNick_Group999 On GroupData10.dbo.Group999 (Nick);
CREATE INDEX ix_QQNick_Group932 On GroupData10.dbo.Group932 (Nick);
CREATE INDEX ix_QQNick_Group1000 On GroupData10.dbo.Group1000 (Nick);
CREATE INDEX ix_QQNick_Group933 On GroupData10.dbo.Group933 (Nick);
CREATE INDEX ix_QQNick_Group934 On GroupData10.dbo.Group934 (Nick);
CREATE INDEX ix_QQNick_Group935 On GroupData10.dbo.Group935 (Nick);
CREATE INDEX ix_QQNick_Group936 On GroupData10.dbo.Group936 (Nick);
CREATE INDEX ix_QQNick_Group937 On GroupData10.dbo.Group937 (Nick);
CREATE INDEX ix_QQNick_Group938 On GroupData10.dbo.Group938 (Nick);
CREATE INDEX ix_QQNick_Group939 On GroupData10.dbo.Group939 (Nick);
CREATE INDEX ix_QQNick_Group940 On GroupData10.dbo.Group940 (Nick);
CREATE INDEX ix_QQNick_Group941 On GroupData10.dbo.Group941 (Nick);
CREATE INDEX ix_QQNick_Group942 On GroupData10.dbo.Group942 (Nick);
CREATE INDEX ix_QQNick_Group943 On GroupData10.dbo.Group943 (Nick);
CREATE INDEX ix_QQNick_Group944 On GroupData10.dbo.Group944 (Nick);
CREATE INDEX ix_QQNick_Group945 On GroupData10.dbo.Group945 (Nick);
CREATE INDEX ix_QQNick_Group946 On GroupData10.dbo.Group946 (Nick);
CREATE INDEX ix_QQNick_Group947 On GroupData10.dbo.Group947 (Nick);
CREATE INDEX ix_QQNick_Group948 On GroupData10.dbo.Group948 (Nick);
CREATE INDEX ix_QQNick_Group949 On GroupData10.dbo.Group949 (Nick);
CREATE INDEX ix_QQNick_Group950 On GroupData10.dbo.Group950 (Nick);
CREATE INDEX ix_QQNick_Group951 On GroupData10.dbo.Group951 (Nick);
CREATE INDEX ix_QQNick_Group952 On GroupData10.dbo.Group952 (Nick);
CREATE INDEX ix_QQNick_Group953 On GroupData10.dbo.Group953 (Nick);
CREATE INDEX ix_QQNick_Group954 On GroupData10.dbo.Group954 (Nick);
CREATE INDEX ix_QQNick_Group955 On GroupData10.dbo.Group955 (Nick);
CREATE INDEX ix_QQNick_Group956 On GroupData10.dbo.Group956 (Nick);
CREATE INDEX ix_QQNick_Group957 On GroupData10.dbo.Group957 (Nick);
CREATE INDEX ix_QQNick_Group958 On GroupData10.dbo.Group958 (Nick);
CREATE INDEX ix_QQNick_Group959 On GroupData10.dbo.Group959 (Nick);
CREATE INDEX ix_QQNick_Group960 On GroupData10.dbo.Group960 (Nick);
CREATE INDEX ix_QQNick_Group961 On GroupData10.dbo.Group961 (Nick);
CREATE INDEX ix_QQNick_Group962 On GroupData10.dbo.Group962 (Nick);
CREATE INDEX ix_QQNick_Group963 On GroupData10.dbo.Group963 (Nick);
CREATE INDEX ix_QQNick_Group964 On GroupData10.dbo.Group964 (Nick);
CREATE INDEX ix_QQNick_Group965 On GroupData10.dbo.Group965 (Nick);
CREATE INDEX ix_QQNick_Group966 On GroupData10.dbo.Group966 (Nick);
CREATE INDEX ix_QQNick_Group967 On GroupData10.dbo.Group967 (Nick);
CREATE INDEX ix_QQNick_Group968 On GroupData10.dbo.Group968 (Nick);
CREATE INDEX ix_QQNick_Group901 On GroupData10.dbo.Group901 (Nick);
CREATE INDEX ix_QQNick_Group969 On GroupData10.dbo.Group969 (Nick);
CREATE INDEX ix_QQNick_Group902 On GroupData10.dbo.Group902 (Nick);
CREATE INDEX ix_QQNick_Group970 On GroupData10.dbo.Group970 (Nick);
CREATE INDEX ix_QQNick_Group903 On GroupData10.dbo.Group903 (Nick);
CREATE INDEX ix_QQNick_Group971 On GroupData10.dbo.Group971 (Nick);
CREATE INDEX ix_QQNick_Group904 On GroupData10.dbo.Group904 (Nick);
CREATE INDEX ix_QQNick_Group972 On GroupData10.dbo.Group972 (Nick);
CREATE INDEX ix_QQNick_Group905 On GroupData10.dbo.Group905 (Nick);
CREATE INDEX ix_QQNick_Group973 On GroupData10.dbo.Group973 (Nick);
CREATE INDEX ix_QQNick_Group906 On GroupData10.dbo.Group906 (Nick);
CREATE INDEX ix_QQNick_Group1074 On GroupData11.dbo.Group1074 (Nick);
CREATE INDEX ix_QQNick_Group1007 On GroupData11.dbo.Group1007 (Nick);
CREATE INDEX ix_QQNick_Group1075 On GroupData11.dbo.Group1075 (Nick);
CREATE INDEX ix_QQNick_Group1008 On GroupData11.dbo.Group1008 (Nick);
CREATE INDEX ix_QQNick_Group1076 On GroupData11.dbo.Group1076 (Nick);
CREATE INDEX ix_QQNick_Group1009 On GroupData11.dbo.Group1009 (Nick);
CREATE INDEX ix_QQNick_Group1077 On GroupData11.dbo.Group1077 (Nick);
CREATE INDEX ix_QQNick_Group1010 On GroupData11.dbo.Group1010 (Nick);
CREATE INDEX ix_QQNick_Group1078 On GroupData11.dbo.Group1078 (Nick);
CREATE INDEX ix_QQNick_Group1011 On GroupData11.dbo.Group1011 (Nick);
CREATE INDEX ix_QQNick_Group1079 On GroupData11.dbo.Group1079 (Nick);
CREATE INDEX ix_QQNick_Group1012 On GroupData11.dbo.Group1012 (Nick);
CREATE INDEX ix_QQNick_Group1080 On GroupData11.dbo.Group1080 (Nick);
CREATE INDEX ix_QQNick_Group1013 On GroupData11.dbo.Group1013 (Nick);
CREATE INDEX ix_QQNick_Group1081 On GroupData11.dbo.Group1081 (Nick);
CREATE INDEX ix_QQNick_Group1014 On GroupData11.dbo.Group1014 (Nick);
CREATE INDEX ix_QQNick_Group1082 On GroupData11.dbo.Group1082 (Nick);
CREATE INDEX ix_QQNick_Group1015 On GroupData11.dbo.Group1015 (Nick);
CREATE INDEX ix_QQNick_Group1083 On GroupData11.dbo.Group1083 (Nick);
CREATE INDEX ix_QQNick_Group1016 On GroupData11.dbo.Group1016 (Nick);
CREATE INDEX ix_QQNick_Group1084 On GroupData11.dbo.Group1084 (Nick);
CREATE INDEX ix_QQNick_Group1017 On GroupData11.dbo.Group1017 (Nick);
CREATE INDEX ix_QQNick_Group1085 On GroupData11.dbo.Group1085 (Nick);
CREATE INDEX ix_QQNick_Group1018 On GroupData11.dbo.Group1018 (Nick);
CREATE INDEX ix_QQNick_Group1086 On GroupData11.dbo.Group1086 (Nick);
CREATE INDEX ix_QQNick_Group1019 On GroupData11.dbo.Group1019 (Nick);
CREATE INDEX ix_QQNick_Group1087 On GroupData11.dbo.Group1087 (Nick);
CREATE INDEX ix_QQNick_Group1020 On GroupData11.dbo.Group1020 (Nick);
CREATE INDEX ix_QQNick_Group1088 On GroupData11.dbo.Group1088 (Nick);
CREATE INDEX ix_QQNick_Group1021 On GroupData11.dbo.Group1021 (Nick);
CREATE INDEX ix_QQNick_Group1089 On GroupData11.dbo.Group1089 (Nick);
CREATE INDEX ix_QQNick_Group1022 On GroupData11.dbo.Group1022 (Nick);
CREATE INDEX ix_QQNick_Group1090 On GroupData11.dbo.Group1090 (Nick);
CREATE INDEX ix_QQNick_Group1023 On GroupData11.dbo.Group1023 (Nick);
CREATE INDEX ix_QQNick_Group1091 On GroupData11.dbo.Group1091 (Nick);
CREATE INDEX ix_QQNick_Group1024 On GroupData11.dbo.Group1024 (Nick);
CREATE INDEX ix_QQNick_Group1092 On GroupData11.dbo.Group1092 (Nick);
CREATE INDEX ix_QQNick_Group1025 On GroupData11.dbo.Group1025 (Nick);
CREATE INDEX ix_QQNick_Group1093 On GroupData11.dbo.Group1093 (Nick);
CREATE INDEX ix_QQNick_Group1026 On GroupData11.dbo.Group1026 (Nick);
CREATE INDEX ix_QQNick_Group1094 On GroupData11.dbo.Group1094 (Nick);
CREATE INDEX ix_QQNick_Group1027 On GroupData11.dbo.Group1027 (Nick);
CREATE INDEX ix_QQNick_Group1095 On GroupData11.dbo.Group1095 (Nick);
CREATE INDEX ix_QQNick_Group1028 On GroupData11.dbo.Group1028 (Nick);
CREATE INDEX ix_QQNick_Group1096 On GroupData11.dbo.Group1096 (Nick);
CREATE INDEX ix_QQNick_Group1029 On GroupData11.dbo.Group1029 (Nick);
CREATE INDEX ix_QQNick_Group1097 On GroupData11.dbo.Group1097 (Nick);
CREATE INDEX ix_QQNick_Group1030 On GroupData11.dbo.Group1030 (Nick);
CREATE INDEX ix_QQNick_Group1098 On GroupData11.dbo.Group1098 (Nick);
CREATE INDEX ix_QQNick_Group1031 On GroupData11.dbo.Group1031 (Nick);
CREATE INDEX ix_QQNick_Group1099 On GroupData11.dbo.Group1099 (Nick);
CREATE INDEX ix_QQNick_Group1032 On GroupData11.dbo.Group1032 (Nick);
CREATE INDEX ix_QQNick_Group1100 On GroupData11.dbo.Group1100 (Nick);
CREATE INDEX ix_QQNick_Group1033 On GroupData11.dbo.Group1033 (Nick);
CREATE INDEX ix_QQNick_Group1034 On GroupData11.dbo.Group1034 (Nick);
CREATE INDEX ix_QQNick_Group1035 On GroupData11.dbo.Group1035 (Nick);
CREATE INDEX ix_QQNick_Group1036 On GroupData11.dbo.Group1036 (Nick);
CREATE INDEX ix_QQNick_Group1037 On GroupData11.dbo.Group1037 (Nick);
CREATE INDEX ix_QQNick_Group1038 On GroupData11.dbo.Group1038 (Nick);
CREATE INDEX ix_QQNick_Group1039 On GroupData11.dbo.Group1039 (Nick);
CREATE INDEX ix_QQNick_Group1040 On GroupData11.dbo.Group1040 (Nick);
CREATE INDEX ix_QQNick_Group1041 On GroupData11.dbo.Group1041 (Nick);
CREATE INDEX ix_QQNick_Group1042 On GroupData11.dbo.Group1042 (Nick);
CREATE INDEX ix_QQNick_Group1043 On GroupData11.dbo.Group1043 (Nick);
CREATE INDEX ix_QQNick_Group1044 On GroupData11.dbo.Group1044 (Nick);
CREATE INDEX ix_QQNick_Group1045 On GroupData11.dbo.Group1045 (Nick);
CREATE INDEX ix_QQNick_Group1046 On GroupData11.dbo.Group1046 (Nick);
CREATE INDEX ix_QQNick_Group1047 On GroupData11.dbo.Group1047 (Nick);
CREATE INDEX ix_QQNick_Group1048 On GroupData11.dbo.Group1048 (Nick);
CREATE INDEX ix_QQNick_Group1049 On GroupData11.dbo.Group1049 (Nick);
CREATE INDEX ix_QQNick_Group1050 On GroupData11.dbo.Group1050 (Nick);
CREATE INDEX ix_QQNick_Group1051 On GroupData11.dbo.Group1051 (Nick);
CREATE INDEX ix_QQNick_Group1052 On GroupData11.dbo.Group1052 (Nick);
CREATE INDEX ix_QQNick_Group1053 On GroupData11.dbo.Group1053 (Nick);
CREATE INDEX ix_QQNick_Group1054 On GroupData11.dbo.Group1054 (Nick);
CREATE INDEX ix_QQNick_Group1055 On GroupData11.dbo.Group1055 (Nick);
CREATE INDEX ix_QQNick_Group1056 On GroupData11.dbo.Group1056 (Nick);
CREATE INDEX ix_QQNick_Group1057 On GroupData11.dbo.Group1057 (Nick);
CREATE INDEX ix_QQNick_Group1058 On GroupData11.dbo.Group1058 (Nick);
CREATE INDEX ix_QQNick_Group1059 On GroupData11.dbo.Group1059 (Nick);
CREATE INDEX ix_QQNick_Group1060 On GroupData11.dbo.Group1060 (Nick);
CREATE INDEX ix_QQNick_Group1061 On GroupData11.dbo.Group1061 (Nick);
CREATE INDEX ix_QQNick_Group1062 On GroupData11.dbo.Group1062 (Nick);
CREATE INDEX ix_QQNick_Group1063 On GroupData11.dbo.Group1063 (Nick);
CREATE INDEX ix_QQNick_Group1064 On GroupData11.dbo.Group1064 (Nick);
CREATE INDEX ix_QQNick_Group1065 On GroupData11.dbo.Group1065 (Nick);
CREATE INDEX ix_QQNick_Group1066 On GroupData11.dbo.Group1066 (Nick);
CREATE INDEX ix_QQNick_Group1067 On GroupData11.dbo.Group1067 (Nick);
CREATE INDEX ix_QQNick_Group1068 On GroupData11.dbo.Group1068 (Nick);
CREATE INDEX ix_QQNick_Group1001 On GroupData11.dbo.Group1001 (Nick);
CREATE INDEX ix_QQNick_Group1069 On GroupData11.dbo.Group1069 (Nick);
CREATE INDEX ix_QQNick_Group1002 On GroupData11.dbo.Group1002 (Nick);
CREATE INDEX ix_QQNick_Group1070 On GroupData11.dbo.Group1070 (Nick);
CREATE INDEX ix_QQNick_Group1003 On GroupData11.dbo.Group1003 (Nick);
CREATE INDEX ix_QQNick_Group1071 On GroupData11.dbo.Group1071 (Nick);
CREATE INDEX ix_QQNick_Group1004 On GroupData11.dbo.Group1004 (Nick);
CREATE INDEX ix_QQNick_Group1072 On GroupData11.dbo.Group1072 (Nick);
CREATE INDEX ix_QQNick_Group1005 On GroupData11.dbo.Group1005 (Nick);
CREATE INDEX ix_QQNick_Group1073 On GroupData11.dbo.Group1073 (Nick);
CREATE INDEX ix_QQNick_Group1006 On GroupData11.dbo.Group1006 (Nick);

可能是因为机器比较差的缘故,上面这个过程花了我2个多小时

之后查询

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
declare @Nick nvarchar(100)='名字'
declare @sql nvarchar(4000)
declare @dbIdx int = 1

if OBJECT_ID('tempdb.dbo.#NickList') is not null
drop table #NickList
if OBJECT_ID('tempdb.dbo.#NickDetail') is not null
drop table #NickDetail

create table #NickList
(
QQNum int,
Nick nvarchar(20),
Age int,
Gender int,
Auth int,
QunNum int,
Title nvarchar(22),
QunText nvarchar(80)
)
create table #NickDetail
(
QunNum int,
Title nvarchar(22),
QunText nvarchar(80)
)

while @dbIdx <= 11
begin
declare @tblIdx int = 1
declare @tblName nvarchar(50)

while @tblIdx <= 100
begin
set @tblName = 'GroupData' + CONVERT(nvarchar(2), @dbIdx) + '.dbo.Group'
set @tblName += CONVERT(nvarchar(5), (@dbIdx - 1) * 100 + @tblIdx)

set @sql = 'select QQNum, Nick, Age,Gender, Auth, QunNum from '
set @sql += @tblName + ' where Nick =' +char(39)+ CONVERT(nvarchar(15), @Nick) +char(39)

print @sql
insert into #NickList(QQNum, Nick,Age,Gender,Auth,QunNum) exec(@sql)

print @tblname + ' OK'

set @tblIdx += 1
end

set @dbIdx += 1
end

select * from #NickList order by QQNum asc
--group by QQNum order by QQNum asc,count(distinct QQNum)

最后说几句

上面所有的sql我都放在我的下面这个项目中,欢迎star,fork

https://github.com/bboysoulcn/shegongku

欢迎关注Bboysoul的博客www.bboy.app

Have Fun

欢迎关注我的其它发布渠道