是你的小熊(提问者)select top 1 ZYRQ,SG,BZ,SYXH
into #xx
from NIS..NMR_TWD (nolock)
where convert(varchar(100),SYXH)='${syxh}'
and ISNUMERIC(convert(varchar,BZ))=1
and convert(varchar(100),SG)<>''
and convert(varchar(100),BZ)<>''
ORDER BY ZYRQ DESC
union
SELECT
MAX(CASE WHEN VITALSIGNNAME = '身高' THEN VITALSIGNNVAL1 ELSE NULL END) AS SG,
MAX(CASE WHEN VITALSIGNNAME = '体重' THEN VITALSIGNNVAL1 ELSE NULL END) AS BZ,
NULL AS ZYRQ,NULL AS SYXH
FROM ats_order.vitalsignsinformation
WHERE
VITALSIGNNAME IN ('身高', '体重')
AND ADMINISSIONNO = '${syxh}'
AND ROWNUM <= 2
ORDER BY UPDATETIME ASC
select * from #xx (nolock) 报错from keyword not found where wxpected