首页 > 数据库技术 > 详细

QQ群关系数据库处理

时间:2018-03-07 14:00:31      阅读:2664      评论:0      收藏:0      [点我收藏+]

 

1.附加数据库

EXEC sp_attach_single_file_db @dbname=  ‘GroupData1_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData1_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData2_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData2_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData3_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData3_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData4_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData4_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData5_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData5_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData6_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData6_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData7_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData7_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData8_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData8_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData9_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData9_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData10_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData10_Data.MDF‘
EXEC sp_attach_single_file_db @dbname=  ‘GroupData11_Data‘ , @physname= ‘/media/disk4/share/DataSet/QunData/GroupData11_Data.MDF‘



EXEC sp_attach_db "QunInfo1", "/media/disk4/share/DataSet/QunData/QunInfo1_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo1_Data_log.LDF"
EXEC sp_attach_db "QunInfo2", "/media/disk4/share/DataSet/QunData/QunInfo2_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo2_Data_log.LDF"
EXEC sp_attach_db "QunInfo3", "/media/disk4/share/DataSet/QunData/QunInfo3_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo3_Data_log.LDF"
EXEC sp_attach_db "QunInfo4", "/media/disk4/share/DataSet/QunData/QunInfo4_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo4_Data_log.LDF"
EXEC sp_attach_db "QunInfo5", "/media/disk4/share/DataSet/QunData/QunInfo5_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo5_Data_log.LDF"
EXEC sp_attach_db "QunInfo6", "/media/disk4/share/DataSet/QunData/QunInfo6_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo6_Data_log.LDF"
EXEC sp_attach_db "QunInfo7", "/media/disk4/share/DataSet/QunData/QunInfo7_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo7_Data_log.LDF"
EXEC sp_attach_db "QunInfo8", "/media/disk4/share/DataSet/QunData/QunInfo8_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo8_Data_log.LDF"
EXEC sp_attach_db "QunInfo9", "/media/disk4/share/DataSet/QunData/QunInfo9_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo9_Data_log.LDF"
EXEC sp_attach_db "QunInfo10", "/media/disk4/share/DataSet/QunData/QunInfo10_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo10_Data_log.LDF"
EXEC sp_attach_db "QunInfo11", "/media/disk4/share/DataSet/QunData/QunInfo11_Data.MDF", "/media/disk4/share/DataSet/QunData/QunInfo11_Data_log.LDF"

2.建立索引,加快查询速度

