22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM dbo.S_MRP_Part
SELECT * FROM dbo.S_MRP_DayCounts
declare @sql varchar(8000)
set @sql = 'select a.hid,b.Part '
select @sql = @sql + ' , max(case when MRPDate=''' + MRPDate + ''' then Counts else null end) [' + MRPDate + ']'
from S_MRP_DayCounts
set @sql = @sql + ' from S_MRP_DayCounts a,S_MRP_Part b where a.hid=b.id group by a.hid,b.Part'
exec(@sql)