为什么此查询单独运行,但是当我尝试将结果放入temp表
时,我会遇到错误作品
SELECT DISTINCT
ENCOUNTER_ID = OP.PAT_ENC_CSN_ID
,NOTE_TYPE = OP.PROC_CODE
,CREATE_TIME = OP.ORDER_INST
,OP.ORDER_PROC_ID
,EAP.PROC_NAME
-----INTO #ECHO_ORDERS
FROM PAT_ENC E
INNER JOIN #SER SER ON SER.PROV_ID = E.VISIT_PROV_ID
INNER JOIN ORDER_PROC OP ON OP.PAT_ENC_CSN_ID = E.PAT_ENC_CSN_ID
INNER JOIN CLARITY_EAP EAP ON EAP.PROC_ID = OP.PROC_ID
INNER JOIN EDP_PROC_CAT_INFO EDP ON EDP.PROC_CAT_ID = EAP.PROC_CAT_ID
WHERE (EAP.PROC_NAME LIKE '%ECHO%'
OR EDP.PROC_CAT_NAME LIKE 'ECH%')
AND EDP.PROC_CAT_NAME NOT IN ( 'CHG LABORATORY', 'LAB BLOOD ORDERABLES', 'PR GASTROENTEROLOGY', 'PR INJECTABLE MEDS', 'URINE ORDERABLES')
不起作用
if object_id('tempdb..#ECHO_ORDERS') is not null begin drop table #ECHO_ORDERS
SELECT DISTINCT
ENCOUNTER_ID = OP.PAT_ENC_CSN_ID
,NOTE_TYPE = OP.PROC_CODE
,CREATE_TIME = OP.ORDER_INST
,OP.ORDER_PROC_ID
,EAP.PROC_NAME
INTO #ECHO_ORDERS
FROM PAT_ENC E
INNER JOIN #SER SER ON SER.PROV_ID = E.VISIT_PROV_ID
INNER JOIN ORDER_PROC OP ON OP.PAT_ENC_CSN_ID = E.PAT_ENC_CSN_ID
INNER JOIN CLARITY_EAP EAP ON EAP.PROC_ID = OP.PROC_ID
INNER JOIN EDP_PROC_CAT_INFO EDP ON EDP.PROC_CAT_ID = EAP.PROC_CAT_ID
WHERE (EAP.PROC_NAME LIKE '%ECHO%'
OR EDP.PROC_CAT_NAME LIKE 'ECH%')
AND EDP.PROC_CAT_NAME NOT IN ( 'CHG LABORATORY', 'LAB BLOOD ORDERABLES', 'PR GASTROENTEROLOGY', 'PR INJECTABLE MEDS', 'URINE ORDERABLES')
我在运行不起作用的代码时收到有关最后一行代码的错误消息
Msg 102, Level 15, State 1, Line 222
Incorrect syntax near ')'.
如果正确格式化代码,很明显为什么您的代码不起作用。
if object_id('tempdb..#ECHO_ORDERS') is not null
begin
drop table #ECHO_ORDERS
SELECT DISTINCT
ENCOUNTER_ID = OP.PAT_ENC_CSN_ID
,NOTE_TYPE = OP.PROC_CODE
,CREATE_TIME = OP.ORDER_INST
,OP.ORDER_PROC_ID
,EAP.PROC_NAME
INTO #ECHO_ORDERS
FROM PAT_ENC E
INNER JOIN #SER SER ON SER.PROV_ID = E.VISIT_PROV_ID
INNER JOIN ORDER_PROC OP ON OP.PAT_ENC_CSN_ID = E.PAT_ENC_CSN_ID
INNER JOIN CLARITY_EAP EAP ON EAP.PROC_ID = OP.PROC_ID
INNER JOIN EDP_PROC_CAT_INFO EDP ON EDP.PROC_CAT_ID = EAP.PROC_CAT_ID
WHERE (EAP.PROC_NAME LIKE '%ECHO%' OR EDP.PROC_CAT_NAME LIKE 'ECH%')
AND EDP.PROC_CAT_NAME NOT IN (
'CHG LABORATORY', 'LAB BLOOD ORDERABLES', 'PR GASTROENTEROLOGY', 'PR INJECTABLE MEDS', 'URINE ORDERABLES'
)
您有BEGIN
,没有END
。