|
下面为具体解决方式：
（1）新建一张数据库表，用来存参数，如下图
（2）将参数入参数表，入时要注意不要按行入要按列入。
（3）将存储过程的查询结果与该表进行关联
注：要重点注意判空操作，在经过我的分析后，决定用下图方式进行处理
SELECT A.* FROM MHP_OEE.RESRCE AS A INNER JOIN MHP_OEE.TABLE_FOR_PARAMETER AS B ON A.RESRCE = B.RESRCE
WHERE (A.RESRCE = B.RESRCE and (select count(C.RESRCE) from MHP_OEE.TABLE_FOR_PARAMETER AS C WHERE C.LINE_AREA is not null )>0 )
OR (1 = 1 and (select count(C.RESRCE) from MHP_OEE.TABLE_FOR_PARAMETER AS C WHERE C.LINE_AREA is not null )=0 )
| 
转播
