ÎÊÌâÒÑ¿ªÆô
(ÆÕͨÎÊÌâ)
ÓÐÄÄλ¸ßÊÖ¿ÉÒÔ¸øÎÒ·¢Ò»·ÝÈ¡Ö¸±êµÄsql½Å±¾£¿
ÓÐÄÄλ¸ßÊÖ¿ÉÒÔ¸øÎÒ·¢Ò»·ÝÈ¡Ö¸±êµÄsql½Å±¾£¿
¾ÍÊÇÓÃÊý¾Ý¿âÈí¼þsqldbx´ÓsybaseÖÐÈ¡Ö¸±êµÄsql½Å±¾£¿°®Á¢ÐŵÄÉ豸
¾ÍÊÇÓÃÊý¾Ý¿âÈí¼þsqldbx´ÓsybaseÖÐÈ¡Ö¸±êµÄsql½Å±¾£¿°®Á¢ÐŵÄÉ豸
ÌáÎÊÕß: zhugeyingju ÌáÎÊʱ¼ä: 2011-09-03
• Òƶ¯LTEÈÕ³£ÍøÓźǫ́¿¼ºËÄÄЩKIPÖ¸±ê 2020-06-14
• È«ÒµÎñBRASÉ豸ÐèÒª¹ØÄÄЩÐÔÄÜÖ¸±êÄØ£¿ 2020-02-22
• CQIÖ¸±ê ÊÇÄÜ˵Ã÷SINR²»ºÃô£¿ 2019-12-30
• ÓÎÏ·½»»¥Ê±ÑÓÔõô¶¨Ò壬ÓÎÏ·»°µ¥ÖÐÔõô¼ÆËã¸ÃÖ¸±ê 2019-12-25
• Çø¿éÁ´ÊÇÓ¦¶Ô×ʱ¾Î嶾£ºÔì¼Ù¡¢ÆÛÕ©¡¢³´×÷¡¢È¨Á¦Ñ°×â¼°Á÷Ã¥ÎÞÀµµÄÀûÆ÷£¡Ö»ÒªÔÚ¾ßÌåÂäʵËÄÖÐÈ«»á¡¶¾öÒé¡·µÄ13Ïî¼á³ÖÓëÍêÉÆ´ëÊ©ÖУ¬×Ðϸ·ÖÎöÑо¿ÒÑÓеľ¼Ã¹æÂÉ¡¢·¨ÂÉ¡¢·¨¹æ£¬½«ËüÃÇÉÏÉýΪ¾¼Ã·¢Õ¹ÖÐÊÜÒªËؾö¶¨µÄÖ¸±ê 2019-12-01
• ÎÒÏëÎÊÏ£¬4GÈ«Ì×ÊÓƵÕâ¸ö£¬Óн²½âºǫ́ÔõôÌáÉýÖ¸±ê£¬Ã¿¸öÖ¸±ê×öʲôµÄÂï 2019-11-04
• Ó°ÏìÌìÏßϵͳ¸²¸ÇÐÔÄܵÄÖ¸±êÓÐÄÄЩ 2019-09-29
• µ÷ÕûTA&TAL¿ÉÒÔ¸ÄÉÆÄÄЩָ±ê 2019-07-13
• È«ÒµÎñBRASÉ豸ÐèÒª¹ØÄÄЩÐÔÄÜÖ¸±êÄØ£¿ 2020-02-22
• CQIÖ¸±ê ÊÇÄÜ˵Ã÷SINR²»ºÃô£¿ 2019-12-30
• ÓÎÏ·½»»¥Ê±ÑÓÔõô¶¨Ò壬ÓÎÏ·»°µ¥ÖÐÔõô¼ÆËã¸ÃÖ¸±ê 2019-12-25
• Çø¿éÁ´ÊÇÓ¦¶Ô×ʱ¾Î嶾£ºÔì¼Ù¡¢ÆÛÕ©¡¢³´×÷¡¢È¨Á¦Ñ°×â¼°Á÷Ã¥ÎÞÀµµÄÀûÆ÷£¡Ö»ÒªÔÚ¾ßÌåÂäʵËÄÖÐÈ«»á¡¶¾öÒé¡·µÄ13Ïî¼á³ÖÓëÍêÉÆ´ëÊ©ÖУ¬×Ðϸ·ÖÎöÑо¿ÒÑÓеľ¼Ã¹æÂÉ¡¢·¨ÂÉ¡¢·¨¹æ£¬½«ËüÃÇÉÏÉýΪ¾¼Ã·¢Õ¹ÖÐÊÜÒªËؾö¶¨µÄÖ¸±ê 2019-12-01
• ÎÒÏëÎÊÏ£¬4GÈ«Ì×ÊÓƵÕâ¸ö£¬Óн²½âºǫ́ÔõôÌáÉýÖ¸±ê£¬Ã¿¸öÖ¸±ê×öʲôµÄÂï 2019-11-04
• Ó°ÏìÌìÏßϵͳ¸²¸ÇÐÔÄܵÄÖ¸±êÓÐÄÄЩ 2019-09-29
• µ÷ÕûTA&TAL¿ÉÒÔ¸ÄÉÆÄÄЩָ±ê 2019-07-13
ÎÊÌâ´ð°¸
( 3 )
°®Á¢ÐŵĵĽű¾
»Ø´ðÕߣº
sxp030315
»Ø´ðʱ¼ä£º2011-09-03 15:53
13 16
Áô¸öÓÊÏ䣬Ííµã°ïÄã·¢¹ýÀ´£¬Õâ¸öÌùµÄ»°£¬±È½Ï¶à¡£
ÊÔÒ»ÊÔ ¿´ÄÜÌù¶àÉÙ°É
SELECT CELTCHF_ADM.TIME AS DATE,CELTCHF.MO AS CELL,CELTCHF_ADM.NE AS BSC,
STR((CELTCHF.TFTRALACC/(CELTCHF.TFNSCAN+0.0001) + CELTCHH.THTRALACC/(CELTCHH.THNSCAN+0.0001))*3600/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.0001),10,2) AS ͨ»°Ê±¼ä,
CELTCHFP.TFCONGPGSMSUB AS TCHµô»°´ÎÊý,
CELTCHF.TFNDROP AS È«ËÙÂÊTCHµô»°´ÎÊý,
CELTCHH.THNDROP AS °ëËÙÂÊTCHµô»°´ÎÊý,
CELTCHF.TFNDROP+CELTCHH.THNDROP AS È«ËÙÂʼӰëËÙÂʵô»°´ÎÊý,
CLTCH.TASSALL-CLTCH.TCASSALL as TCH·ÖÅäʧ°Ü´ÎÊý,
CLTCH.TCASSALL as TCH·ÖÅä³É¹¦´ÎÊý²»º¬Çл»,
CLTCH.TASSALL as TCH·ÖÅäÇëÇó´ÎÊý,
STR(CLTCH.TCASSALL/(CLTCH.TASSALL+0.00001),10,2) as TCH·ÖÅä³É¹¦ÂÊ,
STR(CELTCHFP.TFCONGPGSMSUB/(CLTCH.TCASSALL+0.0001)*100,10,2) AS TCHµô»°Âʲ»º¬Çл»,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN+CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH»°ÎñÁ¿,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN),10,2) AS TCHÈ«ËÙÂÊ»°ÎñÁ¿,
STR((CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH°ëËÙÂÊ»°ÎñÁ¿,
str(((CELTCHF.TFTRALACC + CELTCHH.THTRALACC)/(CELTCHF.TFNSCAN+0.00001))/(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.00001)+0.00001),10,2) as TCHÿÐŵÀ»°ÎñÁ¿,
str((CELLGPRS.ALLPDCHACC/(CELLGPRS.ALLPDCHSCAN+0.00001)),10,2) AS ·ÖÅäµÄPDCHÊýÁ¿,
CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL AS PDCH·ÖÅä³É¹¦´ÎÊý,
CELLGPRS.PCHALLATT AS PDCHÇëÇó´ÎÊý,
CELLGPRS.PCHALLFAIL AS PDCH·ÖÅäʧ°Ü´ÎÊý,
str((CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL)/(CELLGPRS.PCHALLATT+0.00001),10,2) AS PDCH·ÖÅä³É¹¦ÂÊ,
CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO as TCHÓµÈû´ÎÊý,
str(100*(CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO)/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.00001),10,4) as TCHÓµÈûÂÊ,
CELTCHFP.TFESTPGSMSUB as TCHÕæʵӵÈû´ÎÊý,
CELTCHF.TFCONGSHO as TCHÈ«ËÙÂÊÇл»ÓµÈû´ÎÊý,
CELTCHH.THCONGSHO as TCH°ëËÙÂÊÇл»ÓµÈû´ÎÊý,
CELTCHF.TFCALLS as TCHÈ«ËÙÂÊÊÔºô´ÎÊý,
CELTCHH.THCALLS as TCH°ëËÙÂÊÊÔºô´ÎÊý,
CLTCH.TASSALL AS TCH±¾µØÊÔºô´ÎÊý,
CLTCH.TNUCHCNT AS TCH¶¨ÒåµÄÐŵÀÊý,
STR(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001),10,2) AS TCH¿ÉÓÃÐŵÀÊý,
STR((CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001))/(CLTCH.TNUCHCNT+0.0001)*100,10,2) AS TCHÐŵÀ¿ÉÓÃÂÊ,
CEILING((CLTCH.TNUCHCNT+CLSDCCH.CNUCHCNT/8)/8) AS TRX,
STR((CLTCHDRF.TFDISTA+CLTCHDRH.THDISTA)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS TAµô»°±È,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSDL+CLTCHDRH.THDISSDL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSUL+CLTCHDRH.THDISSUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS Öʲîµô»°±È,
STR((CLTCHDRF.TFDISQADL+CLTCHDRH.THDISQADL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQAUL+CLTCHDRH.THDISQAUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFSUDLOS+CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ͻȻµô»°±È,
STR((CELTCHF.TFNDROP+CELTCHH.THNDROP-CLTCHDRF.TFDISTA-CLTCHDRH.THDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRF.TFSUDLOS-CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÆäËûµô»°±È,
STR((CLTCHDRF.TFDISTA)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊTAµô»°±È,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSDL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQADL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQAUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊͻȻµô»°±È,
STR((CELTCHF.TFNDROP-CLTCHDRF.TFDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÆäËûµô»°±È,
STR((CLTCHDRH.THDISTA)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëÈ«ËÙÂÊTAµô»°±È,
STR((CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISSDL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISSUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÐÐÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÖʲîµô»°±È,
STR((CLTCHDRH.THDISQADL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRH.THDISQAUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÐÐÖʲîµô»°±È,
STR((CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊͻȻµô»°±È,
STR((CELTCHH.THNDROP-CLTCHDRH.THDISTA-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÆäËûµô»°±È,
RANDOMACC.CNROCNT AS Ëæ¼´½ÓÈë³É¹¦´ÎÊý,
RANDOMACC.RAACCFA AS Ëæ¼´½ÓÈëʧ°Ü´ÎÊý,
STR(RANDOMACC.CNROCNT/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA+0.00001)*100,10,2) AS Ëæ¼´½ÓÈë³É¹¦ÂÊ,
RANDOMACC.RAEMCAL AS ½ô¼±ºô½Ð´ÎÊý,
RANDOMACC.RACALRE AS ºô½ÐÖؽ¨½ÓÈë´ÎÊý,
RANDOMACC.RAANPAG AS Ëæ¼´½ÓÈëµÄÑ°ºô´ÎÊý,
RANDOMACC.RAOSREQ AS Ëæ¼´½ÓÈëµÄºô½Ð´ÎÊý,
RANDOMACC.RAOTHER AS Ëæ¼´½ÓÈëÖеÄλÖøüдÎÊý,
STR(RANDOMACC.RAOTHER/(RANDOMACC.CNROCNT+0.0001)*100,10,2) AS Ëæ»ú½ÓÈëÖеÄλÖøüбÈ,
CLSDCCH.CCALLS AS SDCCHÊÔºô´ÎÊý,
CLSDCCH.CMSESTAB AS SDCCH³É¹¦Õ¼ÓôÎÊý,
STR(CLSDCCH.CCONGS/(CLSDCCH.CCALLS+0.0001)*100,10,2) AS SDÓµÈûÂÊ,
CLSDCCH.CNDROP AS SDµô»°´ÎÊý,
STR(CLSDCCH.CNDROP/(CLSDCCH.CMSESTAB+0.0001)*100,10,2) AS SDµô»°ÂÊ,
CLSDCCH.CCONGS AS SDÓµÈû´ÎÊý,
CLSDCCH.CTCONGS AS SDÓµÈûʱ¼ä,
STR((CLSDCCH_ADM.RPL/60)*CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN+0.0001),10,2) AS SD»°ÎñÁ¿,
STR((CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001))/CLSDCCH.CNUCHCNT*100,10,2) AS SDÐŵÀ¿ÉÓÃÂÊ,
STR(CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001),10,2) AS SD¿ÉÓõÄÐŵÀÊý,
CLSDCCH.CNUCHCNT AS SD¶¨ÒåµÄÐŵÀÊý,
STR(CELLCCHDR.CDISTA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SDµÄTAµô»°±È,
STR(CELLCCHDR.CDISSS/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SDÈõÐźŵô»°±È,
STR(CELLCCHDR.CDISQA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SDÖʲîµô»°±È,
STR(((CLSDCCH.CNDROP-CELLCCHDR.CDISTA-CELLCCHDR.CDISSS-CELLCCHDR.CDISQA)/(CLSDCCH.CNDROP+0.0001))*100,10,2) AS SDÆäËûÔÒòµô»°±È,
STR((CLSDCCH.CMSESTAB)/(CLSDCCH.CCALLS-CLSDCCH.CCONGS+0.0001)*100,10,2) AS SD½¨Á¢³É¹¦ÂÊ,
CLTCH.TCHSIG AS TCHת»»ÎªSDµÄ´ÎÊý,
STR((IDLEUTCHF.ITFUSIB1)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU1,
STR((IDLEUTCHF.ITFUSIB2)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU2,
STR((IDLEUTCHF.ITFUSIB3)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU3,
STR((IDLEUTCHF.ITFUSIB4)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU4,
STR((IDLEUTCHF.ITFUSIB5)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU5
FROM CELTCHF
LEFT JOIN CELTCHF_ADM ON CELTCHF.ID=CELTCHF_ADM.ID
LEFT JOIN CELTCHFP ON CELTCHF.MO=CELTCHFP.MO AND CELTCHF.ID=CELTCHFP.ID
LEFT JOIN CELTCHH ON CELTCHF.MO=CELTCHH.MO AND CELTCHF.ID=CELTCHH.ID
LEFT JOIN CELTCHH_ADM ON CELTCHF.ID=CELTCHH_ADM.ID
LEFT JOIN CLTCH ON CELTCHF.MO=CLTCH.MO AND CELTCHF.ID=CLTCH.ID
LEFT JOIN CLTCHDRF ON CELTCHF.MO=CLTCHDRF.MO AND CELTCHF.ID=CLTCHDRF.ID
LEFT JOIN CLTCHDRH ON CELTCHF.MO=CLTCHDRH.MO AND CELTCHF.ID=CLTCHDRH.ID
LEFT JOIN CLSDCCH ON CELTCHF.MO=CLSDCCH.MO AND CELTCHF.ID=CLSDCCH.ID
LEFT JOIN CLSDCCH_ADM ON CELTCHF.ID=CLSDCCH_ADM.ID
LEFT JOIN CELLCCHDR ON CELTCHF.MO=CELLCCHDR.MO AND CELTCHF.ID=CELLCCHDR.ID
LEFT JOIN IDLEUTCHF ON CELTCHF.MO=IDLEUTCHF.MO AND CELTCHF.ID=IDLEUTCHF.ID
LEFT JOIN CELLGPRS ON IDLEUTCHF.MO=CELLGPRS.MO AND IDLEUTCHF.ID=CELLGPRS.ID
LEFT JOIN RANDOMACC ON CELTCHF.MO=RANDOMACC.MO AND CELTCHF.ID=RANDOMACC.ID
WHERE CELTCHF_ADM.TIME/*>= '2010-12-13 9:00'*/IN('2010-12-11 10:00') AND CELTCHF_ADM.NE LIKE '%WHBSC%' AND CELTCHF.MO LIKE '%W%'
ORDER BY CELTCHF_ADM.NE,CELTCHF.MO,CELTCHF_ADM.TIME;
ÊÔÒ»ÊÔ ¿´ÄÜÌù¶àÉÙ°É
SELECT CELTCHF_ADM.TIME AS DATE,CELTCHF.MO AS CELL,CELTCHF_ADM.NE AS BSC,
STR((CELTCHF.TFTRALACC/(CELTCHF.TFNSCAN+0.0001) + CELTCHH.THTRALACC/(CELTCHH.THNSCAN+0.0001))*3600/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.0001),10,2) AS ͨ»°Ê±¼ä,
CELTCHFP.TFCONGPGSMSUB AS TCHµô»°´ÎÊý,
CELTCHF.TFNDROP AS È«ËÙÂÊTCHµô»°´ÎÊý,
CELTCHH.THNDROP AS °ëËÙÂÊTCHµô»°´ÎÊý,
CELTCHF.TFNDROP+CELTCHH.THNDROP AS È«ËÙÂʼӰëËÙÂʵô»°´ÎÊý,
CLTCH.TASSALL-CLTCH.TCASSALL as TCH·ÖÅäʧ°Ü´ÎÊý,
CLTCH.TCASSALL as TCH·ÖÅä³É¹¦´ÎÊý²»º¬Çл»,
CLTCH.TASSALL as TCH·ÖÅäÇëÇó´ÎÊý,
STR(CLTCH.TCASSALL/(CLTCH.TASSALL+0.00001),10,2) as TCH·ÖÅä³É¹¦ÂÊ,
STR(CELTCHFP.TFCONGPGSMSUB/(CLTCH.TCASSALL+0.0001)*100,10,2) AS TCHµô»°Âʲ»º¬Çл»,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN+CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH»°ÎñÁ¿,
STR((CELTCHF.TFTRALACC/CELTCHF.TFNSCAN),10,2) AS TCHÈ«ËÙÂÊ»°ÎñÁ¿,
STR((CELTCHH.THTRALACC/CELTCHH.THNSCAN),10,2) AS TCH°ëËÙÂÊ»°ÎñÁ¿,
str(((CELTCHF.TFTRALACC + CELTCHH.THTRALACC)/(CELTCHF.TFNSCAN+0.00001))/(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.00001)+0.00001),10,2) as TCHÿÐŵÀ»°ÎñÁ¿,
str((CELLGPRS.ALLPDCHACC/(CELLGPRS.ALLPDCHSCAN+0.00001)),10,2) AS ·ÖÅäµÄPDCHÊýÁ¿,
CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL AS PDCH·ÖÅä³É¹¦´ÎÊý,
CELLGPRS.PCHALLATT AS PDCHÇëÇó´ÎÊý,
CELLGPRS.PCHALLFAIL AS PDCH·ÖÅäʧ°Ü´ÎÊý,
str((CELLGPRS.PCHALLATT-CELLGPRS.PCHALLFAIL)/(CELLGPRS.PCHALLATT+0.00001),10,2) AS PDCH·ÖÅä³É¹¦ÂÊ,
CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO as TCHÓµÈû´ÎÊý,
str(100*(CELTCHFP.TFESTPGSMSUB+CELTCHF.TFCONGSHO+CELTCHH.THCONGSHO)/(CELTCHF.TFCALLS+CELTCHH.THCALLS+0.00001),10,4) as TCHÓµÈûÂÊ,
CELTCHFP.TFESTPGSMSUB as TCHÕæʵӵÈû´ÎÊý,
CELTCHF.TFCONGSHO as TCHÈ«ËÙÂÊÇл»ÓµÈû´ÎÊý,
CELTCHH.THCONGSHO as TCH°ëËÙÂÊÇл»ÓµÈû´ÎÊý,
CELTCHF.TFCALLS as TCHÈ«ËÙÂÊÊÔºô´ÎÊý,
CELTCHH.THCALLS as TCH°ëËÙÂÊÊÔºô´ÎÊý,
CLTCH.TASSALL AS TCH±¾µØÊÔºô´ÎÊý,
CLTCH.TNUCHCNT AS TCH¶¨ÒåµÄÐŵÀÊý,
STR(CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001),10,2) AS TCH¿ÉÓÃÐŵÀÊý,
STR((CLTCH.TAVAACC/(CLTCH.TAVASCAN+0.0001))/(CLTCH.TNUCHCNT+0.0001)*100,10,2) AS TCHÐŵÀ¿ÉÓÃÂÊ,
CEILING((CLTCH.TNUCHCNT+CLSDCCH.CNUCHCNT/8)/8) AS TRX,
STR((CLTCHDRF.TFDISTA+CLTCHDRH.THDISTA)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS TAµô»°±È,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSDL+CLTCHDRH.THDISSDL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSUL+CLTCHDRH.THDISSUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSBL+CLTCHDRH.THDISSBL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS Öʲîµô»°±È,
STR((CLTCHDRF.TFDISQADL+CLTCHDRH.THDISQADL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQAUL+CLTCHDRH.THDISQAUL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQABL+CLTCHDRH.THDISQABL)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÉÏÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFSUDLOS+CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ͻȻµô»°±È,
STR((CELTCHF.TFNDROP+CELTCHH.THNDROP-CLTCHDRF.TFDISTA-CLTCHDRH.THDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRF.TFSUDLOS-CLTCHDRH.THSUDLOS)/(CELTCHF.TFNDROP+CELTCHH.THNDROP+0.0001)*100,10,2) AS ÆäËûµô»°±È,
STR((CLTCHDRF.TFDISTA)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊTAµô»°±È,
STR((CLTCHDRF.TFDISSDL+CLTCHDRF.TFDISSUL+CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSDL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISSBL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRF.TFDISQADL+CLTCHDRF.TFDISQAUL+CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQADL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQAUL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFDISQABL)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÉÏÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊͻȻµô»°±È,
STR((CELTCHF.TFNDROP-CLTCHDRF.TFDISTA-CLTCHDRF.TFDISSDL-CLTCHDRF.TFDISSUL-CLTCHDRF.TFDISSBL-CLTCHDRF.TFDISQADL-CLTCHDRF.TFDISQAUL-CLTCHDRF.TFDISQABL-CLTCHDRF.TFSUDLOS)/(CELTCHF.TFNDROP+0.0001)*100,10,2) AS È«ËÙÂÊÆäËûµô»°±È,
STR((CLTCHDRH.THDISTA)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëÈ«ËÙÂÊTAµô»°±È,
STR((CLTCHDRH.THDISSDL+CLTCHDRH.THDISSUL+CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISSDL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISSUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÐÐÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISSBL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÏÂÐÐÈõÐźŵô»°±È,
STR((CLTCHDRH.THDISQADL+CLTCHDRH.THDISQAUL+CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÖʲîµô»°±È,
STR((CLTCHDRH.THDISQADL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRH.THDISQAUL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÐÐÖʲîµô»°±È,
STR((CLTCHDRH.THDISQABL)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÉÏÏÂÐÐÖʲîµô»°±È,
STR((CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊͻȻµô»°±È,
STR((CELTCHH.THNDROP-CLTCHDRH.THDISTA-CLTCHDRH.THDISSDL-CLTCHDRH.THDISSUL-CLTCHDRH.THDISSBL-CLTCHDRH.THDISQADL-CLTCHDRH.THDISQAUL-CLTCHDRH.THDISQABL-CLTCHDRH.THSUDLOS)/(CELTCHH.THNDROP+0.0001)*100,10,2) AS °ëËÙÂÊÆäËûµô»°±È,
RANDOMACC.CNROCNT AS Ëæ¼´½ÓÈë³É¹¦´ÎÊý,
RANDOMACC.RAACCFA AS Ëæ¼´½ÓÈëʧ°Ü´ÎÊý,
STR(RANDOMACC.CNROCNT/(RANDOMACC.CNROCNT+RANDOMACC.RAACCFA+0.00001)*100,10,2) AS Ëæ¼´½ÓÈë³É¹¦ÂÊ,
RANDOMACC.RAEMCAL AS ½ô¼±ºô½Ð´ÎÊý,
RANDOMACC.RACALRE AS ºô½ÐÖؽ¨½ÓÈë´ÎÊý,
RANDOMACC.RAANPAG AS Ëæ¼´½ÓÈëµÄÑ°ºô´ÎÊý,
RANDOMACC.RAOSREQ AS Ëæ¼´½ÓÈëµÄºô½Ð´ÎÊý,
RANDOMACC.RAOTHER AS Ëæ¼´½ÓÈëÖеÄλÖøüдÎÊý,
STR(RANDOMACC.RAOTHER/(RANDOMACC.CNROCNT+0.0001)*100,10,2) AS Ëæ»ú½ÓÈëÖеÄλÖøüбÈ,
CLSDCCH.CCALLS AS SDCCHÊÔºô´ÎÊý,
CLSDCCH.CMSESTAB AS SDCCH³É¹¦Õ¼ÓôÎÊý,
STR(CLSDCCH.CCONGS/(CLSDCCH.CCALLS+0.0001)*100,10,2) AS SDÓµÈûÂÊ,
CLSDCCH.CNDROP AS SDµô»°´ÎÊý,
STR(CLSDCCH.CNDROP/(CLSDCCH.CMSESTAB+0.0001)*100,10,2) AS SDµô»°ÂÊ,
CLSDCCH.CCONGS AS SDÓµÈû´ÎÊý,
CLSDCCH.CTCONGS AS SDÓµÈûʱ¼ä,
STR((CLSDCCH_ADM.RPL/60)*CLSDCCH.CTRALACC/(CLSDCCH.CNSCAN+0.0001),10,2) AS SD»°ÎñÁ¿,
STR((CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001))/CLSDCCH.CNUCHCNT*100,10,2) AS SDÐŵÀ¿ÉÓÃÂÊ,
STR(CLSDCCH.CAVAACC/(CLSDCCH.CAVASCAN+0.0001),10,2) AS SD¿ÉÓõÄÐŵÀÊý,
CLSDCCH.CNUCHCNT AS SD¶¨ÒåµÄÐŵÀÊý,
STR(CELLCCHDR.CDISTA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SDµÄTAµô»°±È,
STR(CELLCCHDR.CDISSS/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SDÈõÐźŵô»°±È,
STR(CELLCCHDR.CDISQA/(CLSDCCH.CNDROP+0.0001)*100,10,2) AS SDÖʲîµô»°±È,
STR(((CLSDCCH.CNDROP-CELLCCHDR.CDISTA-CELLCCHDR.CDISSS-CELLCCHDR.CDISQA)/(CLSDCCH.CNDROP+0.0001))*100,10,2) AS SDÆäËûÔÒòµô»°±È,
STR((CLSDCCH.CMSESTAB)/(CLSDCCH.CCALLS-CLSDCCH.CCONGS+0.0001)*100,10,2) AS SD½¨Á¢³É¹¦ÂÊ,
CLTCH.TCHSIG AS TCHת»»ÎªSDµÄ´ÎÊý,
STR((IDLEUTCHF.ITFUSIB1)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU1,
STR((IDLEUTCHF.ITFUSIB2)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU2,
STR((IDLEUTCHF.ITFUSIB3)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU3,
STR((IDLEUTCHF.ITFUSIB4)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU4,
STR((IDLEUTCHF.ITFUSIB5)/(IDLEUTCHF.ITFUSIB1+IDLEUTCHF.ITFUSIB2+IDLEUTCHF.ITFUSIB3+IDLEUTCHF.ITFUSIB4+IDLEUTCHF.ITFUSIB5+0.0001)*100,10,2) AS ICM_FU5
FROM CELTCHF
LEFT JOIN CELTCHF_ADM ON CELTCHF.ID=CELTCHF_ADM.ID
LEFT JOIN CELTCHFP ON CELTCHF.MO=CELTCHFP.MO AND CELTCHF.ID=CELTCHFP.ID
LEFT JOIN CELTCHH ON CELTCHF.MO=CELTCHH.MO AND CELTCHF.ID=CELTCHH.ID
LEFT JOIN CELTCHH_ADM ON CELTCHF.ID=CELTCHH_ADM.ID
LEFT JOIN CLTCH ON CELTCHF.MO=CLTCH.MO AND CELTCHF.ID=CLTCH.ID
LEFT JOIN CLTCHDRF ON CELTCHF.MO=CLTCHDRF.MO AND CELTCHF.ID=CLTCHDRF.ID
LEFT JOIN CLTCHDRH ON CELTCHF.MO=CLTCHDRH.MO AND CELTCHF.ID=CLTCHDRH.ID
LEFT JOIN CLSDCCH ON CELTCHF.MO=CLSDCCH.MO AND CELTCHF.ID=CLSDCCH.ID
LEFT JOIN CLSDCCH_ADM ON CELTCHF.ID=CLSDCCH_ADM.ID
LEFT JOIN CELLCCHDR ON CELTCHF.MO=CELLCCHDR.MO AND CELTCHF.ID=CELLCCHDR.ID
LEFT JOIN IDLEUTCHF ON CELTCHF.MO=IDLEUTCHF.MO AND CELTCHF.ID=IDLEUTCHF.ID
LEFT JOIN CELLGPRS ON IDLEUTCHF.MO=CELLGPRS.MO AND IDLEUTCHF.ID=CELLGPRS.ID
LEFT JOIN RANDOMACC ON CELTCHF.MO=RANDOMACC.MO AND CELTCHF.ID=RANDOMACC.ID
WHERE CELTCHF_ADM.TIME/*>= '2010-12-13 9:00'*/IN('2010-12-11 10:00') AND CELTCHF_ADM.NE LIKE '%WHBSC%' AND CELTCHF.MO LIKE '%W%'
ORDER BY CELTCHF_ADM.NE,CELTCHF.MO,CELTCHF_ADM.TIME;
»Ø´ðÕߣº
liuhao123
»Ø´ðʱ¼ä£º2011-09-03 19:25
15 13
ѧϰһÏÂ
»Ø´ðÕߣº
RFMSC
»Ø´ðʱ¼ä£º2011-09-05 00:47
11 13
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê
ÁªÏµÎÒÃÇ - ÎÊͨÐÅר¼Ò | Powered by MSCBSC Òƶ¯Í¨ÐÅÍø © 2006 - |