SELECT ROW_NUMBER()OVER(ORDER BY p.ID) xuhao,BelongedTo,RecordNumber,
        BelongsDepartments,ProjectName,ProjectAddress,
        dbo.Fun_RetSanFangUnitInfoByRecordNumberAndBelongedTo(RecordNumber,'施工单位',BelongedTo) AS SGDW,
        dbo.Fun_RetSanFangUnitInfoByRecordNumberAndBelongedTo(RecordNumber,'建设单位',BelongedTo) AS JSDW, 
        dbo.Fun_RetSanFangUnitInfoByRecordNumberAndBelongedTo(RecordNumber,'监理单位',BelongedTo) AS JLDW,
        ProjectPrice,ProjectStartDateTimne,
        ProjectEndDateTimne,(CASE WHEN WhetherToStartLBS IS NULL THEN '否' ELSE '是' end) WhetherToStartLBS ,
        GroupName,ProjectArea,ProjectCategory,ProjectTarget,
        (CASE WHEN RemoteMonitorAccord IS NULL THEN '否' ELSE '是' end) RemoteMonitorAccord,
        RecordDate,(CASE WHEN FactCompletionDate IS NULL THEN '未竣工' ELSE '已竣工' end) ProjectState
         FROM dbo.ProjectOverview AS p
         LEFT JOIN V_WorkflowHandledListDistinct AS v ON  p.BelongedTo+'&'+p.RecordNumber = v.orderId
         WHERE workflowType='AnJianBeiAnSQ' AND 
         formResourceName='AnJianBeiAnSQ_003' 
         AND handleResult='通过' OR p.Remark IS NULL

ALTER function [dbo].[Fun_RetSanFangUnitInfoByRecordNumberAndBelongedTo]
(@RecordNumber varchar(50),@EnterpriseType varchar(100),@BelongedTo VARCHAR(50)
)
returns varchar(500)
as 
Begin
declare @RetUnitName varchar(500)
select @RetUnitName=EnterpriseName from ProjectEntSnapshot where RecordNumber=@RecordNumber AND BelongedTo=@BelongedTo
and EnterpriseType=@EnterpriseType and MainUnit='是'
    return @RetUnitName
end