SELECT
-- OrderNo 数据分组条件
OrderNo,
LEFT ( MAX( InDate ), 10 ) AS InDate,
-- MAX 只是不想让它参与分组条件
MAX( WarehouseCode ) WarehouseCode,
MAX( WarehouseName ) WarehouseName,
MAX( OuterId ) OuterId,
MAX( ProductName ) ProductName,
MAX( BatchNo ) BatchNo,
-- ErpQuantity 实际想聚合出来的数据
SUM( ErpQuantity ) ErpQuantity,
MAX( ChildId ) ChildId,
MAX( ErpUnitName ) ErpUnitName,
MAX( State ) State
FROM
[Awms49Uat].[dbo].[InOrderItemsView]
WHERE
State >= 2
AND Category = 0
AND InDate >= DATEADD ( mm, DATEDIFF( mm, 0, getdate ( ) ) - 1, 0 )
AND InDate < DATEADD ( mm, DATEDIFF( mm, 0, getdate ( ) ), 0 )
GROUP BY
OrderNo