liudongcj 2021-06-30 15:04 采纳率: 33.3%
浏览 24
已采纳

请各位帮我看看代码的问题。

---生成材料出库单主表数据 insert into rdrecord11(VT_ID,cPsPcode,cMPoCode,iproorderid,iMQuantity,ID,bRdFlag,cVouchType,cBusType,cSource,cWhCode,dDate,cCode, cRdCode,cDepCode,cHandler,cMaker,dVeriDate,dnmaketime,dnverifytime,iverifystate,iswfcontrolled,cModifyPerson, bpufirst,biafirst,bIsSTQc,bOMFirst,bFromPreYear,bIsComplement,iDiscountTaxType,ireturncount,bTransFlag, bredvouch,bmotran,bHYVouch,iPrintCount,csysbarcode,cCheckSignFlag) select '65' VT_ID,b.InvCode cPsPcode,c.MoCode cMPoCode,c.MoId iproorderid,b.Qty iMQuantity, case when (select MAX(ID) from ( select isnull(MAX(ID),0) ID from rdrecord11 union all select isnull(MAX(ID),0) ID from rdrecord10 union all select isnull(MAX(ID),0) ID from rdrecord09 union all select isnull(MAX(ID),0) ID from rdrecord01 union all select isnull(MAX(ID),0) ID from rdrecord08 union all select isnull(MAX(ID),0) ID from rdrecord32 union all select isnull(MAX(ID),0) ID from rdrecord34) a )=0 then 1000000000+ROW_NUMBER() over (order by b.moid) else (select MAX(ID) from ( select isnull(MAX(ID),0) ID from rdrecord11 union all select isnull(MAX(ID),0) ID from rdrecord10 union all select isnull(MAX(ID),0) ID from rdrecord09 union all select isnull(MAX(ID),0) ID from rdrecord01 union all select isnull(MAX(ID),0) ID from rdrecord08 union all select isnull(MAX(ID),0) ID from rdrecord32 union all select isnull(MAX(ID),0) ID from rdrecord34) a )++ROW_NUMBER() over (order by b.moid) end ID,0 bRdFlag,'11' cVouchType,'领料' cBusType,'生产订单' cBusType, a.whcode cWhCode, ---仓库默认01 d.StartDate ddate, ---制单日期,取生产订单开工日期 case when (select isnull(MAX(ccode),'') from rdrecord11)='' then right(10000000000+ROW_NUMBER() over (order by b.moid),10) else right(10000000000+(select isnull(MAX(ccode),0) from rdrecord11)+ROW_NUMBER() over (order by b.moid),10) end ccode, ---单据号 '04' cRdCode, ----出库类别,材料出库'21' b.MDeptCode cDepCode, ---部门,取生产订单部门 '汪沛' cHandler,----审核人 '周炯' cMaker,----制单人 d.StartDate dVeriDate, ---审核日期,与制单日期一致 d.StartDate+0.46 dnmaketime, ---制单时间 d.StartDate+0.65 dnverifytime, ---审核时间 0 iverifystate,0 iswfcontrolled,'' cModifyPerson, 0 bpufirst,0 biafirst,0 bIsSTQc,0 bOMFirst,0 bFromPreYear,0 bIsComplement,0 iDiscountTaxType,0 ireturncount,0 bTransFlag, 0 bredvouch,0 bmotran,0 bHYVouch,0 iPrintCount, '||st11|'+case when (select isnull(MAX(ccode),'') from rdrecord11)='' then right(10000000000+ROW_NUMBER() over (order by b.moid),10) else right(10000000000+(select isnull(MAX(ccode),0) from rdrecord11)+ROW_NUMBER() over (order by b.moid),10) end csysbarcode, ----单据号条码 null cCheckSignFlag from mom_orderdetail b left join mom_order c on b.MoId=c.MoId left join mom_morder d on b.MoId=d.MoId
left join mom_moallocate a on b.ModId=a.ModId where d.StartDate >='2019-01-01 00:00:00' and d.StartDate <='2019-01-01 00:00:00' and a.whcode = 'hs034'

正确的执行结果应该是会生成198条记录,但是现在执行出来的结果是3366.我看了一下每个结果都有重复了17次,正常应该只有一条数据,请大神帮我看看问题出来哪里了。

  • 写回答

3条回答 默认 最新

  • Null_Reference 2021-06-30 16:15
    关注

    这个你要看一下你的查询语句,查询出来的数据肯定是重复了(联表条件满足出现了一对多的数据),根据你具体的业务用distinct 或者 group by 去重

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码