--建安
SELECT
---------------我想优化这里的SQL--------------------
---------------因为下面的这两句SQL是完全重复的-------
---------------看起来很难受-------------------------

CASE
when (select top 1 id
from report_da8d2d40c0a801f500f6178dadb40173 r2,report_project_step b1,report_project_step b2
where r2.businessid=b1.fid and b1.project=b2.project and rpt_uuid.businessid=b2.fid
and r2.alias=rpt_uuid.alias and r2.copy_alias=rpt_uuid.copy_alias) is null
THEN (select top 1 id
from report_da8d2d40c0a801f500f6178dadb40173 r2,report_project_step b1,report_project_step b2
where r2.businessid=b1.fid and b1.project=b2.project and rpt_uuid.businessid=b2.fid
and r2.alias=rpt_uuid.alias and r2.copy_alias=rpt_uuid.copy_alias)
-----------------------------------
ELSE rpt_uuid.ID
END AS "ID"
,ISNULL(
(select a.fid from t_project_survey a where a.fid=rpt_project_step.project)
,(select r.fid from t_project r where r.fid=rpt_project_step.project)
) as "项目ID"
,10 AS "类型"
,335 AS "状态"
,rpt_uuid.f4 as "建设内容"
,rpt_uuid.f5 as "单位"
,rpt_uuid.f6 as "建筑形式"
,rpt_uuid.f1 as "规模数量"
,rpt_uuid.f2 as "单价"
,rpt_uuid.f21 AS "备注"
,ROW_NUMBER() over(order by rpt_uuid.f1) as "序号"

FROM report_e3b88af8c0a801f50029bf4949f737de AS rpt_uuid
left join report_project_step as rpt_project_step on rpt_uuid.businessId=rpt_project_step.fid
WHERE
(
rpt_uuid.ALIAS = 'A'
OR rpt_uuid.copy_alias='A'
)
AND rpt_uuid.f4 <>''
AND rpt_project_step.project='4affaa2d44727a9f01448babf6b60d78'