SELECT TOP 10 tag_id, tag_code, RFID, storage_stock_id, material_id, material_code, data_status, material_name, spec, model, factory_name, supplier_id, supplier_name, lot_number, valid_to_date, material_type, pack_id, unit_code, unit, pack_type, sub_unit_code, sub_unit, dept_name, sub_conversion_rate, conversion_rate, status, original_barcode, udi, create_time, min_material_code, insurance_id, insurance_spec_code, order_in_code, order_in_id, is_used FROM ( SELECT ROW_NUMBER ( ) OVER ( ORDER BY create_time DESC ) PAGE_ROW_NUMBER, tag_id, tag_code, RFID, storage_stock_id, material_id, material_code, data_status, material_name, spec, model, factory_name, supplier_id, supplier_name, lot_number, valid_to_date, material_type, pack_id, unit_code, unit, pack_type, sub_unit_code, sub_unit, dept_name, sub_conversion_rate, conversion_rate, status, original_barcode, udi, create_time, min_material_code, insurance_id, insurance_spec_code, order_in_code, order_in_id, is_used FROM ( SELECT mt.tag_id, mt.tag_code, mt.RFID, mt.storage_stock_id, mss.material_id, mss.material_code, mt.data_status, mi.material_name, mi.spec, mi.model, mi.factory_name, mss.supplier_id, mss.supplier_name, mt.lot_number, mt.valid_to_date, mi.material_type, mss.pack_id, mss.unit_code, CASE WHEN mi.material_type = 'MAT-GZ' THEN mp.pack_unit ELSE mt.unit + '(' + CONVERT ( VARCHAR ( 10 ), mtd.quantity ) + mtd.unit + '/' + mt.unit + ')' END AS unit, mp.pack_type, mss.sub_unit_code, mss.sub_unit, sd.dept_name, mp.sub_conversion_rate, mp.conversion_rate, mt.status, mt.original_barcode, mt.udi, mt.create_time, mi.min_material_code, mi.insurance_id, mi.insurance_spec_code, mssd.order_in_code, mssd.order_in_id, mt.is_used FROM material_tag mt LEFT JOIN material_tag_detail mtd ON mtd.tag_id = mt.tag_id LEFT JOIN material_storage_stock_detail mssd ON mssd.stock_detail_id = mtd.stock_detail_id LEFT JOIN material_storage_stock mss ON mss.stock_id = mssd.storage_stock_id LEFT JOIN material_pack mp ON mp.pack_id = mss.pack_id LEFT JOIN material_info mi ON mi.material_id = mss.material_id LEFT JOIN sys_dept sd ON sd.dept_id = mss.store_dept_id LEFT JOIN material_storage_stock_batch mssb ON mssb.stock_id = mss.stock_id LEFT JOIN order_in oi ON oi.order_in_code = mssb.batch_no LEFT JOIN material_pack mpk ON mpk.material_id = mss.material_id AND mpk.is_purchase_unit = 1 WHERE mt.hospital_id = 1 AND mss.store_dept_id = 367 ) AS PAGE_TABLE_ALIAS ) AS PAGE_TABLE_ALIAS WHERE PAGE_ROW_NUMBER > 0 ORDER BY PAGE_ROW_NUMBER查询速度19秒如何添加索引
814
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
