declare @str1 varchar(max), @str2 varchar(max), @str3 varchar(max) 
set @str1 = 'iphone,华为,三星' 
select * into #tbu from [dbo].SplitString(@str1, ',', 1)
create table #uu(FNUMBER varchar(1000), wlmc varchar(1000),fname varchar(1000), FBASEQTY decimal(10,0))
while exists(select 1 from #tbu)
begin
select top 1 @str2=Value from #tbu
insert into #uu 
SELECT m.FNUMBER,ml.fname wlmc,TSL.fname,cast(sum(TI.FBASEQTY) as decimal(10,0)) FBASEQTY
FROM (select FBASEQTY,FSTOCKID,FMATERIALID,FSTOCKSTATUSID from T_STK_INVENTORY where FMATERIALID>1 and FBASEQTY<>0) TI 
inner JOIN (select fnumber,FMASTERID,FMATERIALID from T_BD_MATERIAL where FMASTERID>1) M ON M.FMATERIALID = TI.FMATERIALID 
inner JOIN (select FMATERIALID,FLOCALEID,fname from T_BD_MATERIAL_L where FMATERIALID>1) ML ON (M.FMASTERID = ML.FMATERIALID And ML.FLOCALEID = 2052) 
inner JOIN (select FSTOCKID,fname,FLOCALEID From T_BD_STOCK_L where FSTOCKID>1) TSL ON (TSL.FSTOCKID = TI.FSTOCKID AND TSL.FLOCALEID =2052) where ML.FName like '%'+@str2+'%'
group by ml.fname,m.FNUMBER,tsl.fname,TSL.fname 
order by 1

         delete from #tbu where value=@str2
         end

select distinct * From #uu 
drop table #uu,#tbu

本文转自51GT51CTO博客，原文链接：http://blog.51cto.com/yataigp/2049798 ，如需转载请自行联系原作者