- 博客(7)
- 收藏
- 关注
RSS订阅原创 111111
SELECT C1.product_cd,I1.finish_datetime,C1.mecha_no,serial_no,A1.team_cd,A1.process_cd,H1.parts_cd,H1.parts_name_chn,count(h1.parts_cd) as QTY,I1.LotNo,‘’ as ‘result’,I1.remark,‘’ as ‘JigNo’,(select top 1 worker_id from T_worker_result as f where c1.mecha
2022-08-16 17:03:38
34
原创 优化结果4
select xx.product_cd, xx.finish_datetime, xx.mecha_no, xx.serial_no, xx.team_cd, xx.process_cd, xx.parts_cd,xx.parts_name_chn, xx.QTY, xx.LotNo, xx.result, xx.remark, xx.JigNo, xx.worker_id from ( select distinct c1.product_cd, i1.finish_datetime, c1.mecha
2022-08-16 16:07:14
29
原创 优化结果3
select xx.product_cd, xx.finish_datetime, xx.mecha_no, xx.serial_no, xx.team_cd, xx.process_cd, xx.parts_cd,xx.parts_name_chn, xx.QTY, xx.LotNo, xx.result, xx.remark, xx.JigNo, xx.worker_id from ( select distinct c1.product_cd, i1.finish_datetime, c1.mecha
2022-08-16 15:18:39
32
原创 优化结果2
select distinct c1.product_cd, i1.finish_datetime, c1.mecha_no, c1.serial_no, a1.team_cd, a1.process_cd, h1.parts_cd, h1.parts_name_chn, count(h1.parts_cd) as QTY, i1.parts_lot as ‘LotNo’, ‘’ as ‘result’, i1.remark, ‘’ as ‘JigNo’, (select top 1 worker_id f
2022-08-16 15:16:57
49
原创 测试优化结果
select distinct c1.product_cd, i1.finish_datetime, c1.mecha_no, c1.serial_no, a1.team_cd, a1.process_cd, h1.parts_cd, h1.parts_name_chn, count(h1.parts_cd) as QTY, i1.parts_lot as ‘LotNo’, ‘’ as ‘result’, i1.remark, ‘’ as ‘JigNo’, (select top 1 worker_id f
2022-08-16 15:11:46
43
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人