【資料名稱】：nsn sql腳本

【資料作者】：yuan

【資料日期】：2013-7-20

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡介】：

SELECT
C.NAMEBSC,
B.LA_ID_LACLAC,
B.CELL_IDCI,
B.SEGMENT_IDSEG,
A.ADJ_CELL_LACA_LAC,
A. ADJ_CELL_CIA_CI,
--e.SEGMENT_ID,
A.ADJC_INDEXA_index,
A.ADJ_CELL_BSIC_NCC A_NCC,
A.ADJ_CELL_BSIC_BCC A_BCC,
A.ADJ_CELL_BCCH_FREQUENCY A_FREQ,
A.RX_LEV_MIN_CELL-110SL,
A.SYNCHRONIZEDSYNC,
A.ADJ_CELL_LAYER ACL,
A.HO_LEVEL_UMBRELLA AUCL,
A.HO_MARGIN_PBGT PMRG,
A.HO_MARGIN_LEVLMRG,
A.HO_MARGIN_QUAL QMRG,
A.MS_PWR_OPT_LEVEL-110 POPT,
A.DR_THRESHOLD-110 DRT,
--E.LA_ID_LAC,
--E.BSIC_NCC,
--E.BSIC_BCC,
--F.INITIAL_FREQUENCY ,
--E.LA_ID_LAC-A.ADJ_CELL_LAC,
--E.BSIC_NCC-A.ADJ_CELL_BSIC_NCC,
--E.BSIC_BCC-A.ADJ_CELL_BSIC_BCC,
--F.INITIAL_FREQUENCY -A.ADJ_CELL_BCCH_FREQUENCY

FROM
C_ADJACENT_CELL A,
C_BTS B,
OBJECTS C,
OBJECTS D
--c_bts e,
--C_TRX F
WHERE
A.BTS_INT_ID=B.INT_ID
AND C.INT_ID=B.BSC_INT_ID
AND A.INT_ID=D.INT_ID
--and a.ADJ_CELL_INT_ID=e.int_id
--AND E.BCCH_TRX_INT_ID=F.INT_ID
and b.conf_name = '<ACTUAL>'
AND (C.name like '**%')
--and B.cell_id in (38041)
and A. ADJ_CELL_CI in (63052)