E11_Remarks是text,不能group by ,用方法cast。
select E11_PurchaseOrderID ,
E11_ItemID,
E11_ItemModel,
sum(E11_Qty) as E11_Qty,
E11_Manufacturer,
E11_WHID,
E11_UnitPrice,
E11_InStoreDate,
cast(E11_Remarks as varchar(4000)) as E11_Remarks,
E11_RsvedFld
from E11_ServiceItemStore
group by E11_PurchaseOrderID,
E11_ItemID,
E11_ItemModel,
E11_Manufacturer,
E11_WHID,
E11_UnitPrice,
E11_InStoreDate,
cast(E11_Remarks as varchar(4000)),
E11_RsvedFld