22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE SHE_Colorodr
@dxcode varchar(1000)
AS
begin
Select a.Cdxcodeguid,
Color =
Substring(a.Color,
b.Number,
Charindex('/', a.Color + '/', b.Number) - b.Number),
a.Ordersqty,
a.Prname1,
a.Prname2,
a.Prname3,
a.Prname4,
a.Prname5,
a.Prname6,
a.Prname7,
a.Prname8,
a.Prname9,
a.Prname10
into #tem
From (
Select a.Cdxcodeguid, b.*
From (Select Guid, Color,Prname1,
Prname2,
Prname3,
Prname4,
Prname5,
Prname6,
Prname7,
Prname8,
Prname9, Prname10,Sum(Ordersqty) As Ordersqty
From Om_Modetails
Group By Guid,
Color,
Prname1,
Prname2,
Prname3,
Prname4,
Prname5,
Prname6,
Prname7,
Prname8,
Prname9,
Prname10) b,
Om_Momain a
Where a.Guid = b.Guid and a.cdxcode in(@dxcode)-------------------这个无效
) a
Join Master .. Spt_Values b On b.Type = 'p'
And b.Number Between 1 And Len(a.Color)
Where Substring('/' + a.Color, b.Number, 1) = '/'
end