22,207
社区成员
发帖
与我相关
我的任务
分享
exec('select *
,(select top 1 ERP_OrderList.SalePrice from ERP_Order with(nolock) inner join ERP_OrderList with(nolock) on ERP_Order.OrderID=ERP_OrderList.OrderID where ERP_Order.FunctionID=228 and ERP_Order.OrderOddNumber=TempTable.WareStockFree1 and ERP_OrderList.WareID=TempTable.WareID and ERP_OrderList.OrderListFree4=TempTable.CheckOddNumber) as 销售单价
from TempTable where isnull(EndStockNumber,0)<>0')
select c.WareStockFree1,c.WareID,c.CheckOddNumber,max(b.SalePrice) 'SalePrice'
from ERP_Order(nolock) a
inner join ERP_OrderList(nolock) b on a.OrderID=b.OrderID
inner join (select * from TempTable(nolock)
where isnull(EndStockNumber,0)<>0) c
on a.OrderOddNumber=c.WareStockFree1 and b.WareID=c.WareID and b.OrderListFree4=c.CheckOddNumber
where a.FunctionID=228
group by c.WareStockFree1,c.WareID,c.CheckOddNumber
[/quote]
你这样歪曲我愿意了,我不可能只返回这几列的
select c.WareStockFree1,c.WareID,c.CheckOddNumber,max(b.SalePrice) 'SalePrice'
from ERP_Order(nolock) a
inner join ERP_OrderList(nolock) b on a.OrderID=b.OrderID
inner join (select * from TempTable(nolock)
where isnull(EndStockNumber,0)<>0) c
on a.OrderOddNumber=c.WareStockFree1 and b.WareID=c.WareID and b.OrderListFree4=c.CheckOddNumber
where a.FunctionID=228
group by c.WareStockFree1,c.WareID,c.CheckOddNumber