存储过程数据集的问题**

kcyjy

select a.Id, a.FlowFlag, a.BillNO, a.BillType, a.BillDate, a.SendCompany, a.SendDept, a.ProjectNO, a.ProjectName,
a.ParticularNeed, a.accessory,
a.ConsignDesignCompany, a.CorrelationalInfoSupllyDate,
a.AskFinishDate, a.RelationPerosn,
a.PhoneNO, a.e_mail, a.BillMaker,
a.SendCompanyLeaderIfAudit, a.SendDeptLeader,
a.SendDeptLeaderOpinion, a.SendDeptLeaderSignDate,
a.SendCompanyLeader, a.SendCompanyLeaderOpinion,
a.SendCompanyLeaderSignDate, a.ProjectManageDeptSigner,
a.ProjectManageDeptOponion, a.ProjectManageDeptSignDate,
a.ReceiveCompanyLeaderIfAudit, a.ReceiveCompanyLeader,
a.ReceiveCompanyLeaderOpinion, a.ReceiveCompanyLeaderSignDate,
a.accessoryName,
case when sum(d.ReceiveFlag)=count (d.ReceiveFlag)then '完成' else '未完成' end stat  from(
(select * from PM_DesignTaskRequisitionInOrout)a  left join  (select* from PM_DesignTaskDutyDeptDispose) b on b.fid= a.Id
left join (select * from PM_DesignTaskDutyOfficeList) c on c.fid=b.id left join (select * from PM_DesignTaskDuterList)d on d.fid=c.id)
where a.SendDept=_SendDept and a.BillType=_BillType and a.BillDate>_StartTime and a.BillDate<=_EndTime

group by a.Id, a.FlowFlag, a.BillNO, a.BillType, a.BillDate, a.SendCompany, a.SendDept, a.ProjectNO, a.ProjectName,
a.ParticularNeed, a.accessory,
a.ConsignDesignCompany, a.CorrelationalInfoSupllyDate,
a.AskFinishDate, a.RelationPerosn,
a.PhoneNO, a.e_mail, a.BillMaker,
a.SendCompanyLeaderIfAudit, a.SendDeptLeader,
a.SendDeptLeaderOpinion, a.SendDeptLeaderSignDate,
a.SendCompanyLeader, a.SendCompanyLeaderOpinion,
a.SendCompanyLeaderSignDate, a.ProjectManageDeptSigner,
a.ProjectManageDeptOponion, a.ProjectManageDeptSignDate,
a.ReceiveCompanyLeaderIfAudit, a.ReceiveCompanyLeader,
a.ReceiveCompanyLeaderOpinion, a.ReceiveCompanyLeaderSignDate,
a.accessoryName

x3版本中把上面的写在标准数据集后确定就会报错，于是我把上面的写到存过里面用存过数据集调用，但是产生2个问题第一个就是这个数据集跟其他的是主从关系，这个是主表，第2个问题就是有多个字段是定义了查找属性的。存过数据集这两个问题怎么解决？

jiahaiming

可以定义成视图，在平台中映射一张逻辑表。

kcyjy

我用到了参数，试图可以用参数的么？

zfang

楼主，你说的参数是指？说明一下。

jiahaiming

视图不需要参数，把它当作表用就可以