SELECT Left([起始时间],11) AS 起始天, 指标1.网元名称, Sum(指标1.[CM33:业务信道掉话次数 (无)]) AS [CM33:业务信道掉话次数 (无)之合计], Sum(指标1.[CA313:指配成功次数 (无)]) AS [CA313:指配成功次数 (无)之合计], Sum(指标1.[K3013A:TCH呼叫占用成功次数(业务信道) (无)]) AS [K3013A:TCH呼叫占用成功次数(业务信道) (无)之合计], Sum(指标1.[K3013B:TCH切换占用成功次数(业务信道) (无)]) AS [K3013B:TCH切换占用成功次数(业务信道) (无)之合计], Sum(指标1.[K3011A:TCH呼叫占用遇全忙次数(业务信道) (无)]) AS [K3011A:TCH呼叫占用遇全忙次数(业务信道) (无)之合计], Sum(指标1.[K3011B:TCH切换占用遇全忙次数(业务信道) (无)]) AS [K3011B:TCH切换占用遇全忙次数(业务信道) (无)之合计], Sum(指标1.[CA310:指配请求次数 (无)]) AS [CA310:指配请求次数 (无)之合计], Sum(指标1.[M3000C:稳态下收到错误指示掉话次数(顺序错)(SDCCH) (无)]) AS [M3000C:稳态下收到错误指示掉话次数(顺序错)(SDCCH) (无)之合计], Sum(指标1.[M3002:稳态下收到释放指示掉话次数(SDCCH) (无)]) AS [M3002:稳态下收到释放指示掉话次数(SDCCH) (无)之合计], Sum(指标1.[M3001E:稳态下收到连接失败掉话次数(其他)(SDCCH) (无)]) AS [M3001E:稳态下收到连接失败掉话次数(其他)(SDCCH) (无)之合计], Sum(指标1.[M3001D:稳态下收到连接失败掉话次数(无线资源不可用)(SDCCH) (无)]) AS [M3001D:稳态下收到连接失败掉话次数(无线资源不可用)(SDCCH) (无)之合计], Sum(指标1.[M3001C:稳态下收到连接失败掉话次数(OM干预)(SDCCH) (无)]) AS [M3001C:稳态下收到连接失败掉话次数(OM干预)(SDCCH) (无)之合计], Sum(指标1.[M3001B:稳态下收到连接失败掉话次数(切换接入失败)(SDCCH) (无)]) AS [M3001B:稳态下收到连接失败掉话次数(切换接入失败)(SDCCH) (无)之合计], Sum(指标1.[M3001A:稳态下收到连接失败掉话次数(无线链路失败)(SDCCH) (无)]) AS [M3001A:稳态下收到连接失败掉话次数(无线链路失败)(SDCCH) (无)之合计], Sum(指标1.[M3000B:稳态下收到错误指示掉话次数(无请求的DM响应)(SDCCH) (无)]) AS [M3000B:稳态下收到错误指示掉话次数(无请求的DM响应)(SDCCH) (无)之合计], Sum(指标1.[M3000A:稳态下收到错误指示掉话次数(T200超时)(SDCCH) (无)]) AS [M3000A:稳态下收到错误指示掉话次数(T200超时)(SDCCH) (无)之合计], Sum(指标1.[K3000:SDCCH占用请求次数 (无)]) AS [K3000:SDCCH占用请求次数 (无)之合计], Sum(指标1.[K3001:SDCCH占用遇全忙次数 (无)]) AS [K3001:SDCCH占用遇全忙次数 (无)之合计], Sum(指标1.[K3003:SDCCH占用成功次数 (无)]) AS [K3003:SDCCH占用成功次数 (无)之合计], Sum(指标1.[TCH占用请求次数(所有的) (次)]) AS [TCH占用请求次数(所有的) (次)之合计], Sum(指标1.[TCH占用成功次数(所有的) (次)]) AS [TCH占用成功次数(所有的) (次)之合计], Sum(指标1.[CH313:BSC内出小区切换成功次数 (无)]) AS [CH313:BSC内出小区切换成功次数 (无)之合计], Sum(指标1.[CH323:BSC内入小区切换成功次数 (无)]) AS [CH323:BSC内入小区切换成功次数 (无)之合计], Sum(指标1.[CH333:BSC间出小区切换成功次数 (无)]) AS [CH333:BSC间出小区切换成功次数 (无)之合计], Sum(指标1.[CH343:BSC间入小区切换成功次数 (无)]) AS [CH343:BSC间入小区切换成功次数 (无)之合计], Sum(指标1.[CH310:BSC内出小区切换请求次数 (无)]) AS [CH310:BSC内出小区切换请求次数 (无)之合计], Sum(指标1.[CH320:BSC内入小区切换请求次数 (无)]) AS [CH320:BSC内入小区切换请求次数 (无)之合计], Sum(指标1.[CH330:BSC间出小区切换请求次数 (无)]) AS [CH330:BSC间出小区切换请求次数 (无)之合计], Sum(指标1.[CH340:BSC间入小区切换请求次数 (无)]) AS [CH340:BSC间入小区切换请求次数 (无)之合计], Sum(指标1.[CH311:BSC内出小区切换命令次数 (无)]) AS [CH311:BSC内出小区切换命令次数 (无)之合计], Sum(指标1.[CH321:BSC内入小区切换应答次数 (无)]) AS [CH321:BSC内入小区切换应答次数 (无)之合计], Sum(指标1.[CH331:BSC间出小区切换命令次数 (无)]) AS [CH331:BSC间出小区切换命令次数 (无)之合计], Sum(指标1.[CH341:BSC间入小区切换应答次数 (无)]) AS [CH341:BSC间入小区切换应答次数 (无)之合计], Sum(指标1.[K3014:TCH话务量 (爱尔兰)]) AS [K3014:TCH话务量 (爱尔兰)之合计], Sum(指标1.[K3004:SDCCH话务量 (爱尔兰)]) AS [K3004:SDCCH话务量 (爱尔兰)之合计], Sum(指标1.[CR3552:业务信道处于忙状态的平均数目(TCHH) (无)]) AS [CR3552:业务信道处于忙状态的平均数目(TCHH) (无)之合计]FROM 指标1GROUP BY Left([起始时间],11), 指标1.网元名称;