---------------------------------------------  
--QQ数据库查询优化  
--执行完改SQL脚本,可以通过proc_findQunUseQQNum查询  
--exec proc_findQunUseQQNum 12345678  
--执行效率在15-20s左右  
--如有更好的优化希望能告知  
----------------------------------------------  
--给GroupData中的表创建QQNum的索引  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group7‘)   
 CREATE INDEX ix_QQNum_Group7 On GroupData1_Data.dbo.Group7 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group75‘)   
 CREATE INDEX ix_QQNum_Group75 On GroupData1_Data.dbo.Group75 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group8‘)   
 CREATE INDEX ix_QQNum_Group8 On GroupData1_Data.dbo.Group8 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group76‘)   
 CREATE INDEX ix_QQNum_Group76 On GroupData1_Data.dbo.Group76 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group9‘)   
 CREATE INDEX ix_QQNum_Group9 On GroupData1_Data.dbo.Group9 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group77‘)   
 CREATE INDEX ix_QQNum_Group77 On GroupData1_Data.dbo.Group77 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group10‘)   
 CREATE INDEX ix_QQNum_Group10 On GroupData1_Data.dbo.Group10 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group78‘)   
 CREATE INDEX ix_QQNum_Group78 On GroupData1_Data.dbo.Group78 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group11‘)   
 CREATE INDEX ix_QQNum_Group11 On GroupData1_Data.dbo.Group11 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group79‘)   
 CREATE INDEX ix_QQNum_Group79 On GroupData1_Data.dbo.Group79 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group12‘)   
 CREATE INDEX ix_QQNum_Group12 On GroupData1_Data.dbo.Group12 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group80‘)   
 CREATE INDEX ix_QQNum_Group80 On GroupData1_Data.dbo.Group80 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group13‘)   
 CREATE INDEX ix_QQNum_Group13 On GroupData1_Data.dbo.Group13 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group81‘)   
 CREATE INDEX ix_QQNum_Group81 On GroupData1_Data.dbo.Group81 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group14‘)   
 CREATE INDEX ix_QQNum_Group14 On GroupData1_Data.dbo.Group14 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group82‘)   
 CREATE INDEX ix_QQNum_Group82 On GroupData1_Data.dbo.Group82 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group15‘)   
 CREATE INDEX ix_QQNum_Group15 On GroupData1_Data.dbo.Group15 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group83‘)   
 CREATE INDEX ix_QQNum_Group83 On GroupData1_Data.dbo.Group83 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group16‘)   
 CREATE INDEX ix_QQNum_Group16 On GroupData1_Data.dbo.Group16 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group84‘)   
 CREATE INDEX ix_QQNum_Group84 On GroupData1_Data.dbo.Group84 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group17‘)   
 CREATE INDEX ix_QQNum_Group17 On GroupData1_Data.dbo.Group17 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group85‘)   
 CREATE INDEX ix_QQNum_Group85 On GroupData1_Data.dbo.Group85 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group18‘)   
 CREATE INDEX ix_QQNum_Group18 On GroupData1_Data.dbo.Group18 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group86‘)   
 CREATE INDEX ix_QQNum_Group86 On GroupData1_Data.dbo.Group86 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group19‘)   
 CREATE INDEX ix_QQNum_Group19 On GroupData1_Data.dbo.Group19 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group87‘)   
 CREATE INDEX ix_QQNum_Group87 On GroupData1_Data.dbo.Group87 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group20‘)   
 CREATE INDEX ix_QQNum_Group20 On GroupData1_Data.dbo.Group20 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group88‘)   
 CREATE INDEX ix_QQNum_Group88 On GroupData1_Data.dbo.Group88 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group21‘)   
 CREATE INDEX ix_QQNum_Group21 On GroupData1_Data.dbo.Group21 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group89‘)   
 CREATE INDEX ix_QQNum_Group89 On GroupData1_Data.dbo.Group89 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group22‘)   
 CREATE INDEX ix_QQNum_Group22 On GroupData1_Data.dbo.Group22 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group90‘)   
 CREATE INDEX ix_QQNum_Group90 On GroupData1_Data.dbo.Group90 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group23‘)   
 CREATE INDEX ix_QQNum_Group23 On GroupData1_Data.dbo.Group23 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group91‘)   
 CREATE INDEX ix_QQNum_Group91 On GroupData1_Data.dbo.Group91 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group24‘)   
 CREATE INDEX ix_QQNum_Group24 On GroupData1_Data.dbo.Group24 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group92‘)   
 CREATE INDEX ix_QQNum_Group92 On GroupData1_Data.dbo.Group92 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group25‘)   
 CREATE INDEX ix_QQNum_Group25 On GroupData1_Data.dbo.Group25 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group93‘)   
 CREATE INDEX ix_QQNum_Group93 On GroupData1_Data.dbo.Group93 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group26‘)   
 CREATE INDEX ix_QQNum_Group26 On GroupData1_Data.dbo.Group26 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group94‘)   
 CREATE INDEX ix_QQNum_Group94 On GroupData1_Data.dbo.Group94 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group27‘)   
 CREATE INDEX ix_QQNum_Group27 On GroupData1_Data.dbo.Group27 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group95‘)   
 CREATE INDEX ix_QQNum_Group95 On GroupData1_Data.dbo.Group95 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group28‘)   
 CREATE INDEX ix_QQNum_Group28 On GroupData1_Data.dbo.Group28 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group96‘)   
 CREATE INDEX ix_QQNum_Group96 On GroupData1_Data.dbo.Group96 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group29‘)   
 CREATE INDEX ix_QQNum_Group29 On GroupData1_Data.dbo.Group29 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group97‘)   
 CREATE INDEX ix_QQNum_Group97 On GroupData1_Data.dbo.Group97 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group30‘)   
 CREATE INDEX ix_QQNum_Group30 On GroupData1_Data.dbo.Group30 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group98‘)   
 CREATE INDEX ix_QQNum_Group98 On GroupData1_Data.dbo.Group98 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group31‘)   
 CREATE INDEX ix_QQNum_Group31 On GroupData1_Data.dbo.Group31 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group99‘)   
 CREATE INDEX ix_QQNum_Group99 On GroupData1_Data.dbo.Group99 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group32‘)   
 CREATE INDEX ix_QQNum_Group32 On GroupData1_Data.dbo.Group32 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group100‘)   
 CREATE INDEX ix_QQNum_Group100 On GroupData1_Data.dbo.Group100 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group33‘)   
 CREATE INDEX ix_QQNum_Group33 On GroupData1_Data.dbo.Group33 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group34‘)   
 CREATE INDEX ix_QQNum_Group34 On GroupData1_Data.dbo.Group34 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group35‘)   
 CREATE INDEX ix_QQNum_Group35 On GroupData1_Data.dbo.Group35 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group36‘)   
 CREATE INDEX ix_QQNum_Group36 On GroupData1_Data.dbo.Group36 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group37‘)   
 CREATE INDEX ix_QQNum_Group37 On GroupData1_Data.dbo.Group37 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group38‘)   
 CREATE INDEX ix_QQNum_Group38 On GroupData1_Data.dbo.Group38 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group39‘)   
 CREATE INDEX ix_QQNum_Group39 On GroupData1_Data.dbo.Group39 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group40‘)   
 CREATE INDEX ix_QQNum_Group40 On GroupData1_Data.dbo.Group40 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group41‘)   
 CREATE INDEX ix_QQNum_Group41 On GroupData1_Data.dbo.Group41 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group42‘)   
 CREATE INDEX ix_QQNum_Group42 On GroupData1_Data.dbo.Group42 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group43‘)   
 CREATE INDEX ix_QQNum_Group43 On GroupData1_Data.dbo.Group43 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group44‘)   
 CREATE INDEX ix_QQNum_Group44 On GroupData1_Data.dbo.Group44 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group45‘)   
 CREATE INDEX ix_QQNum_Group45 On GroupData1_Data.dbo.Group45 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group46‘)   
 CREATE INDEX ix_QQNum_Group46 On GroupData1_Data.dbo.Group46 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group47‘)   
 CREATE INDEX ix_QQNum_Group47 On GroupData1_Data.dbo.Group47 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group48‘)   
 CREATE INDEX ix_QQNum_Group48 On GroupData1_Data.dbo.Group48 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group49‘)   
 CREATE INDEX ix_QQNum_Group49 On GroupData1_Data.dbo.Group49 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group50‘)   
 CREATE INDEX ix_QQNum_Group50 On GroupData1_Data.dbo.Group50 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group51‘)   
 CREATE INDEX ix_QQNum_Group51 On GroupData1_Data.dbo.Group51 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group52‘)   
 CREATE INDEX ix_QQNum_Group52 On GroupData1_Data.dbo.Group52 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group53‘)   
 CREATE INDEX ix_QQNum_Group53 On GroupData1_Data.dbo.Group53 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group54‘)   
 CREATE INDEX ix_QQNum_Group54 On GroupData1_Data.dbo.Group54 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group55‘)   
 CREATE INDEX ix_QQNum_Group55 On GroupData1_Data.dbo.Group55 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group56‘)   
 CREATE INDEX ix_QQNum_Group56 On GroupData1_Data.dbo.Group56 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group57‘)   
 CREATE INDEX ix_QQNum_Group57 On GroupData1_Data.dbo.Group57 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group58‘)   
 CREATE INDEX ix_QQNum_Group58 On GroupData1_Data.dbo.Group58 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group59‘)   
 CREATE INDEX ix_QQNum_Group59 On GroupData1_Data.dbo.Group59 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group60‘)   
 CREATE INDEX ix_QQNum_Group60 On GroupData1_Data.dbo.Group60 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group61‘)   
 CREATE INDEX ix_QQNum_Group61 On GroupData1_Data.dbo.Group61 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group62‘)   
 CREATE INDEX ix_QQNum_Group62 On GroupData1_Data.dbo.Group62 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group63‘)   
 CREATE INDEX ix_QQNum_Group63 On GroupData1_Data.dbo.Group63 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group64‘)   
 CREATE INDEX ix_QQNum_Group64 On GroupData1_Data.dbo.Group64 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group65‘)   
 CREATE INDEX ix_QQNum_Group65 On GroupData1_Data.dbo.Group65 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group66‘)   
 CREATE INDEX ix_QQNum_Group66 On GroupData1_Data.dbo.Group66 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group67‘)   
 CREATE INDEX ix_QQNum_Group67 On GroupData1_Data.dbo.Group67 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group68‘)   
 CREATE INDEX ix_QQNum_Group68 On GroupData1_Data.dbo.Group68 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1‘)   
 CREATE INDEX ix_QQNum_Group1 On GroupData1_Data.dbo.Group1 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group69‘)   
 CREATE INDEX ix_QQNum_Group69 On GroupData1_Data.dbo.Group69 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group2‘)   
 CREATE INDEX ix_QQNum_Group2 On GroupData1_Data.dbo.Group2 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group70‘)   
 CREATE INDEX ix_QQNum_Group70 On GroupData1_Data.dbo.Group70 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group3‘)   
 CREATE INDEX ix_QQNum_Group3 On GroupData1_Data.dbo.Group3 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group71‘)   
 CREATE INDEX ix_QQNum_Group71 On GroupData1_Data.dbo.Group71 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group4‘)   
 CREATE INDEX ix_QQNum_Group4 On GroupData1_Data.dbo.Group4 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group72‘)   
 CREATE INDEX ix_QQNum_Group72 On GroupData1_Data.dbo.Group72 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group5‘)   
 CREATE INDEX ix_QQNum_Group5 On GroupData1_Data.dbo.Group5 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group73‘)   
 CREATE INDEX ix_QQNum_Group73 On GroupData1_Data.dbo.Group73 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData1_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group6‘)   
 CREATE INDEX ix_QQNum_Group6 On GroupData1_Data.dbo.Group6 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group174‘)   
 CREATE INDEX ix_QQNum_Group174 On GroupData2_Data.dbo.Group174 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group107‘)   
 CREATE INDEX ix_QQNum_Group107 On GroupData2_Data.dbo.Group107 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group175‘)   
 CREATE INDEX ix_QQNum_Group175 On GroupData2_Data.dbo.Group175 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group108‘)   
 CREATE INDEX ix_QQNum_Group108 On GroupData2_Data.dbo.Group108 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group176‘)   
 CREATE INDEX ix_QQNum_Group176 On GroupData2_Data.dbo.Group176 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group109‘)   
 CREATE INDEX ix_QQNum_Group109 On GroupData2_Data.dbo.Group109 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group177‘)   
 CREATE INDEX ix_QQNum_Group177 On GroupData2_Data.dbo.Group177 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group110‘)   
 CREATE INDEX ix_QQNum_Group110 On GroupData2_Data.dbo.Group110 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group178‘)   
 CREATE INDEX ix_QQNum_Group178 On GroupData2_Data.dbo.Group178 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group111‘)   
 CREATE INDEX ix_QQNum_Group111 On GroupData2_Data.dbo.Group111 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group179‘)   
 CREATE INDEX ix_QQNum_Group179 On GroupData2_Data.dbo.Group179 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group112‘)   
 CREATE INDEX ix_QQNum_Group112 On GroupData2_Data.dbo.Group112 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group180‘)   
 CREATE INDEX ix_QQNum_Group180 On GroupData2_Data.dbo.Group180 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group113‘)   
 CREATE INDEX ix_QQNum_Group113 On GroupData2_Data.dbo.Group113 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group181‘)   
 CREATE INDEX ix_QQNum_Group181 On GroupData2_Data.dbo.Group181 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group114‘)   
 CREATE INDEX ix_QQNum_Group114 On GroupData2_Data.dbo.Group114 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group182‘)   
 CREATE INDEX ix_QQNum_Group182 On GroupData2_Data.dbo.Group182 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group115‘)   
 CREATE INDEX ix_QQNum_Group115 On GroupData2_Data.dbo.Group115 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group183‘)   
 CREATE INDEX ix_QQNum_Group183 On GroupData2_Data.dbo.Group183 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group116‘)   
 CREATE INDEX ix_QQNum_Group116 On GroupData2_Data.dbo.Group116 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group184‘)   
 CREATE INDEX ix_QQNum_Group184 On GroupData2_Data.dbo.Group184 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group117‘)   
 CREATE INDEX ix_QQNum_Group117 On GroupData2_Data.dbo.Group117 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group185‘)   
 CREATE INDEX ix_QQNum_Group185 On GroupData2_Data.dbo.Group185 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group118‘)   
 CREATE INDEX ix_QQNum_Group118 On GroupData2_Data.dbo.Group118 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group186‘)   
 CREATE INDEX ix_QQNum_Group186 On GroupData2_Data.dbo.Group186 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group119‘)   
 CREATE INDEX ix_QQNum_Group119 On GroupData2_Data.dbo.Group119 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group187‘)   
 CREATE INDEX ix_QQNum_Group187 On GroupData2_Data.dbo.Group187 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group120‘)   
 CREATE INDEX ix_QQNum_Group120 On GroupData2_Data.dbo.Group120 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group188‘)   
 CREATE INDEX ix_QQNum_Group188 On GroupData2_Data.dbo.Group188 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group121‘)   
 CREATE INDEX ix_QQNum_Group121 On GroupData2_Data.dbo.Group121 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group189‘)   
 CREATE INDEX ix_QQNum_Group189 On GroupData2_Data.dbo.Group189 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group122‘)   
 CREATE INDEX ix_QQNum_Group122 On GroupData2_Data.dbo.Group122 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group190‘)   
 CREATE INDEX ix_QQNum_Group190 On GroupData2_Data.dbo.Group190 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group123‘)   
 CREATE INDEX ix_QQNum_Group123 On GroupData2_Data.dbo.Group123 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group191‘)   
 CREATE INDEX ix_QQNum_Group191 On GroupData2_Data.dbo.Group191 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group124‘)   
 CREATE INDEX ix_QQNum_Group124 On GroupData2_Data.dbo.Group124 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group192‘)   
 CREATE INDEX ix_QQNum_Group192 On GroupData2_Data.dbo.Group192 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group125‘)   
 CREATE INDEX ix_QQNum_Group125 On GroupData2_Data.dbo.Group125 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group193‘)   
 CREATE INDEX ix_QQNum_Group193 On GroupData2_Data.dbo.Group193 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group126‘)   
 CREATE INDEX ix_QQNum_Group126 On GroupData2_Data.dbo.Group126 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group194‘)   
 CREATE INDEX ix_QQNum_Group194 On GroupData2_Data.dbo.Group194 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group127‘)   
 CREATE INDEX ix_QQNum_Group127 On GroupData2_Data.dbo.Group127 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group195‘)   
 CREATE INDEX ix_QQNum_Group195 On GroupData2_Data.dbo.Group195 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group128‘)   
 CREATE INDEX ix_QQNum_Group128 On GroupData2_Data.dbo.Group128 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group196‘)   
 CREATE INDEX ix_QQNum_Group196 On GroupData2_Data.dbo.Group196 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group129‘)   
 CREATE INDEX ix_QQNum_Group129 On GroupData2_Data.dbo.Group129 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group197‘)   
 CREATE INDEX ix_QQNum_Group197 On GroupData2_Data.dbo.Group197 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group130‘)   
 CREATE INDEX ix_QQNum_Group130 On GroupData2_Data.dbo.Group130 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group198‘)   
 CREATE INDEX ix_QQNum_Group198 On GroupData2_Data.dbo.Group198 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group131‘)   
 CREATE INDEX ix_QQNum_Group131 On GroupData2_Data.dbo.Group131 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group199‘)   
 CREATE INDEX ix_QQNum_Group199 On GroupData2_Data.dbo.Group199 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group132‘)   
 CREATE INDEX ix_QQNum_Group132 On GroupData2_Data.dbo.Group132 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group200‘)   
 CREATE INDEX ix_QQNum_Group200 On GroupData2_Data.dbo.Group200 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group133‘)   
 CREATE INDEX ix_QQNum_Group133 On GroupData2_Data.dbo.Group133 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group134‘)   
 CREATE INDEX ix_QQNum_Group134 On GroupData2_Data.dbo.Group134 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group135‘)   
 CREATE INDEX ix_QQNum_Group135 On GroupData2_Data.dbo.Group135 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group136‘)   
 CREATE INDEX ix_QQNum_Group136 On GroupData2_Data.dbo.Group136 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group137‘)   
 CREATE INDEX ix_QQNum_Group137 On GroupData2_Data.dbo.Group137 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group138‘)   
 CREATE INDEX ix_QQNum_Group138 On GroupData2_Data.dbo.Group138 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group139‘)   
 CREATE INDEX ix_QQNum_Group139 On GroupData2_Data.dbo.Group139 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group140‘)   
 CREATE INDEX ix_QQNum_Group140 On GroupData2_Data.dbo.Group140 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group141‘)   
 CREATE INDEX ix_QQNum_Group141 On GroupData2_Data.dbo.Group141 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group142‘)   
 CREATE INDEX ix_QQNum_Group142 On GroupData2_Data.dbo.Group142 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group143‘)   
 CREATE INDEX ix_QQNum_Group143 On GroupData2_Data.dbo.Group143 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group144‘)   
 CREATE INDEX ix_QQNum_Group144 On GroupData2_Data.dbo.Group144 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group145‘)   
 CREATE INDEX ix_QQNum_Group145 On GroupData2_Data.dbo.Group145 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group146‘)   
 CREATE INDEX ix_QQNum_Group146 On GroupData2_Data.dbo.Group146 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group147‘)   
 CREATE INDEX ix_QQNum_Group147 On GroupData2_Data.dbo.Group147 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group148‘)   
 CREATE INDEX ix_QQNum_Group148 On GroupData2_Data.dbo.Group148 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group149‘)   
 CREATE INDEX ix_QQNum_Group149 On GroupData2_Data.dbo.Group149 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group150‘)   
 CREATE INDEX ix_QQNum_Group150 On GroupData2_Data.dbo.Group150 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group151‘)   
 CREATE INDEX ix_QQNum_Group151 On GroupData2_Data.dbo.Group151 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group152‘)   
 CREATE INDEX ix_QQNum_Group152 On GroupData2_Data.dbo.Group152 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group153‘)   
 CREATE INDEX ix_QQNum_Group153 On GroupData2_Data.dbo.Group153 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group154‘)   
 CREATE INDEX ix_QQNum_Group154 On GroupData2_Data.dbo.Group154 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group155‘)   
 CREATE INDEX ix_QQNum_Group155 On GroupData2_Data.dbo.Group155 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group156‘)   
 CREATE INDEX ix_QQNum_Group156 On GroupData2_Data.dbo.Group156 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group157‘)   
 CREATE INDEX ix_QQNum_Group157 On GroupData2_Data.dbo.Group157 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group158‘)   
 CREATE INDEX ix_QQNum_Group158 On GroupData2_Data.dbo.Group158 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group159‘)   
 CREATE INDEX ix_QQNum_Group159 On GroupData2_Data.dbo.Group159 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group160‘)   
 CREATE INDEX ix_QQNum_Group160 On GroupData2_Data.dbo.Group160 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group161‘)   
 CREATE INDEX ix_QQNum_Group161 On GroupData2_Data.dbo.Group161 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group162‘)   
 CREATE INDEX ix_QQNum_Group162 On GroupData2_Data.dbo.Group162 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group163‘)   
 CREATE INDEX ix_QQNum_Group163 On GroupData2_Data.dbo.Group163 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group164‘)   
 CREATE INDEX ix_QQNum_Group164 On GroupData2_Data.dbo.Group164 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group165‘)   
 CREATE INDEX ix_QQNum_Group165 On GroupData2_Data.dbo.Group165 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group166‘)   
 CREATE INDEX ix_QQNum_Group166 On GroupData2_Data.dbo.Group166 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group167‘)   
 CREATE INDEX ix_QQNum_Group167 On GroupData2_Data.dbo.Group167 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group168‘)   
 CREATE INDEX ix_QQNum_Group168 On GroupData2_Data.dbo.Group168 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group101‘)   
 CREATE INDEX ix_QQNum_Group101 On GroupData2_Data.dbo.Group101 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group169‘)   
 CREATE INDEX ix_QQNum_Group169 On GroupData2_Data.dbo.Group169 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group102‘)   
 CREATE INDEX ix_QQNum_Group102 On GroupData2_Data.dbo.Group102 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group170‘)   
 CREATE INDEX ix_QQNum_Group170 On GroupData2_Data.dbo.Group170 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group103‘)   
 CREATE INDEX ix_QQNum_Group103 On GroupData2_Data.dbo.Group103 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group171‘)   
 CREATE INDEX ix_QQNum_Group171 On GroupData2_Data.dbo.Group171 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group104‘)   
 CREATE INDEX ix_QQNum_Group104 On GroupData2_Data.dbo.Group104 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group172‘)   
 CREATE INDEX ix_QQNum_Group172 On GroupData2_Data.dbo.Group172 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group105‘)   
 CREATE INDEX ix_QQNum_Group105 On GroupData2_Data.dbo.Group105 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group173‘)   
 CREATE INDEX ix_QQNum_Group173 On GroupData2_Data.dbo.Group173 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData2_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group106‘)   
 CREATE INDEX ix_QQNum_Group106 On GroupData2_Data.dbo.Group106 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group274‘)   
 CREATE INDEX ix_QQNum_Group274 On GroupData3_Data.dbo.Group274 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group207‘)   
 CREATE INDEX ix_QQNum_Group207 On GroupData3_Data.dbo.Group207 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group275‘)   
 CREATE INDEX ix_QQNum_Group275 On GroupData3_Data.dbo.Group275 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group208‘)   
 CREATE INDEX ix_QQNum_Group208 On GroupData3_Data.dbo.Group208 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group276‘)   
 CREATE INDEX ix_QQNum_Group276 On GroupData3_Data.dbo.Group276 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group209‘)   
 CREATE INDEX ix_QQNum_Group209 On GroupData3_Data.dbo.Group209 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group277‘)   
 CREATE INDEX ix_QQNum_Group277 On GroupData3_Data.dbo.Group277 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group210‘)   
 CREATE INDEX ix_QQNum_Group210 On GroupData3_Data.dbo.Group210 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group278‘)   
 CREATE INDEX ix_QQNum_Group278 On GroupData3_Data.dbo.Group278 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group211‘)   
 CREATE INDEX ix_QQNum_Group211 On GroupData3_Data.dbo.Group211 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group279‘)   
 CREATE INDEX ix_QQNum_Group279 On GroupData3_Data.dbo.Group279 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group212‘)   
 CREATE INDEX ix_QQNum_Group212 On GroupData3_Data.dbo.Group212 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group280‘)   
 CREATE INDEX ix_QQNum_Group280 On GroupData3_Data.dbo.Group280 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group213‘)   
 CREATE INDEX ix_QQNum_Group213 On GroupData3_Data.dbo.Group213 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group281‘)   
 CREATE INDEX ix_QQNum_Group281 On GroupData3_Data.dbo.Group281 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group214‘)   
 CREATE INDEX ix_QQNum_Group214 On GroupData3_Data.dbo.Group214 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group282‘)   
 CREATE INDEX ix_QQNum_Group282 On GroupData3_Data.dbo.Group282 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group215‘)   
 CREATE INDEX ix_QQNum_Group215 On GroupData3_Data.dbo.Group215 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group283‘)   
 CREATE INDEX ix_QQNum_Group283 On GroupData3_Data.dbo.Group283 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group216‘)   
 CREATE INDEX ix_QQNum_Group216 On GroupData3_Data.dbo.Group216 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group284‘)   
 CREATE INDEX ix_QQNum_Group284 On GroupData3_Data.dbo.Group284 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group217‘)   
 CREATE INDEX ix_QQNum_Group217 On GroupData3_Data.dbo.Group217 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group285‘)   
 CREATE INDEX ix_QQNum_Group285 On GroupData3_Data.dbo.Group285 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group218‘)   
 CREATE INDEX ix_QQNum_Group218 On GroupData3_Data.dbo.Group218 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group286‘)   
 CREATE INDEX ix_QQNum_Group286 On GroupData3_Data.dbo.Group286 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group219‘)   
 CREATE INDEX ix_QQNum_Group219 On GroupData3_Data.dbo.Group219 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group287‘)   
 CREATE INDEX ix_QQNum_Group287 On GroupData3_Data.dbo.Group287 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group220‘)   
 CREATE INDEX ix_QQNum_Group220 On GroupData3_Data.dbo.Group220 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group288‘)   
 CREATE INDEX ix_QQNum_Group288 On GroupData3_Data.dbo.Group288 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group221‘)   
 CREATE INDEX ix_QQNum_Group221 On GroupData3_Data.dbo.Group221 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group289‘)   
 CREATE INDEX ix_QQNum_Group289 On GroupData3_Data.dbo.Group289 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group222‘)   
 CREATE INDEX ix_QQNum_Group222 On GroupData3_Data.dbo.Group222 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group290‘)   
 CREATE INDEX ix_QQNum_Group290 On GroupData3_Data.dbo.Group290 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group223‘)   
 CREATE INDEX ix_QQNum_Group223 On GroupData3_Data.dbo.Group223 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group291‘)   
 CREATE INDEX ix_QQNum_Group291 On GroupData3_Data.dbo.Group291 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group224‘)   
 CREATE INDEX ix_QQNum_Group224 On GroupData3_Data.dbo.Group224 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group292‘)   
 CREATE INDEX ix_QQNum_Group292 On GroupData3_Data.dbo.Group292 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group225‘)   
 CREATE INDEX ix_QQNum_Group225 On GroupData3_Data.dbo.Group225 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group293‘)   
 CREATE INDEX ix_QQNum_Group293 On GroupData3_Data.dbo.Group293 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group226‘)   
 CREATE INDEX ix_QQNum_Group226 On GroupData3_Data.dbo.Group226 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group294‘)   
 CREATE INDEX ix_QQNum_Group294 On GroupData3_Data.dbo.Group294 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group227‘)   
 CREATE INDEX ix_QQNum_Group227 On GroupData3_Data.dbo.Group227 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group295‘)   
 CREATE INDEX ix_QQNum_Group295 On GroupData3_Data.dbo.Group295 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group228‘)   
 CREATE INDEX ix_QQNum_Group228 On GroupData3_Data.dbo.Group228 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group296‘)   
 CREATE INDEX ix_QQNum_Group296 On GroupData3_Data.dbo.Group296 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group229‘)   
 CREATE INDEX ix_QQNum_Group229 On GroupData3_Data.dbo.Group229 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group297‘)   
 CREATE INDEX ix_QQNum_Group297 On GroupData3_Data.dbo.Group297 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group230‘)   
 CREATE INDEX ix_QQNum_Group230 On GroupData3_Data.dbo.Group230 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group298‘)   
 CREATE INDEX ix_QQNum_Group298 On GroupData3_Data.dbo.Group298 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group231‘)   
 CREATE INDEX ix_QQNum_Group231 On GroupData3_Data.dbo.Group231 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group299‘)   
 CREATE INDEX ix_QQNum_Group299 On GroupData3_Data.dbo.Group299 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group232‘)   
 CREATE INDEX ix_QQNum_Group232 On GroupData3_Data.dbo.Group232 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group300‘)   
 CREATE INDEX ix_QQNum_Group300 On GroupData3_Data.dbo.Group300 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group233‘)   
 CREATE INDEX ix_QQNum_Group233 On GroupData3_Data.dbo.Group233 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group234‘)   
 CREATE INDEX ix_QQNum_Group234 On GroupData3_Data.dbo.Group234 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group235‘)   
 CREATE INDEX ix_QQNum_Group235 On GroupData3_Data.dbo.Group235 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group236‘)   
 CREATE INDEX ix_QQNum_Group236 On GroupData3_Data.dbo.Group236 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group237‘)   
 CREATE INDEX ix_QQNum_Group237 On GroupData3_Data.dbo.Group237 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group238‘)   
 CREATE INDEX ix_QQNum_Group238 On GroupData3_Data.dbo.Group238 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group239‘)   
 CREATE INDEX ix_QQNum_Group239 On GroupData3_Data.dbo.Group239 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group240‘)   
 CREATE INDEX ix_QQNum_Group240 On GroupData3_Data.dbo.Group240 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group241‘)   
 CREATE INDEX ix_QQNum_Group241 On GroupData3_Data.dbo.Group241 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group242‘)   
 CREATE INDEX ix_QQNum_Group242 On GroupData3_Data.dbo.Group242 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group243‘)   
 CREATE INDEX ix_QQNum_Group243 On GroupData3_Data.dbo.Group243 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group244‘)   
 CREATE INDEX ix_QQNum_Group244 On GroupData3_Data.dbo.Group244 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group245‘)   
 CREATE INDEX ix_QQNum_Group245 On GroupData3_Data.dbo.Group245 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group246‘)   
 CREATE INDEX ix_QQNum_Group246 On GroupData3_Data.dbo.Group246 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group247‘)   
 CREATE INDEX ix_QQNum_Group247 On GroupData3_Data.dbo.Group247 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group248‘)   
 CREATE INDEX ix_QQNum_Group248 On GroupData3_Data.dbo.Group248 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group249‘)   
 CREATE INDEX ix_QQNum_Group249 On GroupData3_Data.dbo.Group249 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group250‘)   
 CREATE INDEX ix_QQNum_Group250 On GroupData3_Data.dbo.Group250 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group251‘)   
 CREATE INDEX ix_QQNum_Group251 On GroupData3_Data.dbo.Group251 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group252‘)   
 CREATE INDEX ix_QQNum_Group252 On GroupData3_Data.dbo.Group252 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group253‘)   
 CREATE INDEX ix_QQNum_Group253 On GroupData3_Data.dbo.Group253 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group254‘)   
 CREATE INDEX ix_QQNum_Group254 On GroupData3_Data.dbo.Group254 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group255‘)   
 CREATE INDEX ix_QQNum_Group255 On GroupData3_Data.dbo.Group255 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group256‘)   
 CREATE INDEX ix_QQNum_Group256 On GroupData3_Data.dbo.Group256 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group257‘)   
 CREATE INDEX ix_QQNum_Group257 On GroupData3_Data.dbo.Group257 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group258‘)   
 CREATE INDEX ix_QQNum_Group258 On GroupData3_Data.dbo.Group258 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group259‘)   
 CREATE INDEX ix_QQNum_Group259 On GroupData3_Data.dbo.Group259 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group260‘)   
 CREATE INDEX ix_QQNum_Group260 On GroupData3_Data.dbo.Group260 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group261‘)   
 CREATE INDEX ix_QQNum_Group261 On GroupData3_Data.dbo.Group261 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group262‘)   
 CREATE INDEX ix_QQNum_Group262 On GroupData3_Data.dbo.Group262 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group263‘)   
 CREATE INDEX ix_QQNum_Group263 On GroupData3_Data.dbo.Group263 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group264‘)   
 CREATE INDEX ix_QQNum_Group264 On GroupData3_Data.dbo.Group264 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group265‘)   
 CREATE INDEX ix_QQNum_Group265 On GroupData3_Data.dbo.Group265 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group266‘)   
 CREATE INDEX ix_QQNum_Group266 On GroupData3_Data.dbo.Group266 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group267‘)   
 CREATE INDEX ix_QQNum_Group267 On GroupData3_Data.dbo.Group267 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group268‘)   
 CREATE INDEX ix_QQNum_Group268 On GroupData3_Data.dbo.Group268 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group201‘)   
 CREATE INDEX ix_QQNum_Group201 On GroupData3_Data.dbo.Group201 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group269‘)   
 CREATE INDEX ix_QQNum_Group269 On GroupData3_Data.dbo.Group269 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group202‘)   
 CREATE INDEX ix_QQNum_Group202 On GroupData3_Data.dbo.Group202 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group270‘)   
 CREATE INDEX ix_QQNum_Group270 On GroupData3_Data.dbo.Group270 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group203‘)   
 CREATE INDEX ix_QQNum_Group203 On GroupData3_Data.dbo.Group203 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group271‘)   
 CREATE INDEX ix_QQNum_Group271 On GroupData3_Data.dbo.Group271 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group204‘)   
 CREATE INDEX ix_QQNum_Group204 On GroupData3_Data.dbo.Group204 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group272‘)   
 CREATE INDEX ix_QQNum_Group272 On GroupData3_Data.dbo.Group272 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group205‘)   
 CREATE INDEX ix_QQNum_Group205 On GroupData3_Data.dbo.Group205 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group273‘)   
 CREATE INDEX ix_QQNum_Group273 On GroupData3_Data.dbo.Group273 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData3_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group206‘)   
 CREATE INDEX ix_QQNum_Group206 On GroupData3_Data.dbo.Group206 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group374‘)   
 CREATE INDEX ix_QQNum_Group374 On GroupData4_Data.dbo.Group374 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group307‘)   
 CREATE INDEX ix_QQNum_Group307 On GroupData4_Data.dbo.Group307 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group375‘)   
 CREATE INDEX ix_QQNum_Group375 On GroupData4_Data.dbo.Group375 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group308‘)   
 CREATE INDEX ix_QQNum_Group308 On GroupData4_Data.dbo.Group308 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group376‘)   
 CREATE INDEX ix_QQNum_Group376 On GroupData4_Data.dbo.Group376 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group309‘)   
 CREATE INDEX ix_QQNum_Group309 On GroupData4_Data.dbo.Group309 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group377‘)   
 CREATE INDEX ix_QQNum_Group377 On GroupData4_Data.dbo.Group377 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group310‘)   
 CREATE INDEX ix_QQNum_Group310 On GroupData4_Data.dbo.Group310 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group378‘)   
 CREATE INDEX ix_QQNum_Group378 On GroupData4_Data.dbo.Group378 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group311‘)   
 CREATE INDEX ix_QQNum_Group311 On GroupData4_Data.dbo.Group311 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group379‘)   
 CREATE INDEX ix_QQNum_Group379 On GroupData4_Data.dbo.Group379 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group312‘)   
 CREATE INDEX ix_QQNum_Group312 On GroupData4_Data.dbo.Group312 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group380‘)   
 CREATE INDEX ix_QQNum_Group380 On GroupData4_Data.dbo.Group380 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group313‘)   
 CREATE INDEX ix_QQNum_Group313 On GroupData4_Data.dbo.Group313 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group381‘)   
 CREATE INDEX ix_QQNum_Group381 On GroupData4_Data.dbo.Group381 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group314‘)   
 CREATE INDEX ix_QQNum_Group314 On GroupData4_Data.dbo.Group314 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group382‘)   
 CREATE INDEX ix_QQNum_Group382 On GroupData4_Data.dbo.Group382 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group315‘)   
 CREATE INDEX ix_QQNum_Group315 On GroupData4_Data.dbo.Group315 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group383‘)   
 CREATE INDEX ix_QQNum_Group383 On GroupData4_Data.dbo.Group383 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group316‘)   
 CREATE INDEX ix_QQNum_Group316 On GroupData4_Data.dbo.Group316 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group384‘)   
 CREATE INDEX ix_QQNum_Group384 On GroupData4_Data.dbo.Group384 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group317‘)   
 CREATE INDEX ix_QQNum_Group317 On GroupData4_Data.dbo.Group317 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group385‘)   
 CREATE INDEX ix_QQNum_Group385 On GroupData4_Data.dbo.Group385 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group318‘)   
 CREATE INDEX ix_QQNum_Group318 On GroupData4_Data.dbo.Group318 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group386‘)   
 CREATE INDEX ix_QQNum_Group386 On GroupData4_Data.dbo.Group386 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group319‘)   
 CREATE INDEX ix_QQNum_Group319 On GroupData4_Data.dbo.Group319 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group387‘)   
 CREATE INDEX ix_QQNum_Group387 On GroupData4_Data.dbo.Group387 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group320‘)   
 CREATE INDEX ix_QQNum_Group320 On GroupData4_Data.dbo.Group320 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group388‘)   
 CREATE INDEX ix_QQNum_Group388 On GroupData4_Data.dbo.Group388 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group321‘)   
 CREATE INDEX ix_QQNum_Group321 On GroupData4_Data.dbo.Group321 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group389‘)   
 CREATE INDEX ix_QQNum_Group389 On GroupData4_Data.dbo.Group389 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group322‘)   
 CREATE INDEX ix_QQNum_Group322 On GroupData4_Data.dbo.Group322 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group390‘)   
 CREATE INDEX ix_QQNum_Group390 On GroupData4_Data.dbo.Group390 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group323‘)   
 CREATE INDEX ix_QQNum_Group323 On GroupData4_Data.dbo.Group323 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group391‘)   
 CREATE INDEX ix_QQNum_Group391 On GroupData4_Data.dbo.Group391 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group324‘)   
 CREATE INDEX ix_QQNum_Group324 On GroupData4_Data.dbo.Group324 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group392‘)   
 CREATE INDEX ix_QQNum_Group392 On GroupData4_Data.dbo.Group392 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group325‘)   
 CREATE INDEX ix_QQNum_Group325 On GroupData4_Data.dbo.Group325 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group393‘)   
 CREATE INDEX ix_QQNum_Group393 On GroupData4_Data.dbo.Group393 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group326‘)   
 CREATE INDEX ix_QQNum_Group326 On GroupData4_Data.dbo.Group326 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group394‘)   
 CREATE INDEX ix_QQNum_Group394 On GroupData4_Data.dbo.Group394 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group327‘)   
 CREATE INDEX ix_QQNum_Group327 On GroupData4_Data.dbo.Group327 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group395‘)   
 CREATE INDEX ix_QQNum_Group395 On GroupData4_Data.dbo.Group395 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group328‘)   
 CREATE INDEX ix_QQNum_Group328 On GroupData4_Data.dbo.Group328 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group396‘)   
 CREATE INDEX ix_QQNum_Group396 On GroupData4_Data.dbo.Group396 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group329‘)   
 CREATE INDEX ix_QQNum_Group329 On GroupData4_Data.dbo.Group329 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group397‘)   
 CREATE INDEX ix_QQNum_Group397 On GroupData4_Data.dbo.Group397 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group330‘)   
 CREATE INDEX ix_QQNum_Group330 On GroupData4_Data.dbo.Group330 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group398‘)   
 CREATE INDEX ix_QQNum_Group398 On GroupData4_Data.dbo.Group398 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group331‘)   
 CREATE INDEX ix_QQNum_Group331 On GroupData4_Data.dbo.Group331 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group399‘)   
 CREATE INDEX ix_QQNum_Group399 On GroupData4_Data.dbo.Group399 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group332‘)   
 CREATE INDEX ix_QQNum_Group332 On GroupData4_Data.dbo.Group332 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group400‘)   
 CREATE INDEX ix_QQNum_Group400 On GroupData4_Data.dbo.Group400 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group333‘)   
 CREATE INDEX ix_QQNum_Group333 On GroupData4_Data.dbo.Group333 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group334‘)   
 CREATE INDEX ix_QQNum_Group334 On GroupData4_Data.dbo.Group334 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group335‘)   
 CREATE INDEX ix_QQNum_Group335 On GroupData4_Data.dbo.Group335 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group336‘)   
 CREATE INDEX ix_QQNum_Group336 On GroupData4_Data.dbo.Group336 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group337‘)   
 CREATE INDEX ix_QQNum_Group337 On GroupData4_Data.dbo.Group337 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group338‘)   
 CREATE INDEX ix_QQNum_Group338 On GroupData4_Data.dbo.Group338 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group339‘)   
 CREATE INDEX ix_QQNum_Group339 On GroupData4_Data.dbo.Group339 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group340‘)   
 CREATE INDEX ix_QQNum_Group340 On GroupData4_Data.dbo.Group340 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group341‘)   
 CREATE INDEX ix_QQNum_Group341 On GroupData4_Data.dbo.Group341 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group342‘)   
 CREATE INDEX ix_QQNum_Group342 On GroupData4_Data.dbo.Group342 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group343‘)   
 CREATE INDEX ix_QQNum_Group343 On GroupData4_Data.dbo.Group343 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group344‘)   
 CREATE INDEX ix_QQNum_Group344 On GroupData4_Data.dbo.Group344 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group345‘)   
 CREATE INDEX ix_QQNum_Group345 On GroupData4_Data.dbo.Group345 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group346‘)   
 CREATE INDEX ix_QQNum_Group346 On GroupData4_Data.dbo.Group346 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group347‘)   
 CREATE INDEX ix_QQNum_Group347 On GroupData4_Data.dbo.Group347 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group348‘)   
 CREATE INDEX ix_QQNum_Group348 On GroupData4_Data.dbo.Group348 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group349‘)   
 CREATE INDEX ix_QQNum_Group349 On GroupData4_Data.dbo.Group349 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group350‘)   
 CREATE INDEX ix_QQNum_Group350 On GroupData4_Data.dbo.Group350 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group351‘)   
 CREATE INDEX ix_QQNum_Group351 On GroupData4_Data.dbo.Group351 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group352‘)   
 CREATE INDEX ix_QQNum_Group352 On GroupData4_Data.dbo.Group352 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group353‘)   
 CREATE INDEX ix_QQNum_Group353 On GroupData4_Data.dbo.Group353 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group354‘)   
 CREATE INDEX ix_QQNum_Group354 On GroupData4_Data.dbo.Group354 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group355‘)   
 CREATE INDEX ix_QQNum_Group355 On GroupData4_Data.dbo.Group355 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group356‘)   
 CREATE INDEX ix_QQNum_Group356 On GroupData4_Data.dbo.Group356 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group357‘)   
 CREATE INDEX ix_QQNum_Group357 On GroupData4_Data.dbo.Group357 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group358‘)   
 CREATE INDEX ix_QQNum_Group358 On GroupData4_Data.dbo.Group358 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group359‘)   
 CREATE INDEX ix_QQNum_Group359 On GroupData4_Data.dbo.Group359 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group360‘)   
 CREATE INDEX ix_QQNum_Group360 On GroupData4_Data.dbo.Group360 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group361‘)   
 CREATE INDEX ix_QQNum_Group361 On GroupData4_Data.dbo.Group361 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group362‘)   
 CREATE INDEX ix_QQNum_Group362 On GroupData4_Data.dbo.Group362 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group363‘)   
 CREATE INDEX ix_QQNum_Group363 On GroupData4_Data.dbo.Group363 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group364‘)   
 CREATE INDEX ix_QQNum_Group364 On GroupData4_Data.dbo.Group364 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group365‘)   
 CREATE INDEX ix_QQNum_Group365 On GroupData4_Data.dbo.Group365 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group366‘)   
 CREATE INDEX ix_QQNum_Group366 On GroupData4_Data.dbo.Group366 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group367‘)   
 CREATE INDEX ix_QQNum_Group367 On GroupData4_Data.dbo.Group367 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group368‘)   
 CREATE INDEX ix_QQNum_Group368 On GroupData4_Data.dbo.Group368 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group301‘)   
 CREATE INDEX ix_QQNum_Group301 On GroupData4_Data.dbo.Group301 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group369‘)   
 CREATE INDEX ix_QQNum_Group369 On GroupData4_Data.dbo.Group369 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group302‘)   
 CREATE INDEX ix_QQNum_Group302 On GroupData4_Data.dbo.Group302 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group370‘)   
 CREATE INDEX ix_QQNum_Group370 On GroupData4_Data.dbo.Group370 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group303‘)   
 CREATE INDEX ix_QQNum_Group303 On GroupData4_Data.dbo.Group303 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group371‘)   
 CREATE INDEX ix_QQNum_Group371 On GroupData4_Data.dbo.Group371 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group304‘)   
 CREATE INDEX ix_QQNum_Group304 On GroupData4_Data.dbo.Group304 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group372‘)   
 CREATE INDEX ix_QQNum_Group372 On GroupData4_Data.dbo.Group372 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group305‘)   
 CREATE INDEX ix_QQNum_Group305 On GroupData4_Data.dbo.Group305 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group373‘)   
 CREATE INDEX ix_QQNum_Group373 On GroupData4_Data.dbo.Group373 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData4_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group306‘)   
 CREATE INDEX ix_QQNum_Group306 On GroupData4_Data.dbo.Group306 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group474‘)   
 CREATE INDEX ix_QQNum_Group474 On GroupData5_Data.dbo.Group474 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group407‘)   
 CREATE INDEX ix_QQNum_Group407 On GroupData5_Data.dbo.Group407 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group475‘)   
 CREATE INDEX ix_QQNum_Group475 On GroupData5_Data.dbo.Group475 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group408‘)   
 CREATE INDEX ix_QQNum_Group408 On GroupData5_Data.dbo.Group408 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group476‘)   
 CREATE INDEX ix_QQNum_Group476 On GroupData5_Data.dbo.Group476 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group409‘)   
 CREATE INDEX ix_QQNum_Group409 On GroupData5_Data.dbo.Group409 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group477‘)   
 CREATE INDEX ix_QQNum_Group477 On GroupData5_Data.dbo.Group477 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group410‘)   
 CREATE INDEX ix_QQNum_Group410 On GroupData5_Data.dbo.Group410 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group478‘)   
 CREATE INDEX ix_QQNum_Group478 On GroupData5_Data.dbo.Group478 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group411‘)   
 CREATE INDEX ix_QQNum_Group411 On GroupData5_Data.dbo.Group411 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group479‘)   
 CREATE INDEX ix_QQNum_Group479 On GroupData5_Data.dbo.Group479 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group412‘)   
 CREATE INDEX ix_QQNum_Group412 On GroupData5_Data.dbo.Group412 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group480‘)   
 CREATE INDEX ix_QQNum_Group480 On GroupData5_Data.dbo.Group480 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group413‘)   
 CREATE INDEX ix_QQNum_Group413 On GroupData5_Data.dbo.Group413 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group481‘)   
 CREATE INDEX ix_QQNum_Group481 On GroupData5_Data.dbo.Group481 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group414‘)   
 CREATE INDEX ix_QQNum_Group414 On GroupData5_Data.dbo.Group414 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group482‘)   
 CREATE INDEX ix_QQNum_Group482 On GroupData5_Data.dbo.Group482 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group415‘)   
 CREATE INDEX ix_QQNum_Group415 On GroupData5_Data.dbo.Group415 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group483‘)   
 CREATE INDEX ix_QQNum_Group483 On GroupData5_Data.dbo.Group483 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group416‘)   
 CREATE INDEX ix_QQNum_Group416 On GroupData5_Data.dbo.Group416 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group484‘)   
 CREATE INDEX ix_QQNum_Group484 On GroupData5_Data.dbo.Group484 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group417‘)   
 CREATE INDEX ix_QQNum_Group417 On GroupData5_Data.dbo.Group417 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group485‘)   
 CREATE INDEX ix_QQNum_Group485 On GroupData5_Data.dbo.Group485 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group418‘)   
 CREATE INDEX ix_QQNum_Group418 On GroupData5_Data.dbo.Group418 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group486‘)   
 CREATE INDEX ix_QQNum_Group486 On GroupData5_Data.dbo.Group486 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group419‘)   
 CREATE INDEX ix_QQNum_Group419 On GroupData5_Data.dbo.Group419 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group487‘)   
 CREATE INDEX ix_QQNum_Group487 On GroupData5_Data.dbo.Group487 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group420‘)   
 CREATE INDEX ix_QQNum_Group420 On GroupData5_Data.dbo.Group420 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group488‘)   
 CREATE INDEX ix_QQNum_Group488 On GroupData5_Data.dbo.Group488 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group421‘)   
 CREATE INDEX ix_QQNum_Group421 On GroupData5_Data.dbo.Group421 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group489‘)   
 CREATE INDEX ix_QQNum_Group489 On GroupData5_Data.dbo.Group489 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group422‘)   
 CREATE INDEX ix_QQNum_Group422 On GroupData5_Data.dbo.Group422 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group490‘)   
 CREATE INDEX ix_QQNum_Group490 On GroupData5_Data.dbo.Group490 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group423‘)   
 CREATE INDEX ix_QQNum_Group423 On GroupData5_Data.dbo.Group423 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group491‘)   
 CREATE INDEX ix_QQNum_Group491 On GroupData5_Data.dbo.Group491 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group424‘)   
 CREATE INDEX ix_QQNum_Group424 On GroupData5_Data.dbo.Group424 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group492‘)   
 CREATE INDEX ix_QQNum_Group492 On GroupData5_Data.dbo.Group492 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group425‘)   
 CREATE INDEX ix_QQNum_Group425 On GroupData5_Data.dbo.Group425 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group493‘)   
 CREATE INDEX ix_QQNum_Group493 On GroupData5_Data.dbo.Group493 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group426‘)   
 CREATE INDEX ix_QQNum_Group426 On GroupData5_Data.dbo.Group426 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group494‘)   
 CREATE INDEX ix_QQNum_Group494 On GroupData5_Data.dbo.Group494 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group427‘)   
 CREATE INDEX ix_QQNum_Group427 On GroupData5_Data.dbo.Group427 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group495‘)   
 CREATE INDEX ix_QQNum_Group495 On GroupData5_Data.dbo.Group495 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group428‘)   
 CREATE INDEX ix_QQNum_Group428 On GroupData5_Data.dbo.Group428 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group496‘)   
 CREATE INDEX ix_QQNum_Group496 On GroupData5_Data.dbo.Group496 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group429‘)   
 CREATE INDEX ix_QQNum_Group429 On GroupData5_Data.dbo.Group429 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group497‘)   
 CREATE INDEX ix_QQNum_Group497 On GroupData5_Data.dbo.Group497 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group430‘)   
 CREATE INDEX ix_QQNum_Group430 On GroupData5_Data.dbo.Group430 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group498‘)   
 CREATE INDEX ix_QQNum_Group498 On GroupData5_Data.dbo.Group498 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group431‘)   
 CREATE INDEX ix_QQNum_Group431 On GroupData5_Data.dbo.Group431 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group499‘)   
 CREATE INDEX ix_QQNum_Group499 On GroupData5_Data.dbo.Group499 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group432‘)   
 CREATE INDEX ix_QQNum_Group432 On GroupData5_Data.dbo.Group432 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group500‘)   
 CREATE INDEX ix_QQNum_Group500 On GroupData5_Data.dbo.Group500 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group433‘)   
 CREATE INDEX ix_QQNum_Group433 On GroupData5_Data.dbo.Group433 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group434‘)   
 CREATE INDEX ix_QQNum_Group434 On GroupData5_Data.dbo.Group434 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group435‘)   
 CREATE INDEX ix_QQNum_Group435 On GroupData5_Data.dbo.Group435 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group436‘)   
 CREATE INDEX ix_QQNum_Group436 On GroupData5_Data.dbo.Group436 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group437‘)   
 CREATE INDEX ix_QQNum_Group437 On GroupData5_Data.dbo.Group437 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group438‘)   
 CREATE INDEX ix_QQNum_Group438 On GroupData5_Data.dbo.Group438 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group439‘)   
 CREATE INDEX ix_QQNum_Group439 On GroupData5_Data.dbo.Group439 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group440‘)   
 CREATE INDEX ix_QQNum_Group440 On GroupData5_Data.dbo.Group440 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group441‘)   
 CREATE INDEX ix_QQNum_Group441 On GroupData5_Data.dbo.Group441 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group442‘)   
 CREATE INDEX ix_QQNum_Group442 On GroupData5_Data.dbo.Group442 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group443‘)   
 CREATE INDEX ix_QQNum_Group443 On GroupData5_Data.dbo.Group443 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group444‘)   
 CREATE INDEX ix_QQNum_Group444 On GroupData5_Data.dbo.Group444 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group445‘)   
 CREATE INDEX ix_QQNum_Group445 On GroupData5_Data.dbo.Group445 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group446‘)   
 CREATE INDEX ix_QQNum_Group446 On GroupData5_Data.dbo.Group446 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group447‘)   
 CREATE INDEX ix_QQNum_Group447 On GroupData5_Data.dbo.Group447 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group448‘)   
 CREATE INDEX ix_QQNum_Group448 On GroupData5_Data.dbo.Group448 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group449‘)   
 CREATE INDEX ix_QQNum_Group449 On GroupData5_Data.dbo.Group449 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group450‘)   
 CREATE INDEX ix_QQNum_Group450 On GroupData5_Data.dbo.Group450 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group451‘)   
 CREATE INDEX ix_QQNum_Group451 On GroupData5_Data.dbo.Group451 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group452‘)   
 CREATE INDEX ix_QQNum_Group452 On GroupData5_Data.dbo.Group452 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group453‘)   
 CREATE INDEX ix_QQNum_Group453 On GroupData5_Data.dbo.Group453 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group454‘)   
 CREATE INDEX ix_QQNum_Group454 On GroupData5_Data.dbo.Group454 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group455‘)   
 CREATE INDEX ix_QQNum_Group455 On GroupData5_Data.dbo.Group455 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group456‘)   
 CREATE INDEX ix_QQNum_Group456 On GroupData5_Data.dbo.Group456 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group457‘)   
 CREATE INDEX ix_QQNum_Group457 On GroupData5_Data.dbo.Group457 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group458‘)   
 CREATE INDEX ix_QQNum_Group458 On GroupData5_Data.dbo.Group458 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group459‘)   
 CREATE INDEX ix_QQNum_Group459 On GroupData5_Data.dbo.Group459 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group460‘)   
 CREATE INDEX ix_QQNum_Group460 On GroupData5_Data.dbo.Group460 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group461‘)   
 CREATE INDEX ix_QQNum_Group461 On GroupData5_Data.dbo.Group461 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group462‘)   
 CREATE INDEX ix_QQNum_Group462 On GroupData5_Data.dbo.Group462 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group463‘)   
 CREATE INDEX ix_QQNum_Group463 On GroupData5_Data.dbo.Group463 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group464‘)   
 CREATE INDEX ix_QQNum_Group464 On GroupData5_Data.dbo.Group464 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group465‘)   
 CREATE INDEX ix_QQNum_Group465 On GroupData5_Data.dbo.Group465 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group466‘)   
 CREATE INDEX ix_QQNum_Group466 On GroupData5_Data.dbo.Group466 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group467‘)   
 CREATE INDEX ix_QQNum_Group467 On GroupData5_Data.dbo.Group467 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group468‘)   
 CREATE INDEX ix_QQNum_Group468 On GroupData5_Data.dbo.Group468 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group401‘)   
 CREATE INDEX ix_QQNum_Group401 On GroupData5_Data.dbo.Group401 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group469‘)   
 CREATE INDEX ix_QQNum_Group469 On GroupData5_Data.dbo.Group469 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group402‘)   
 CREATE INDEX ix_QQNum_Group402 On GroupData5_Data.dbo.Group402 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group470‘)   
 CREATE INDEX ix_QQNum_Group470 On GroupData5_Data.dbo.Group470 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group403‘)   
 CREATE INDEX ix_QQNum_Group403 On GroupData5_Data.dbo.Group403 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group471‘)   
 CREATE INDEX ix_QQNum_Group471 On GroupData5_Data.dbo.Group471 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group404‘)   
 CREATE INDEX ix_QQNum_Group404 On GroupData5_Data.dbo.Group404 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group472‘)   
 CREATE INDEX ix_QQNum_Group472 On GroupData5_Data.dbo.Group472 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group405‘)   
 CREATE INDEX ix_QQNum_Group405 On GroupData5_Data.dbo.Group405 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group473‘)   
 CREATE INDEX ix_QQNum_Group473 On GroupData5_Data.dbo.Group473 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData5_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group406‘)   
 CREATE INDEX ix_QQNum_Group406 On GroupData5_Data.dbo.Group406 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group574‘)   
 CREATE INDEX ix_QQNum_Group574 On GroupData6_Data.dbo.Group574 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group507‘)   
 CREATE INDEX ix_QQNum_Group507 On GroupData6_Data.dbo.Group507 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group575‘)   
 CREATE INDEX ix_QQNum_Group575 On GroupData6_Data.dbo.Group575 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group508‘)   
 CREATE INDEX ix_QQNum_Group508 On GroupData6_Data.dbo.Group508 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group576‘)   
 CREATE INDEX ix_QQNum_Group576 On GroupData6_Data.dbo.Group576 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group509‘)   
 CREATE INDEX ix_QQNum_Group509 On GroupData6_Data.dbo.Group509 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group577‘)   
 CREATE INDEX ix_QQNum_Group577 On GroupData6_Data.dbo.Group577 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group510‘)   
 CREATE INDEX ix_QQNum_Group510 On GroupData6_Data.dbo.Group510 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group578‘)   
 CREATE INDEX ix_QQNum_Group578 On GroupData6_Data.dbo.Group578 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group511‘)   
 CREATE INDEX ix_QQNum_Group511 On GroupData6_Data.dbo.Group511 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group579‘)   
 CREATE INDEX ix_QQNum_Group579 On GroupData6_Data.dbo.Group579 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group512‘)   
 CREATE INDEX ix_QQNum_Group512 On GroupData6_Data.dbo.Group512 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group580‘)   
 CREATE INDEX ix_QQNum_Group580 On GroupData6_Data.dbo.Group580 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group513‘)   
 CREATE INDEX ix_QQNum_Group513 On GroupData6_Data.dbo.Group513 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group581‘)   
 CREATE INDEX ix_QQNum_Group581 On GroupData6_Data.dbo.Group581 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group514‘)   
 CREATE INDEX ix_QQNum_Group514 On GroupData6_Data.dbo.Group514 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group582‘)   
 CREATE INDEX ix_QQNum_Group582 On GroupData6_Data.dbo.Group582 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group515‘)   
 CREATE INDEX ix_QQNum_Group515 On GroupData6_Data.dbo.Group515 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group583‘)   
 CREATE INDEX ix_QQNum_Group583 On GroupData6_Data.dbo.Group583 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group516‘)   
 CREATE INDEX ix_QQNum_Group516 On GroupData6_Data.dbo.Group516 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group584‘)   
 CREATE INDEX ix_QQNum_Group584 On GroupData6_Data.dbo.Group584 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group517‘)   
 CREATE INDEX ix_QQNum_Group517 On GroupData6_Data.dbo.Group517 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group585‘)   
 CREATE INDEX ix_QQNum_Group585 On GroupData6_Data.dbo.Group585 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group518‘)   
 CREATE INDEX ix_QQNum_Group518 On GroupData6_Data.dbo.Group518 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group586‘)   
 CREATE INDEX ix_QQNum_Group586 On GroupData6_Data.dbo.Group586 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group519‘)   
 CREATE INDEX ix_QQNum_Group519 On GroupData6_Data.dbo.Group519 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group587‘)   
 CREATE INDEX ix_QQNum_Group587 On GroupData6_Data.dbo.Group587 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group520‘)   
 CREATE INDEX ix_QQNum_Group520 On GroupData6_Data.dbo.Group520 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group588‘)   
 CREATE INDEX ix_QQNum_Group588 On GroupData6_Data.dbo.Group588 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group521‘)   
 CREATE INDEX ix_QQNum_Group521 On GroupData6_Data.dbo.Group521 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group589‘)   
 CREATE INDEX ix_QQNum_Group589 On GroupData6_Data.dbo.Group589 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group522‘)   
 CREATE INDEX ix_QQNum_Group522 On GroupData6_Data.dbo.Group522 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group590‘)   
 CREATE INDEX ix_QQNum_Group590 On GroupData6_Data.dbo.Group590 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group523‘)   
 CREATE INDEX ix_QQNum_Group523 On GroupData6_Data.dbo.Group523 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group591‘)   
 CREATE INDEX ix_QQNum_Group591 On GroupData6_Data.dbo.Group591 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group524‘)   
 CREATE INDEX ix_QQNum_Group524 On GroupData6_Data.dbo.Group524 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group592‘)   
 CREATE INDEX ix_QQNum_Group592 On GroupData6_Data.dbo.Group592 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group525‘)   
 CREATE INDEX ix_QQNum_Group525 On GroupData6_Data.dbo.Group525 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group593‘)   
 CREATE INDEX ix_QQNum_Group593 On GroupData6_Data.dbo.Group593 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group526‘)   
 CREATE INDEX ix_QQNum_Group526 On GroupData6_Data.dbo.Group526 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group594‘)   
 CREATE INDEX ix_QQNum_Group594 On GroupData6_Data.dbo.Group594 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group527‘)   
 CREATE INDEX ix_QQNum_Group527 On GroupData6_Data.dbo.Group527 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group595‘)   
 CREATE INDEX ix_QQNum_Group595 On GroupData6_Data.dbo.Group595 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group528‘)   
 CREATE INDEX ix_QQNum_Group528 On GroupData6_Data.dbo.Group528 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group596‘)   
 CREATE INDEX ix_QQNum_Group596 On GroupData6_Data.dbo.Group596 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group529‘)   
 CREATE INDEX ix_QQNum_Group529 On GroupData6_Data.dbo.Group529 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group597‘)   
 CREATE INDEX ix_QQNum_Group597 On GroupData6_Data.dbo.Group597 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group530‘)   
 CREATE INDEX ix_QQNum_Group530 On GroupData6_Data.dbo.Group530 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group598‘)   
 CREATE INDEX ix_QQNum_Group598 On GroupData6_Data.dbo.Group598 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group531‘)   
 CREATE INDEX ix_QQNum_Group531 On GroupData6_Data.dbo.Group531 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group599‘)   
 CREATE INDEX ix_QQNum_Group599 On GroupData6_Data.dbo.Group599 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group532‘)   
 CREATE INDEX ix_QQNum_Group532 On GroupData6_Data.dbo.Group532 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group600‘)   
 CREATE INDEX ix_QQNum_Group600 On GroupData6_Data.dbo.Group600 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group533‘)   
 CREATE INDEX ix_QQNum_Group533 On GroupData6_Data.dbo.Group533 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group534‘)   
 CREATE INDEX ix_QQNum_Group534 On GroupData6_Data.dbo.Group534 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group535‘)   
 CREATE INDEX ix_QQNum_Group535 On GroupData6_Data.dbo.Group535 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group536‘)   
 CREATE INDEX ix_QQNum_Group536 On GroupData6_Data.dbo.Group536 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group537‘)   
 CREATE INDEX ix_QQNum_Group537 On GroupData6_Data.dbo.Group537 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group538‘)   
 CREATE INDEX ix_QQNum_Group538 On GroupData6_Data.dbo.Group538 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group539‘)   
 CREATE INDEX ix_QQNum_Group539 On GroupData6_Data.dbo.Group539 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group540‘)   
 CREATE INDEX ix_QQNum_Group540 On GroupData6_Data.dbo.Group540 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group541‘)   
 CREATE INDEX ix_QQNum_Group541 On GroupData6_Data.dbo.Group541 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group542‘)   
 CREATE INDEX ix_QQNum_Group542 On GroupData6_Data.dbo.Group542 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group543‘)   
 CREATE INDEX ix_QQNum_Group543 On GroupData6_Data.dbo.Group543 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group544‘)   
 CREATE INDEX ix_QQNum_Group544 On GroupData6_Data.dbo.Group544 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group545‘)   
 CREATE INDEX ix_QQNum_Group545 On GroupData6_Data.dbo.Group545 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group546‘)   
 CREATE INDEX ix_QQNum_Group546 On GroupData6_Data.dbo.Group546 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group547‘)   
 CREATE INDEX ix_QQNum_Group547 On GroupData6_Data.dbo.Group547 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group548‘)   
 CREATE INDEX ix_QQNum_Group548 On GroupData6_Data.dbo.Group548 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group549‘)   
 CREATE INDEX ix_QQNum_Group549 On GroupData6_Data.dbo.Group549 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group550‘)   
 CREATE INDEX ix_QQNum_Group550 On GroupData6_Data.dbo.Group550 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group551‘)   
 CREATE INDEX ix_QQNum_Group551 On GroupData6_Data.dbo.Group551 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group552‘)   
 CREATE INDEX ix_QQNum_Group552 On GroupData6_Data.dbo.Group552 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group553‘)   
 CREATE INDEX ix_QQNum_Group553 On GroupData6_Data.dbo.Group553 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group554‘)   
 CREATE INDEX ix_QQNum_Group554 On GroupData6_Data.dbo.Group554 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group555‘)   
 CREATE INDEX ix_QQNum_Group555 On GroupData6_Data.dbo.Group555 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group556‘)   
 CREATE INDEX ix_QQNum_Group556 On GroupData6_Data.dbo.Group556 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group557‘)   
 CREATE INDEX ix_QQNum_Group557 On GroupData6_Data.dbo.Group557 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group558‘)   
 CREATE INDEX ix_QQNum_Group558 On GroupData6_Data.dbo.Group558 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group559‘)   
 CREATE INDEX ix_QQNum_Group559 On GroupData6_Data.dbo.Group559 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group560‘)   
 CREATE INDEX ix_QQNum_Group560 On GroupData6_Data.dbo.Group560 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group561‘)   
 CREATE INDEX ix_QQNum_Group561 On GroupData6_Data.dbo.Group561 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group562‘)   
 CREATE INDEX ix_QQNum_Group562 On GroupData6_Data.dbo.Group562 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group563‘)   
 CREATE INDEX ix_QQNum_Group563 On GroupData6_Data.dbo.Group563 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group564‘)   
 CREATE INDEX ix_QQNum_Group564 On GroupData6_Data.dbo.Group564 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group565‘)   
 CREATE INDEX ix_QQNum_Group565 On GroupData6_Data.dbo.Group565 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group566‘)   
 CREATE INDEX ix_QQNum_Group566 On GroupData6_Data.dbo.Group566 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group567‘)   
 CREATE INDEX ix_QQNum_Group567 On GroupData6_Data.dbo.Group567 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group568‘)   
 CREATE INDEX ix_QQNum_Group568 On GroupData6_Data.dbo.Group568 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group501‘)   
 CREATE INDEX ix_QQNum_Group501 On GroupData6_Data.dbo.Group501 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group569‘)   
 CREATE INDEX ix_QQNum_Group569 On GroupData6_Data.dbo.Group569 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group502‘)   
 CREATE INDEX ix_QQNum_Group502 On GroupData6_Data.dbo.Group502 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group570‘)   
 CREATE INDEX ix_QQNum_Group570 On GroupData6_Data.dbo.Group570 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group503‘)   
 CREATE INDEX ix_QQNum_Group503 On GroupData6_Data.dbo.Group503 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group571‘)   
 CREATE INDEX ix_QQNum_Group571 On GroupData6_Data.dbo.Group571 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group504‘)   
 CREATE INDEX ix_QQNum_Group504 On GroupData6_Data.dbo.Group504 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group572‘)   
 CREATE INDEX ix_QQNum_Group572 On GroupData6_Data.dbo.Group572 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group505‘)   
 CREATE INDEX ix_QQNum_Group505 On GroupData6_Data.dbo.Group505 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group573‘)   
 CREATE INDEX ix_QQNum_Group573 On GroupData6_Data.dbo.Group573 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData6_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group506‘)   
 CREATE INDEX ix_QQNum_Group506 On GroupData6_Data.dbo.Group506 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group674‘)   
 CREATE INDEX ix_QQNum_Group674 On GroupData7_Data.dbo.Group674 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group607‘)   
 CREATE INDEX ix_QQNum_Group607 On GroupData7_Data.dbo.Group607 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group675‘)   
 CREATE INDEX ix_QQNum_Group675 On GroupData7_Data.dbo.Group675 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group608‘)   
 CREATE INDEX ix_QQNum_Group608 On GroupData7_Data.dbo.Group608 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group676‘)   
 CREATE INDEX ix_QQNum_Group676 On GroupData7_Data.dbo.Group676 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group609‘)   
 CREATE INDEX ix_QQNum_Group609 On GroupData7_Data.dbo.Group609 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group677‘)   
 CREATE INDEX ix_QQNum_Group677 On GroupData7_Data.dbo.Group677 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group610‘)   
 CREATE INDEX ix_QQNum_Group610 On GroupData7_Data.dbo.Group610 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group678‘)   
 CREATE INDEX ix_QQNum_Group678 On GroupData7_Data.dbo.Group678 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group611‘)   
 CREATE INDEX ix_QQNum_Group611 On GroupData7_Data.dbo.Group611 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group679‘)   
 CREATE INDEX ix_QQNum_Group679 On GroupData7_Data.dbo.Group679 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group612‘)   
 CREATE INDEX ix_QQNum_Group612 On GroupData7_Data.dbo.Group612 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group680‘)   
 CREATE INDEX ix_QQNum_Group680 On GroupData7_Data.dbo.Group680 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group613‘)   
 CREATE INDEX ix_QQNum_Group613 On GroupData7_Data.dbo.Group613 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group681‘)   
 CREATE INDEX ix_QQNum_Group681 On GroupData7_Data.dbo.Group681 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group614‘)   
 CREATE INDEX ix_QQNum_Group614 On GroupData7_Data.dbo.Group614 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group682‘)   
 CREATE INDEX ix_QQNum_Group682 On GroupData7_Data.dbo.Group682 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group615‘)   
 CREATE INDEX ix_QQNum_Group615 On GroupData7_Data.dbo.Group615 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group683‘)   
 CREATE INDEX ix_QQNum_Group683 On GroupData7_Data.dbo.Group683 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group616‘)   
 CREATE INDEX ix_QQNum_Group616 On GroupData7_Data.dbo.Group616 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group684‘)   
 CREATE INDEX ix_QQNum_Group684 On GroupData7_Data.dbo.Group684 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group617‘)   
 CREATE INDEX ix_QQNum_Group617 On GroupData7_Data.dbo.Group617 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group685‘)   
 CREATE INDEX ix_QQNum_Group685 On GroupData7_Data.dbo.Group685 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group618‘)   
 CREATE INDEX ix_QQNum_Group618 On GroupData7_Data.dbo.Group618 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group686‘)   
 CREATE INDEX ix_QQNum_Group686 On GroupData7_Data.dbo.Group686 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group619‘)   
 CREATE INDEX ix_QQNum_Group619 On GroupData7_Data.dbo.Group619 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group687‘)   
 CREATE INDEX ix_QQNum_Group687 On GroupData7_Data.dbo.Group687 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group620‘)   
 CREATE INDEX ix_QQNum_Group620 On GroupData7_Data.dbo.Group620 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group688‘)   
 CREATE INDEX ix_QQNum_Group688 On GroupData7_Data.dbo.Group688 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group621‘)   
 CREATE INDEX ix_QQNum_Group621 On GroupData7_Data.dbo.Group621 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group689‘)   
 CREATE INDEX ix_QQNum_Group689 On GroupData7_Data.dbo.Group689 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group622‘)   
 CREATE INDEX ix_QQNum_Group622 On GroupData7_Data.dbo.Group622 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group690‘)   
 CREATE INDEX ix_QQNum_Group690 On GroupData7_Data.dbo.Group690 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group623‘)   
 CREATE INDEX ix_QQNum_Group623 On GroupData7_Data.dbo.Group623 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group691‘)   
 CREATE INDEX ix_QQNum_Group691 On GroupData7_Data.dbo.Group691 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group624‘)   
 CREATE INDEX ix_QQNum_Group624 On GroupData7_Data.dbo.Group624 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group692‘)   
 CREATE INDEX ix_QQNum_Group692 On GroupData7_Data.dbo.Group692 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group625‘)   
 CREATE INDEX ix_QQNum_Group625 On GroupData7_Data.dbo.Group625 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group693‘)   
 CREATE INDEX ix_QQNum_Group693 On GroupData7_Data.dbo.Group693 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group626‘)   
 CREATE INDEX ix_QQNum_Group626 On GroupData7_Data.dbo.Group626 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group694‘)   
 CREATE INDEX ix_QQNum_Group694 On GroupData7_Data.dbo.Group694 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group627‘)   
 CREATE INDEX ix_QQNum_Group627 On GroupData7_Data.dbo.Group627 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group695‘)   
 CREATE INDEX ix_QQNum_Group695 On GroupData7_Data.dbo.Group695 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group628‘)   
 CREATE INDEX ix_QQNum_Group628 On GroupData7_Data.dbo.Group628 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group696‘)   
 CREATE INDEX ix_QQNum_Group696 On GroupData7_Data.dbo.Group696 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group629‘)   
 CREATE INDEX ix_QQNum_Group629 On GroupData7_Data.dbo.Group629 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group697‘)   
 CREATE INDEX ix_QQNum_Group697 On GroupData7_Data.dbo.Group697 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group630‘)   
 CREATE INDEX ix_QQNum_Group630 On GroupData7_Data.dbo.Group630 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group698‘)   
 CREATE INDEX ix_QQNum_Group698 On GroupData7_Data.dbo.Group698 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group631‘)   
 CREATE INDEX ix_QQNum_Group631 On GroupData7_Data.dbo.Group631 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group699‘)   
 CREATE INDEX ix_QQNum_Group699 On GroupData7_Data.dbo.Group699 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group632‘)   
 CREATE INDEX ix_QQNum_Group632 On GroupData7_Data.dbo.Group632 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group700‘)   
 CREATE INDEX ix_QQNum_Group700 On GroupData7_Data.dbo.Group700 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group633‘)   
 CREATE INDEX ix_QQNum_Group633 On GroupData7_Data.dbo.Group633 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group634‘)   
 CREATE INDEX ix_QQNum_Group634 On GroupData7_Data.dbo.Group634 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group635‘)   
 CREATE INDEX ix_QQNum_Group635 On GroupData7_Data.dbo.Group635 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group636‘)   
 CREATE INDEX ix_QQNum_Group636 On GroupData7_Data.dbo.Group636 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group637‘)   
 CREATE INDEX ix_QQNum_Group637 On GroupData7_Data.dbo.Group637 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group638‘)   
 CREATE INDEX ix_QQNum_Group638 On GroupData7_Data.dbo.Group638 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group639‘)   
 CREATE INDEX ix_QQNum_Group639 On GroupData7_Data.dbo.Group639 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group640‘)   
 CREATE INDEX ix_QQNum_Group640 On GroupData7_Data.dbo.Group640 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group641‘)   
 CREATE INDEX ix_QQNum_Group641 On GroupData7_Data.dbo.Group641 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group642‘)   
 CREATE INDEX ix_QQNum_Group642 On GroupData7_Data.dbo.Group642 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group643‘)   
 CREATE INDEX ix_QQNum_Group643 On GroupData7_Data.dbo.Group643 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group644‘)   
 CREATE INDEX ix_QQNum_Group644 On GroupData7_Data.dbo.Group644 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group645‘)   
 CREATE INDEX ix_QQNum_Group645 On GroupData7_Data.dbo.Group645 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group646‘)   
 CREATE INDEX ix_QQNum_Group646 On GroupData7_Data.dbo.Group646 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group647‘)   
 CREATE INDEX ix_QQNum_Group647 On GroupData7_Data.dbo.Group647 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group648‘)   
 CREATE INDEX ix_QQNum_Group648 On GroupData7_Data.dbo.Group648 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group649‘)   
 CREATE INDEX ix_QQNum_Group649 On GroupData7_Data.dbo.Group649 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group650‘)   
 CREATE INDEX ix_QQNum_Group650 On GroupData7_Data.dbo.Group650 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group651‘)   
 CREATE INDEX ix_QQNum_Group651 On GroupData7_Data.dbo.Group651 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group652‘)   
 CREATE INDEX ix_QQNum_Group652 On GroupData7_Data.dbo.Group652 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group653‘)   
 CREATE INDEX ix_QQNum_Group653 On GroupData7_Data.dbo.Group653 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group654‘)   
 CREATE INDEX ix_QQNum_Group654 On GroupData7_Data.dbo.Group654 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group655‘)   
 CREATE INDEX ix_QQNum_Group655 On GroupData7_Data.dbo.Group655 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group656‘)   
 CREATE INDEX ix_QQNum_Group656 On GroupData7_Data.dbo.Group656 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group657‘)   
 CREATE INDEX ix_QQNum_Group657 On GroupData7_Data.dbo.Group657 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group658‘)   
 CREATE INDEX ix_QQNum_Group658 On GroupData7_Data.dbo.Group658 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group659‘)   
 CREATE INDEX ix_QQNum_Group659 On GroupData7_Data.dbo.Group659 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group660‘)   
 CREATE INDEX ix_QQNum_Group660 On GroupData7_Data.dbo.Group660 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group661‘)   
 CREATE INDEX ix_QQNum_Group661 On GroupData7_Data.dbo.Group661 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group662‘)   
 CREATE INDEX ix_QQNum_Group662 On GroupData7_Data.dbo.Group662 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group663‘)   
 CREATE INDEX ix_QQNum_Group663 On GroupData7_Data.dbo.Group663 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group664‘)   
 CREATE INDEX ix_QQNum_Group664 On GroupData7_Data.dbo.Group664 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group665‘)   
 CREATE INDEX ix_QQNum_Group665 On GroupData7_Data.dbo.Group665 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group666‘)   
 CREATE INDEX ix_QQNum_Group666 On GroupData7_Data.dbo.Group666 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group667‘)   
 CREATE INDEX ix_QQNum_Group667 On GroupData7_Data.dbo.Group667 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group668‘)   
 CREATE INDEX ix_QQNum_Group668 On GroupData7_Data.dbo.Group668 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group601‘)   
 CREATE INDEX ix_QQNum_Group601 On GroupData7_Data.dbo.Group601 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group669‘)   
 CREATE INDEX ix_QQNum_Group669 On GroupData7_Data.dbo.Group669 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group602‘)   
 CREATE INDEX ix_QQNum_Group602 On GroupData7_Data.dbo.Group602 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group670‘)   
 CREATE INDEX ix_QQNum_Group670 On GroupData7_Data.dbo.Group670 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group603‘)   
 CREATE INDEX ix_QQNum_Group603 On GroupData7_Data.dbo.Group603 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group671‘)   
 CREATE INDEX ix_QQNum_Group671 On GroupData7_Data.dbo.Group671 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group604‘)   
 CREATE INDEX ix_QQNum_Group604 On GroupData7_Data.dbo.Group604 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group672‘)   
 CREATE INDEX ix_QQNum_Group672 On GroupData7_Data.dbo.Group672 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group605‘)   
 CREATE INDEX ix_QQNum_Group605 On GroupData7_Data.dbo.Group605 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group673‘)   
 CREATE INDEX ix_QQNum_Group673 On GroupData7_Data.dbo.Group673 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData7_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group606‘)   
 CREATE INDEX ix_QQNum_Group606 On GroupData7_Data.dbo.Group606 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group774‘)   
 CREATE INDEX ix_QQNum_Group774 On GroupData8_Data.dbo.Group774 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group707‘)   
 CREATE INDEX ix_QQNum_Group707 On GroupData8_Data.dbo.Group707 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group775‘)   
 CREATE INDEX ix_QQNum_Group775 On GroupData8_Data.dbo.Group775 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group708‘)   
 CREATE INDEX ix_QQNum_Group708 On GroupData8_Data.dbo.Group708 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group776‘)   
 CREATE INDEX ix_QQNum_Group776 On GroupData8_Data.dbo.Group776 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group709‘)   
 CREATE INDEX ix_QQNum_Group709 On GroupData8_Data.dbo.Group709 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group777‘)   
 CREATE INDEX ix_QQNum_Group777 On GroupData8_Data.dbo.Group777 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group710‘)   
 CREATE INDEX ix_QQNum_Group710 On GroupData8_Data.dbo.Group710 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group778‘)   
 CREATE INDEX ix_QQNum_Group778 On GroupData8_Data.dbo.Group778 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group711‘)   
 CREATE INDEX ix_QQNum_Group711 On GroupData8_Data.dbo.Group711 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group779‘)   
 CREATE INDEX ix_QQNum_Group779 On GroupData8_Data.dbo.Group779 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group712‘)   
 CREATE INDEX ix_QQNum_Group712 On GroupData8_Data.dbo.Group712 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group780‘)   
 CREATE INDEX ix_QQNum_Group780 On GroupData8_Data.dbo.Group780 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group713‘)   
 CREATE INDEX ix_QQNum_Group713 On GroupData8_Data.dbo.Group713 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group781‘)   
 CREATE INDEX ix_QQNum_Group781 On GroupData8_Data.dbo.Group781 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group714‘)   
 CREATE INDEX ix_QQNum_Group714 On GroupData8_Data.dbo.Group714 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group782‘)   
 CREATE INDEX ix_QQNum_Group782 On GroupData8_Data.dbo.Group782 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group715‘)   
 CREATE INDEX ix_QQNum_Group715 On GroupData8_Data.dbo.Group715 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group783‘)   
 CREATE INDEX ix_QQNum_Group783 On GroupData8_Data.dbo.Group783 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group716‘)   
 CREATE INDEX ix_QQNum_Group716 On GroupData8_Data.dbo.Group716 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group784‘)   
 CREATE INDEX ix_QQNum_Group784 On GroupData8_Data.dbo.Group784 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group717‘)   
 CREATE INDEX ix_QQNum_Group717 On GroupData8_Data.dbo.Group717 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group785‘)   
 CREATE INDEX ix_QQNum_Group785 On GroupData8_Data.dbo.Group785 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group718‘)   
 CREATE INDEX ix_QQNum_Group718 On GroupData8_Data.dbo.Group718 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group786‘)   
 CREATE INDEX ix_QQNum_Group786 On GroupData8_Data.dbo.Group786 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group719‘)   
 CREATE INDEX ix_QQNum_Group719 On GroupData8_Data.dbo.Group719 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group787‘)   
 CREATE INDEX ix_QQNum_Group787 On GroupData8_Data.dbo.Group787 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group720‘)   
 CREATE INDEX ix_QQNum_Group720 On GroupData8_Data.dbo.Group720 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group788‘)   
 CREATE INDEX ix_QQNum_Group788 On GroupData8_Data.dbo.Group788 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group721‘)   
 CREATE INDEX ix_QQNum_Group721 On GroupData8_Data.dbo.Group721 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group789‘)   
 CREATE INDEX ix_QQNum_Group789 On GroupData8_Data.dbo.Group789 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group722‘)   
 CREATE INDEX ix_QQNum_Group722 On GroupData8_Data.dbo.Group722 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group790‘)   
 CREATE INDEX ix_QQNum_Group790 On GroupData8_Data.dbo.Group790 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group723‘)   
 CREATE INDEX ix_QQNum_Group723 On GroupData8_Data.dbo.Group723 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group791‘)   
 CREATE INDEX ix_QQNum_Group791 On GroupData8_Data.dbo.Group791 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group724‘)   
 CREATE INDEX ix_QQNum_Group724 On GroupData8_Data.dbo.Group724 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group792‘)   
 CREATE INDEX ix_QQNum_Group792 On GroupData8_Data.dbo.Group792 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group725‘)   
 CREATE INDEX ix_QQNum_Group725 On GroupData8_Data.dbo.Group725 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group793‘)   
 CREATE INDEX ix_QQNum_Group793 On GroupData8_Data.dbo.Group793 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group726‘)   
 CREATE INDEX ix_QQNum_Group726 On GroupData8_Data.dbo.Group726 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group794‘)   
 CREATE INDEX ix_QQNum_Group794 On GroupData8_Data.dbo.Group794 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group727‘)   
 CREATE INDEX ix_QQNum_Group727 On GroupData8_Data.dbo.Group727 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group795‘)   
 CREATE INDEX ix_QQNum_Group795 On GroupData8_Data.dbo.Group795 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group728‘)   
 CREATE INDEX ix_QQNum_Group728 On GroupData8_Data.dbo.Group728 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group796‘)   
 CREATE INDEX ix_QQNum_Group796 On GroupData8_Data.dbo.Group796 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group729‘)   
 CREATE INDEX ix_QQNum_Group729 On GroupData8_Data.dbo.Group729 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group797‘)   
 CREATE INDEX ix_QQNum_Group797 On GroupData8_Data.dbo.Group797 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group730‘)   
 CREATE INDEX ix_QQNum_Group730 On GroupData8_Data.dbo.Group730 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group798‘)   
 CREATE INDEX ix_QQNum_Group798 On GroupData8_Data.dbo.Group798 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group731‘)   
 CREATE INDEX ix_QQNum_Group731 On GroupData8_Data.dbo.Group731 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group799‘)   
 CREATE INDEX ix_QQNum_Group799 On GroupData8_Data.dbo.Group799 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group732‘)   
 CREATE INDEX ix_QQNum_Group732 On GroupData8_Data.dbo.Group732 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group800‘)   
 CREATE INDEX ix_QQNum_Group800 On GroupData8_Data.dbo.Group800 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group733‘)   
 CREATE INDEX ix_QQNum_Group733 On GroupData8_Data.dbo.Group733 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group734‘)   
 CREATE INDEX ix_QQNum_Group734 On GroupData8_Data.dbo.Group734 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group735‘)   
 CREATE INDEX ix_QQNum_Group735 On GroupData8_Data.dbo.Group735 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group736‘)   
 CREATE INDEX ix_QQNum_Group736 On GroupData8_Data.dbo.Group736 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group737‘)   
 CREATE INDEX ix_QQNum_Group737 On GroupData8_Data.dbo.Group737 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group738‘)   
 CREATE INDEX ix_QQNum_Group738 On GroupData8_Data.dbo.Group738 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group739‘)   
 CREATE INDEX ix_QQNum_Group739 On GroupData8_Data.dbo.Group739 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group740‘)   
 CREATE INDEX ix_QQNum_Group740 On GroupData8_Data.dbo.Group740 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group741‘)   
 CREATE INDEX ix_QQNum_Group741 On GroupData8_Data.dbo.Group741 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group742‘)   
 CREATE INDEX ix_QQNum_Group742 On GroupData8_Data.dbo.Group742 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group743‘)   
 CREATE INDEX ix_QQNum_Group743 On GroupData8_Data.dbo.Group743 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group744‘)   
 CREATE INDEX ix_QQNum_Group744 On GroupData8_Data.dbo.Group744 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group745‘)   
 CREATE INDEX ix_QQNum_Group745 On GroupData8_Data.dbo.Group745 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group746‘)   
 CREATE INDEX ix_QQNum_Group746 On GroupData8_Data.dbo.Group746 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group747‘)   
 CREATE INDEX ix_QQNum_Group747 On GroupData8_Data.dbo.Group747 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group748‘)   
 CREATE INDEX ix_QQNum_Group748 On GroupData8_Data.dbo.Group748 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group749‘)   
 CREATE INDEX ix_QQNum_Group749 On GroupData8_Data.dbo.Group749 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group750‘)   
 CREATE INDEX ix_QQNum_Group750 On GroupData8_Data.dbo.Group750 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group751‘)   
 CREATE INDEX ix_QQNum_Group751 On GroupData8_Data.dbo.Group751 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group752‘)   
 CREATE INDEX ix_QQNum_Group752 On GroupData8_Data.dbo.Group752 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group753‘)   
 CREATE INDEX ix_QQNum_Group753 On GroupData8_Data.dbo.Group753 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group754‘)   
 CREATE INDEX ix_QQNum_Group754 On GroupData8_Data.dbo.Group754 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group755‘)   
 CREATE INDEX ix_QQNum_Group755 On GroupData8_Data.dbo.Group755 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group756‘)   
 CREATE INDEX ix_QQNum_Group756 On GroupData8_Data.dbo.Group756 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group757‘)   
 CREATE INDEX ix_QQNum_Group757 On GroupData8_Data.dbo.Group757 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group758‘)   
 CREATE INDEX ix_QQNum_Group758 On GroupData8_Data.dbo.Group758 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group759‘)   
 CREATE INDEX ix_QQNum_Group759 On GroupData8_Data.dbo.Group759 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group760‘)   
 CREATE INDEX ix_QQNum_Group760 On GroupData8_Data.dbo.Group760 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group761‘)   
 CREATE INDEX ix_QQNum_Group761 On GroupData8_Data.dbo.Group761 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group762‘)   
 CREATE INDEX ix_QQNum_Group762 On GroupData8_Data.dbo.Group762 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group763‘)   
 CREATE INDEX ix_QQNum_Group763 On GroupData8_Data.dbo.Group763 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group764‘)   
 CREATE INDEX ix_QQNum_Group764 On GroupData8_Data.dbo.Group764 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group765‘)   
 CREATE INDEX ix_QQNum_Group765 On GroupData8_Data.dbo.Group765 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group766‘)   
 CREATE INDEX ix_QQNum_Group766 On GroupData8_Data.dbo.Group766 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group767‘)   
 CREATE INDEX ix_QQNum_Group767 On GroupData8_Data.dbo.Group767 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group768‘)   
 CREATE INDEX ix_QQNum_Group768 On GroupData8_Data.dbo.Group768 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group701‘)   
 CREATE INDEX ix_QQNum_Group701 On GroupData8_Data.dbo.Group701 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group769‘)   
 CREATE INDEX ix_QQNum_Group769 On GroupData8_Data.dbo.Group769 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group702‘)   
 CREATE INDEX ix_QQNum_Group702 On GroupData8_Data.dbo.Group702 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group770‘)   
 CREATE INDEX ix_QQNum_Group770 On GroupData8_Data.dbo.Group770 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group703‘)   
 CREATE INDEX ix_QQNum_Group703 On GroupData8_Data.dbo.Group703 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group771‘)   
 CREATE INDEX ix_QQNum_Group771 On GroupData8_Data.dbo.Group771 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group704‘)   
 CREATE INDEX ix_QQNum_Group704 On GroupData8_Data.dbo.Group704 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group772‘)   
 CREATE INDEX ix_QQNum_Group772 On GroupData8_Data.dbo.Group772 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group705‘)   
 CREATE INDEX ix_QQNum_Group705 On GroupData8_Data.dbo.Group705 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group773‘)   
 CREATE INDEX ix_QQNum_Group773 On GroupData8_Data.dbo.Group773 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData8_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group706‘)   
 CREATE INDEX ix_QQNum_Group706 On GroupData8_Data.dbo.Group706 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group874‘)   
 CREATE INDEX ix_QQNum_Group874 On GroupData9_Data.dbo.Group874 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group807‘)   
 CREATE INDEX ix_QQNum_Group807 On GroupData9_Data.dbo.Group807 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group875‘)   
 CREATE INDEX ix_QQNum_Group875 On GroupData9_Data.dbo.Group875 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group808‘)   
 CREATE INDEX ix_QQNum_Group808 On GroupData9_Data.dbo.Group808 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group876‘)   
 CREATE INDEX ix_QQNum_Group876 On GroupData9_Data.dbo.Group876 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group809‘)   
 CREATE INDEX ix_QQNum_Group809 On GroupData9_Data.dbo.Group809 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group877‘)   
 CREATE INDEX ix_QQNum_Group877 On GroupData9_Data.dbo.Group877 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group810‘)   
 CREATE INDEX ix_QQNum_Group810 On GroupData9_Data.dbo.Group810 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group878‘)   
 CREATE INDEX ix_QQNum_Group878 On GroupData9_Data.dbo.Group878 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group811‘)   
 CREATE INDEX ix_QQNum_Group811 On GroupData9_Data.dbo.Group811 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group879‘)   
 CREATE INDEX ix_QQNum_Group879 On GroupData9_Data.dbo.Group879 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group812‘)   
 CREATE INDEX ix_QQNum_Group812 On GroupData9_Data.dbo.Group812 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group880‘)   
 CREATE INDEX ix_QQNum_Group880 On GroupData9_Data.dbo.Group880 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group813‘)   
 CREATE INDEX ix_QQNum_Group813 On GroupData9_Data.dbo.Group813 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group881‘)   
 CREATE INDEX ix_QQNum_Group881 On GroupData9_Data.dbo.Group881 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group814‘)   
 CREATE INDEX ix_QQNum_Group814 On GroupData9_Data.dbo.Group814 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group882‘)   
 CREATE INDEX ix_QQNum_Group882 On GroupData9_Data.dbo.Group882 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group815‘)   
 CREATE INDEX ix_QQNum_Group815 On GroupData9_Data.dbo.Group815 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group883‘)   
 CREATE INDEX ix_QQNum_Group883 On GroupData9_Data.dbo.Group883 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group816‘)   
 CREATE INDEX ix_QQNum_Group816 On GroupData9_Data.dbo.Group816 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group884‘)   
 CREATE INDEX ix_QQNum_Group884 On GroupData9_Data.dbo.Group884 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group817‘)   
 CREATE INDEX ix_QQNum_Group817 On GroupData9_Data.dbo.Group817 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group885‘)   
 CREATE INDEX ix_QQNum_Group885 On GroupData9_Data.dbo.Group885 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group818‘)   
 CREATE INDEX ix_QQNum_Group818 On GroupData9_Data.dbo.Group818 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group886‘)   
 CREATE INDEX ix_QQNum_Group886 On GroupData9_Data.dbo.Group886 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group819‘)   
 CREATE INDEX ix_QQNum_Group819 On GroupData9_Data.dbo.Group819 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group887‘)   
 CREATE INDEX ix_QQNum_Group887 On GroupData9_Data.dbo.Group887 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group820‘)   
 CREATE INDEX ix_QQNum_Group820 On GroupData9_Data.dbo.Group820 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group888‘)   
 CREATE INDEX ix_QQNum_Group888 On GroupData9_Data.dbo.Group888 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group821‘)   
 CREATE INDEX ix_QQNum_Group821 On GroupData9_Data.dbo.Group821 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group889‘)   
 CREATE INDEX ix_QQNum_Group889 On GroupData9_Data.dbo.Group889 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group822‘)   
 CREATE INDEX ix_QQNum_Group822 On GroupData9_Data.dbo.Group822 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group890‘)   
 CREATE INDEX ix_QQNum_Group890 On GroupData9_Data.dbo.Group890 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group823‘)   
 CREATE INDEX ix_QQNum_Group823 On GroupData9_Data.dbo.Group823 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group891‘)   
 CREATE INDEX ix_QQNum_Group891 On GroupData9_Data.dbo.Group891 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group824‘)   
 CREATE INDEX ix_QQNum_Group824 On GroupData9_Data.dbo.Group824 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group892‘)   
 CREATE INDEX ix_QQNum_Group892 On GroupData9_Data.dbo.Group892 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group825‘)   
 CREATE INDEX ix_QQNum_Group825 On GroupData9_Data.dbo.Group825 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group893‘)   
 CREATE INDEX ix_QQNum_Group893 On GroupData9_Data.dbo.Group893 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group826‘)   
 CREATE INDEX ix_QQNum_Group826 On GroupData9_Data.dbo.Group826 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group894‘)   
 CREATE INDEX ix_QQNum_Group894 On GroupData9_Data.dbo.Group894 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group827‘)   
 CREATE INDEX ix_QQNum_Group827 On GroupData9_Data.dbo.Group827 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group895‘)   
 CREATE INDEX ix_QQNum_Group895 On GroupData9_Data.dbo.Group895 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group828‘)   
 CREATE INDEX ix_QQNum_Group828 On GroupData9_Data.dbo.Group828 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group896‘)   
 CREATE INDEX ix_QQNum_Group896 On GroupData9_Data.dbo.Group896 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group829‘)   
 CREATE INDEX ix_QQNum_Group829 On GroupData9_Data.dbo.Group829 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group897‘)   
 CREATE INDEX ix_QQNum_Group897 On GroupData9_Data.dbo.Group897 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group830‘)   
 CREATE INDEX ix_QQNum_Group830 On GroupData9_Data.dbo.Group830 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group898‘)   
 CREATE INDEX ix_QQNum_Group898 On GroupData9_Data.dbo.Group898 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group831‘)   
 CREATE INDEX ix_QQNum_Group831 On GroupData9_Data.dbo.Group831 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group899‘)   
 CREATE INDEX ix_QQNum_Group899 On GroupData9_Data.dbo.Group899 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group832‘)   
 CREATE INDEX ix_QQNum_Group832 On GroupData9_Data.dbo.Group832 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group900‘)   
 CREATE INDEX ix_QQNum_Group900 On GroupData9_Data.dbo.Group900 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group833‘)   
 CREATE INDEX ix_QQNum_Group833 On GroupData9_Data.dbo.Group833 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group834‘)   
 CREATE INDEX ix_QQNum_Group834 On GroupData9_Data.dbo.Group834 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group835‘)   
 CREATE INDEX ix_QQNum_Group835 On GroupData9_Data.dbo.Group835 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group836‘)   
 CREATE INDEX ix_QQNum_Group836 On GroupData9_Data.dbo.Group836 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group837‘)   
 CREATE INDEX ix_QQNum_Group837 On GroupData9_Data.dbo.Group837 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group838‘)   
 CREATE INDEX ix_QQNum_Group838 On GroupData9_Data.dbo.Group838 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group839‘)   
 CREATE INDEX ix_QQNum_Group839 On GroupData9_Data.dbo.Group839 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group840‘)   
 CREATE INDEX ix_QQNum_Group840 On GroupData9_Data.dbo.Group840 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group841‘)   
 CREATE INDEX ix_QQNum_Group841 On GroupData9_Data.dbo.Group841 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group842‘)   
 CREATE INDEX ix_QQNum_Group842 On GroupData9_Data.dbo.Group842 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group843‘)   
 CREATE INDEX ix_QQNum_Group843 On GroupData9_Data.dbo.Group843 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group844‘)   
 CREATE INDEX ix_QQNum_Group844 On GroupData9_Data.dbo.Group844 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group845‘)   
 CREATE INDEX ix_QQNum_Group845 On GroupData9_Data.dbo.Group845 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group846‘)   
 CREATE INDEX ix_QQNum_Group846 On GroupData9_Data.dbo.Group846 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group847‘)   
 CREATE INDEX ix_QQNum_Group847 On GroupData9_Data.dbo.Group847 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group848‘)   
 CREATE INDEX ix_QQNum_Group848 On GroupData9_Data.dbo.Group848 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group849‘)   
 CREATE INDEX ix_QQNum_Group849 On GroupData9_Data.dbo.Group849 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group850‘)   
 CREATE INDEX ix_QQNum_Group850 On GroupData9_Data.dbo.Group850 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group851‘)   
 CREATE INDEX ix_QQNum_Group851 On GroupData9_Data.dbo.Group851 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group852‘)   
 CREATE INDEX ix_QQNum_Group852 On GroupData9_Data.dbo.Group852 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group853‘)   
 CREATE INDEX ix_QQNum_Group853 On GroupData9_Data.dbo.Group853 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group854‘)   
 CREATE INDEX ix_QQNum_Group854 On GroupData9_Data.dbo.Group854 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group855‘)   
 CREATE INDEX ix_QQNum_Group855 On GroupData9_Data.dbo.Group855 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group856‘)   
 CREATE INDEX ix_QQNum_Group856 On GroupData9_Data.dbo.Group856 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group857‘)   
 CREATE INDEX ix_QQNum_Group857 On GroupData9_Data.dbo.Group857 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group858‘)   
 CREATE INDEX ix_QQNum_Group858 On GroupData9_Data.dbo.Group858 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group859‘)   
 CREATE INDEX ix_QQNum_Group859 On GroupData9_Data.dbo.Group859 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group860‘)   
 CREATE INDEX ix_QQNum_Group860 On GroupData9_Data.dbo.Group860 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group861‘)   
 CREATE INDEX ix_QQNum_Group861 On GroupData9_Data.dbo.Group861 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group862‘)   
 CREATE INDEX ix_QQNum_Group862 On GroupData9_Data.dbo.Group862 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group863‘)   
 CREATE INDEX ix_QQNum_Group863 On GroupData9_Data.dbo.Group863 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group864‘)   
 CREATE INDEX ix_QQNum_Group864 On GroupData9_Data.dbo.Group864 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group865‘)   
 CREATE INDEX ix_QQNum_Group865 On GroupData9_Data.dbo.Group865 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group866‘)   
 CREATE INDEX ix_QQNum_Group866 On GroupData9_Data.dbo.Group866 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group867‘)   
 CREATE INDEX ix_QQNum_Group867 On GroupData9_Data.dbo.Group867 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group868‘)   
 CREATE INDEX ix_QQNum_Group868 On GroupData9_Data.dbo.Group868 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group801‘)   
 CREATE INDEX ix_QQNum_Group801 On GroupData9_Data.dbo.Group801 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group869‘)   
 CREATE INDEX ix_QQNum_Group869 On GroupData9_Data.dbo.Group869 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group802‘)   
 CREATE INDEX ix_QQNum_Group802 On GroupData9_Data.dbo.Group802 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group870‘)   
 CREATE INDEX ix_QQNum_Group870 On GroupData9_Data.dbo.Group870 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group803‘)   
 CREATE INDEX ix_QQNum_Group803 On GroupData9_Data.dbo.Group803 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group871‘)   
 CREATE INDEX ix_QQNum_Group871 On GroupData9_Data.dbo.Group871 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group804‘)   
 CREATE INDEX ix_QQNum_Group804 On GroupData9_Data.dbo.Group804 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group872‘)   
 CREATE INDEX ix_QQNum_Group872 On GroupData9_Data.dbo.Group872 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group805‘)   
 CREATE INDEX ix_QQNum_Group805 On GroupData9_Data.dbo.Group805 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group873‘)   
 CREATE INDEX ix_QQNum_Group873 On GroupData9_Data.dbo.Group873 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData9_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group806‘)   
 CREATE INDEX ix_QQNum_Group806 On GroupData9_Data.dbo.Group806 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group974‘)   
 CREATE INDEX ix_QQNum_Group974 On GroupData10_Data.dbo.Group974 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group907‘)   
 CREATE INDEX ix_QQNum_Group907 On GroupData10_Data.dbo.Group907 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group975‘)   
 CREATE INDEX ix_QQNum_Group975 On GroupData10_Data.dbo.Group975 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group908‘)   
 CREATE INDEX ix_QQNum_Group908 On GroupData10_Data.dbo.Group908 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group976‘)   
 CREATE INDEX ix_QQNum_Group976 On GroupData10_Data.dbo.Group976 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group909‘)   
 CREATE INDEX ix_QQNum_Group909 On GroupData10_Data.dbo.Group909 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group977‘)   
 CREATE INDEX ix_QQNum_Group977 On GroupData10_Data.dbo.Group977 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group910‘)   
 CREATE INDEX ix_QQNum_Group910 On GroupData10_Data.dbo.Group910 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group978‘)   
 CREATE INDEX ix_QQNum_Group978 On GroupData10_Data.dbo.Group978 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group911‘)   
 CREATE INDEX ix_QQNum_Group911 On GroupData10_Data.dbo.Group911 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group979‘)   
 CREATE INDEX ix_QQNum_Group979 On GroupData10_Data.dbo.Group979 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group912‘)   
 CREATE INDEX ix_QQNum_Group912 On GroupData10_Data.dbo.Group912 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group980‘)   
 CREATE INDEX ix_QQNum_Group980 On GroupData10_Data.dbo.Group980 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group913‘)   
 CREATE INDEX ix_QQNum_Group913 On GroupData10_Data.dbo.Group913 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group981‘)   
 CREATE INDEX ix_QQNum_Group981 On GroupData10_Data.dbo.Group981 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group914‘)   
 CREATE INDEX ix_QQNum_Group914 On GroupData10_Data.dbo.Group914 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group982‘)   
 CREATE INDEX ix_QQNum_Group982 On GroupData10_Data.dbo.Group982 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group915‘)   
 CREATE INDEX ix_QQNum_Group915 On GroupData10_Data.dbo.Group915 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group983‘)   
 CREATE INDEX ix_QQNum_Group983 On GroupData10_Data.dbo.Group983 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group916‘)   
 CREATE INDEX ix_QQNum_Group916 On GroupData10_Data.dbo.Group916 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group984‘)   
 CREATE INDEX ix_QQNum_Group984 On GroupData10_Data.dbo.Group984 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group917‘)   
 CREATE INDEX ix_QQNum_Group917 On GroupData10_Data.dbo.Group917 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group985‘)   
 CREATE INDEX ix_QQNum_Group985 On GroupData10_Data.dbo.Group985 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group918‘)   
 CREATE INDEX ix_QQNum_Group918 On GroupData10_Data.dbo.Group918 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group986‘)   
 CREATE INDEX ix_QQNum_Group986 On GroupData10_Data.dbo.Group986 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group919‘)   
 CREATE INDEX ix_QQNum_Group919 On GroupData10_Data.dbo.Group919 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group987‘)   
 CREATE INDEX ix_QQNum_Group987 On GroupData10_Data.dbo.Group987 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group920‘)   
 CREATE INDEX ix_QQNum_Group920 On GroupData10_Data.dbo.Group920 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group988‘)   
 CREATE INDEX ix_QQNum_Group988 On GroupData10_Data.dbo.Group988 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group921‘)   
 CREATE INDEX ix_QQNum_Group921 On GroupData10_Data.dbo.Group921 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group989‘)   
 CREATE INDEX ix_QQNum_Group989 On GroupData10_Data.dbo.Group989 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group922‘)   
 CREATE INDEX ix_QQNum_Group922 On GroupData10_Data.dbo.Group922 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group990‘)   
 CREATE INDEX ix_QQNum_Group990 On GroupData10_Data.dbo.Group990 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group923‘)   
 CREATE INDEX ix_QQNum_Group923 On GroupData10_Data.dbo.Group923 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group991‘)   
 CREATE INDEX ix_QQNum_Group991 On GroupData10_Data.dbo.Group991 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group924‘)   
 CREATE INDEX ix_QQNum_Group924 On GroupData10_Data.dbo.Group924 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group992‘)   
 CREATE INDEX ix_QQNum_Group992 On GroupData10_Data.dbo.Group992 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group925‘)   
 CREATE INDEX ix_QQNum_Group925 On GroupData10_Data.dbo.Group925 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group993‘)   
 CREATE INDEX ix_QQNum_Group993 On GroupData10_Data.dbo.Group993 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group926‘)   
 CREATE INDEX ix_QQNum_Group926 On GroupData10_Data.dbo.Group926 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group994‘)   
 CREATE INDEX ix_QQNum_Group994 On GroupData10_Data.dbo.Group994 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group927‘)   
 CREATE INDEX ix_QQNum_Group927 On GroupData10_Data.dbo.Group927 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group995‘)   
 CREATE INDEX ix_QQNum_Group995 On GroupData10_Data.dbo.Group995 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group928‘)   
 CREATE INDEX ix_QQNum_Group928 On GroupData10_Data.dbo.Group928 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group996‘)   
 CREATE INDEX ix_QQNum_Group996 On GroupData10_Data.dbo.Group996 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group929‘)   
 CREATE INDEX ix_QQNum_Group929 On GroupData10_Data.dbo.Group929 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group997‘)   
 CREATE INDEX ix_QQNum_Group997 On GroupData10_Data.dbo.Group997 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group930‘)   
 CREATE INDEX ix_QQNum_Group930 On GroupData10_Data.dbo.Group930 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group998‘)   
 CREATE INDEX ix_QQNum_Group998 On GroupData10_Data.dbo.Group998 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group931‘)   
 CREATE INDEX ix_QQNum_Group931 On GroupData10_Data.dbo.Group931 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group999‘)   
 CREATE INDEX ix_QQNum_Group999 On GroupData10_Data.dbo.Group999 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group932‘)   
 CREATE INDEX ix_QQNum_Group932 On GroupData10_Data.dbo.Group932 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1000‘)   
 CREATE INDEX ix_QQNum_Group1000 On GroupData10_Data.dbo.Group1000 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group933‘)   
 CREATE INDEX ix_QQNum_Group933 On GroupData10_Data.dbo.Group933 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group934‘)   
 CREATE INDEX ix_QQNum_Group934 On GroupData10_Data.dbo.Group934 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group935‘)   
 CREATE INDEX ix_QQNum_Group935 On GroupData10_Data.dbo.Group935 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group936‘)   
 CREATE INDEX ix_QQNum_Group936 On GroupData10_Data.dbo.Group936 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group937‘)   
 CREATE INDEX ix_QQNum_Group937 On GroupData10_Data.dbo.Group937 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group938‘)   
 CREATE INDEX ix_QQNum_Group938 On GroupData10_Data.dbo.Group938 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group939‘)   
 CREATE INDEX ix_QQNum_Group939 On GroupData10_Data.dbo.Group939 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group940‘)   
 CREATE INDEX ix_QQNum_Group940 On GroupData10_Data.dbo.Group940 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group941‘)   
 CREATE INDEX ix_QQNum_Group941 On GroupData10_Data.dbo.Group941 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group942‘)   
 CREATE INDEX ix_QQNum_Group942 On GroupData10_Data.dbo.Group942 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group943‘)   
 CREATE INDEX ix_QQNum_Group943 On GroupData10_Data.dbo.Group943 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group944‘)   
 CREATE INDEX ix_QQNum_Group944 On GroupData10_Data.dbo.Group944 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group945‘)   
 CREATE INDEX ix_QQNum_Group945 On GroupData10_Data.dbo.Group945 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group946‘)   
 CREATE INDEX ix_QQNum_Group946 On GroupData10_Data.dbo.Group946 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group947‘)   
 CREATE INDEX ix_QQNum_Group947 On GroupData10_Data.dbo.Group947 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group948‘)   
 CREATE INDEX ix_QQNum_Group948 On GroupData10_Data.dbo.Group948 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group949‘)   
 CREATE INDEX ix_QQNum_Group949 On GroupData10_Data.dbo.Group949 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group950‘)   
 CREATE INDEX ix_QQNum_Group950 On GroupData10_Data.dbo.Group950 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group951‘)   
 CREATE INDEX ix_QQNum_Group951 On GroupData10_Data.dbo.Group951 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group952‘)   
 CREATE INDEX ix_QQNum_Group952 On GroupData10_Data.dbo.Group952 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group953‘)   
 CREATE INDEX ix_QQNum_Group953 On GroupData10_Data.dbo.Group953 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group954‘)   
 CREATE INDEX ix_QQNum_Group954 On GroupData10_Data.dbo.Group954 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group955‘)   
 CREATE INDEX ix_QQNum_Group955 On GroupData10_Data.dbo.Group955 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group956‘)   
 CREATE INDEX ix_QQNum_Group956 On GroupData10_Data.dbo.Group956 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group957‘)   
 CREATE INDEX ix_QQNum_Group957 On GroupData10_Data.dbo.Group957 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group958‘)   
 CREATE INDEX ix_QQNum_Group958 On GroupData10_Data.dbo.Group958 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group959‘)   
 CREATE INDEX ix_QQNum_Group959 On GroupData10_Data.dbo.Group959 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group960‘)   
 CREATE INDEX ix_QQNum_Group960 On GroupData10_Data.dbo.Group960 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group961‘)   
 CREATE INDEX ix_QQNum_Group961 On GroupData10_Data.dbo.Group961 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group962‘)   
 CREATE INDEX ix_QQNum_Group962 On GroupData10_Data.dbo.Group962 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group963‘)   
 CREATE INDEX ix_QQNum_Group963 On GroupData10_Data.dbo.Group963 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group964‘)   
 CREATE INDEX ix_QQNum_Group964 On GroupData10_Data.dbo.Group964 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group965‘)   
 CREATE INDEX ix_QQNum_Group965 On GroupData10_Data.dbo.Group965 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group966‘)   
 CREATE INDEX ix_QQNum_Group966 On GroupData10_Data.dbo.Group966 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group967‘)   
 CREATE INDEX ix_QQNum_Group967 On GroupData10_Data.dbo.Group967 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group968‘)   
 CREATE INDEX ix_QQNum_Group968 On GroupData10_Data.dbo.Group968 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group901‘)   
 CREATE INDEX ix_QQNum_Group901 On GroupData10_Data.dbo.Group901 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group969‘)   
 CREATE INDEX ix_QQNum_Group969 On GroupData10_Data.dbo.Group969 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group902‘)   
 CREATE INDEX ix_QQNum_Group902 On GroupData10_Data.dbo.Group902 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group970‘)   
 CREATE INDEX ix_QQNum_Group970 On GroupData10_Data.dbo.Group970 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group903‘)   
 CREATE INDEX ix_QQNum_Group903 On GroupData10_Data.dbo.Group903 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group971‘)   
 CREATE INDEX ix_QQNum_Group971 On GroupData10_Data.dbo.Group971 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group904‘)   
 CREATE INDEX ix_QQNum_Group904 On GroupData10_Data.dbo.Group904 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group972‘)   
 CREATE INDEX ix_QQNum_Group972 On GroupData10_Data.dbo.Group972 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group905‘)   
 CREATE INDEX ix_QQNum_Group905 On GroupData10_Data.dbo.Group905 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group973‘)   
 CREATE INDEX ix_QQNum_Group973 On GroupData10_Data.dbo.Group973 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData10_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group906‘)   
 CREATE INDEX ix_QQNum_Group906 On GroupData10_Data.dbo.Group906 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1074‘)   
 CREATE INDEX ix_QQNum_Group1074 On GroupData11_Data.dbo.Group1074 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1007‘)   
 CREATE INDEX ix_QQNum_Group1007 On GroupData11_Data.dbo.Group1007 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1075‘)   
 CREATE INDEX ix_QQNum_Group1075 On GroupData11_Data.dbo.Group1075 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1008‘)   
 CREATE INDEX ix_QQNum_Group1008 On GroupData11_Data.dbo.Group1008 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1076‘)   
 CREATE INDEX ix_QQNum_Group1076 On GroupData11_Data.dbo.Group1076 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1009‘)   
 CREATE INDEX ix_QQNum_Group1009 On GroupData11_Data.dbo.Group1009 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1077‘)   
 CREATE INDEX ix_QQNum_Group1077 On GroupData11_Data.dbo.Group1077 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1010‘)   
 CREATE INDEX ix_QQNum_Group1010 On GroupData11_Data.dbo.Group1010 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1078‘)   
 CREATE INDEX ix_QQNum_Group1078 On GroupData11_Data.dbo.Group1078 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1011‘)   
 CREATE INDEX ix_QQNum_Group1011 On GroupData11_Data.dbo.Group1011 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1079‘)   
 CREATE INDEX ix_QQNum_Group1079 On GroupData11_Data.dbo.Group1079 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1012‘)   
 CREATE INDEX ix_QQNum_Group1012 On GroupData11_Data.dbo.Group1012 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1080‘)   
 CREATE INDEX ix_QQNum_Group1080 On GroupData11_Data.dbo.Group1080 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1013‘)   
 CREATE INDEX ix_QQNum_Group1013 On GroupData11_Data.dbo.Group1013 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1081‘)   
 CREATE INDEX ix_QQNum_Group1081 On GroupData11_Data.dbo.Group1081 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1014‘)   
 CREATE INDEX ix_QQNum_Group1014 On GroupData11_Data.dbo.Group1014 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1082‘)   
 CREATE INDEX ix_QQNum_Group1082 On GroupData11_Data.dbo.Group1082 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1015‘)   
 CREATE INDEX ix_QQNum_Group1015 On GroupData11_Data.dbo.Group1015 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1083‘)   
 CREATE INDEX ix_QQNum_Group1083 On GroupData11_Data.dbo.Group1083 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1016‘)   
 CREATE INDEX ix_QQNum_Group1016 On GroupData11_Data.dbo.Group1016 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1084‘)   
 CREATE INDEX ix_QQNum_Group1084 On GroupData11_Data.dbo.Group1084 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1017‘)   
 CREATE INDEX ix_QQNum_Group1017 On GroupData11_Data.dbo.Group1017 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1085‘)   
 CREATE INDEX ix_QQNum_Group1085 On GroupData11_Data.dbo.Group1085 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1018‘)   
 CREATE INDEX ix_QQNum_Group1018 On GroupData11_Data.dbo.Group1018 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1086‘)   
 CREATE INDEX ix_QQNum_Group1086 On GroupData11_Data.dbo.Group1086 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1019‘)   
 CREATE INDEX ix_QQNum_Group1019 On GroupData11_Data.dbo.Group1019 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1087‘)   
 CREATE INDEX ix_QQNum_Group1087 On GroupData11_Data.dbo.Group1087 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1020‘)   
 CREATE INDEX ix_QQNum_Group1020 On GroupData11_Data.dbo.Group1020 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1088‘)   
 CREATE INDEX ix_QQNum_Group1088 On GroupData11_Data.dbo.Group1088 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1021‘)   
 CREATE INDEX ix_QQNum_Group1021 On GroupData11_Data.dbo.Group1021 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1089‘)   
 CREATE INDEX ix_QQNum_Group1089 On GroupData11_Data.dbo.Group1089 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1022‘)   
 CREATE INDEX ix_QQNum_Group1022 On GroupData11_Data.dbo.Group1022 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1090‘)   
 CREATE INDEX ix_QQNum_Group1090 On GroupData11_Data.dbo.Group1090 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1023‘)   
 CREATE INDEX ix_QQNum_Group1023 On GroupData11_Data.dbo.Group1023 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1091‘)   
 CREATE INDEX ix_QQNum_Group1091 On GroupData11_Data.dbo.Group1091 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1024‘)   
 CREATE INDEX ix_QQNum_Group1024 On GroupData11_Data.dbo.Group1024 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1092‘)   
 CREATE INDEX ix_QQNum_Group1092 On GroupData11_Data.dbo.Group1092 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1025‘)   
 CREATE INDEX ix_QQNum_Group1025 On GroupData11_Data.dbo.Group1025 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1093‘)   
 CREATE INDEX ix_QQNum_Group1093 On GroupData11_Data.dbo.Group1093 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1026‘)   
 CREATE INDEX ix_QQNum_Group1026 On GroupData11_Data.dbo.Group1026 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1094‘)   
 CREATE INDEX ix_QQNum_Group1094 On GroupData11_Data.dbo.Group1094 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1027‘)   
 CREATE INDEX ix_QQNum_Group1027 On GroupData11_Data.dbo.Group1027 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1095‘)   
 CREATE INDEX ix_QQNum_Group1095 On GroupData11_Data.dbo.Group1095 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1028‘)   
 CREATE INDEX ix_QQNum_Group1028 On GroupData11_Data.dbo.Group1028 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1096‘)   
 CREATE INDEX ix_QQNum_Group1096 On GroupData11_Data.dbo.Group1096 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1029‘)   
 CREATE INDEX ix_QQNum_Group1029 On GroupData11_Data.dbo.Group1029 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1097‘)   
 CREATE INDEX ix_QQNum_Group1097 On GroupData11_Data.dbo.Group1097 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1030‘)   
 CREATE INDEX ix_QQNum_Group1030 On GroupData11_Data.dbo.Group1030 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1098‘)   
 CREATE INDEX ix_QQNum_Group1098 On GroupData11_Data.dbo.Group1098 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1031‘)   
 CREATE INDEX ix_QQNum_Group1031 On GroupData11_Data.dbo.Group1031 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1099‘)   
 CREATE INDEX ix_QQNum_Group1099 On GroupData11_Data.dbo.Group1099 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1032‘)   
 CREATE INDEX ix_QQNum_Group1032 On GroupData11_Data.dbo.Group1032 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1100‘)   
 CREATE INDEX ix_QQNum_Group1100 On GroupData11_Data.dbo.Group1100 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1033‘)   
 CREATE INDEX ix_QQNum_Group1033 On GroupData11_Data.dbo.Group1033 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1034‘)   
 CREATE INDEX ix_QQNum_Group1034 On GroupData11_Data.dbo.Group1034 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1035‘)   
 CREATE INDEX ix_QQNum_Group1035 On GroupData11_Data.dbo.Group1035 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1036‘)   
 CREATE INDEX ix_QQNum_Group1036 On GroupData11_Data.dbo.Group1036 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1037‘)   
 CREATE INDEX ix_QQNum_Group1037 On GroupData11_Data.dbo.Group1037 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1038‘)   
 CREATE INDEX ix_QQNum_Group1038 On GroupData11_Data.dbo.Group1038 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1039‘)   
 CREATE INDEX ix_QQNum_Group1039 On GroupData11_Data.dbo.Group1039 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1040‘)   
 CREATE INDEX ix_QQNum_Group1040 On GroupData11_Data.dbo.Group1040 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1041‘)   
 CREATE INDEX ix_QQNum_Group1041 On GroupData11_Data.dbo.Group1041 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1042‘)   
 CREATE INDEX ix_QQNum_Group1042 On GroupData11_Data.dbo.Group1042 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1043‘)   
 CREATE INDEX ix_QQNum_Group1043 On GroupData11_Data.dbo.Group1043 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1044‘)   
 CREATE INDEX ix_QQNum_Group1044 On GroupData11_Data.dbo.Group1044 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1045‘)   
 CREATE INDEX ix_QQNum_Group1045 On GroupData11_Data.dbo.Group1045 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1046‘)   
 CREATE INDEX ix_QQNum_Group1046 On GroupData11_Data.dbo.Group1046 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1047‘)   
 CREATE INDEX ix_QQNum_Group1047 On GroupData11_Data.dbo.Group1047 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1048‘)   
 CREATE INDEX ix_QQNum_Group1048 On GroupData11_Data.dbo.Group1048 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1049‘)   
 CREATE INDEX ix_QQNum_Group1049 On GroupData11_Data.dbo.Group1049 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1050‘)   
 CREATE INDEX ix_QQNum_Group1050 On GroupData11_Data.dbo.Group1050 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1051‘)   
 CREATE INDEX ix_QQNum_Group1051 On GroupData11_Data.dbo.Group1051 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1052‘)   
 CREATE INDEX ix_QQNum_Group1052 On GroupData11_Data.dbo.Group1052 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1053‘)   
 CREATE INDEX ix_QQNum_Group1053 On GroupData11_Data.dbo.Group1053 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1054‘)   
 CREATE INDEX ix_QQNum_Group1054 On GroupData11_Data.dbo.Group1054 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1055‘)   
 CREATE INDEX ix_QQNum_Group1055 On GroupData11_Data.dbo.Group1055 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1056‘)   
 CREATE INDEX ix_QQNum_Group1056 On GroupData11_Data.dbo.Group1056 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1057‘)   
 CREATE INDEX ix_QQNum_Group1057 On GroupData11_Data.dbo.Group1057 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1058‘)   
 CREATE INDEX ix_QQNum_Group1058 On GroupData11_Data.dbo.Group1058 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1059‘)   
 CREATE INDEX ix_QQNum_Group1059 On GroupData11_Data.dbo.Group1059 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1060‘)   
 CREATE INDEX ix_QQNum_Group1060 On GroupData11_Data.dbo.Group1060 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1061‘)   
 CREATE INDEX ix_QQNum_Group1061 On GroupData11_Data.dbo.Group1061 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1062‘)   
 CREATE INDEX ix_QQNum_Group1062 On GroupData11_Data.dbo.Group1062 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1063‘)   
 CREATE INDEX ix_QQNum_Group1063 On GroupData11_Data.dbo.Group1063 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1064‘)   
 CREATE INDEX ix_QQNum_Group1064 On GroupData11_Data.dbo.Group1064 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1065‘)   
 CREATE INDEX ix_QQNum_Group1065 On GroupData11_Data.dbo.Group1065 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1066‘)   
 CREATE INDEX ix_QQNum_Group1066 On GroupData11_Data.dbo.Group1066 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1067‘)   
 CREATE INDEX ix_QQNum_Group1067 On GroupData11_Data.dbo.Group1067 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1068‘)   
 CREATE INDEX ix_QQNum_Group1068 On GroupData11_Data.dbo.Group1068 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1001‘)   
 CREATE INDEX ix_QQNum_Group1001 On GroupData11_Data.dbo.Group1001 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1069‘)   
 CREATE INDEX ix_QQNum_Group1069 On GroupData11_Data.dbo.Group1069 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1002‘)   
 CREATE INDEX ix_QQNum_Group1002 On GroupData11_Data.dbo.Group1002 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1070‘)   
 CREATE INDEX ix_QQNum_Group1070 On GroupData11_Data.dbo.Group1070 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1003‘)   
 CREATE INDEX ix_QQNum_Group1003 On GroupData11_Data.dbo.Group1003 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1071‘)   
 CREATE INDEX ix_QQNum_Group1071 On GroupData11_Data.dbo.Group1071 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1004‘)   
 CREATE INDEX ix_QQNum_Group1004 On GroupData11_Data.dbo.Group1004 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1072‘)   
 CREATE INDEX ix_QQNum_Group1072 On GroupData11_Data.dbo.Group1072 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1005‘)   
 CREATE INDEX ix_QQNum_Group1005 On GroupData11_Data.dbo.Group1005 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1073‘)   
 CREATE INDEX ix_QQNum_Group1073 On GroupData11_Data.dbo.Group1073 (QQNum);  
IF not EXISTS (SELECT indid FROM GroupData11_Data.dbo.sysindexes WHERE name = ‘ix_QQNum_Group1006‘)   
 CREATE INDEX ix_QQNum_Group1006 On GroupData11_Data.dbo.Group1006 (QQNum);  
;

3.SQL查询代码

declare @QQNum bigint = (123456789)
declare @sql nvarchar(4000)  
declare @dbIdx int = 1  
  
-- Author:   <NOBODY>  
-- Email:    <XX@YY>  
-- 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) + ‘_Data.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  

 

QQ群关系数据库处理

原文:https://www.cnblogs.com/ocean1100/p/8521834.html

踩
(0)
赞
(1)
   
举报
评论 一句话评论(0)
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!