存储过程中的动态参数应该如何实现？

[GDTOPONE]

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

[dawugui]

a.cdxcode in(@dxcode)

--->

charindex(a.cdxcode , @dxcode) > 0

charindex('你的符号例如/' + a.cdxcode + '你的符号例如/', '你的符号例如/' + @dxcode + '你的符号例如/') > 0