新增文章

文章标题分类内容

select

b2.FEntryId

,stuff( ( select  ';'+ convert(nvarchar(100),FMaterialName)  from (
     -------------------------------------------------------------------------------------------------------------------------------------------
         select 
             a12.FMoEntryId
            ,b32.FName + (case when isnull(c11.FDataValue,'') = '' then '' else '('+ c11.FDataValue +')' end)  FMaterialName   -- 物料名称 + 规格

from       T_PRD_PPBomEntry            a12  
         left join  T_BD_Material_L             b32  on  b32.FMaterialId = a12.FMaterialId and b32.FLocaleId = 2052   -- 物料名称
         left join  T_BD_FlexsItemDetailv       c10  on  c10.FID         = a12.FAuxPropId                             -- 辅助属性
         left join  T_BAS_AssistantDataEntry_L  c11  on  c11.FEntryId    = c10.FF100001                               -- 规格 
      -------------------------------------------------------------------------------------------------------------------------------------------
       ) b1 where FMoEntryId = b2.FEntryId  order by FMoEntryId   for xml path('') ),1,1,'')  FMtrllNameSub
         
   from  T_PRD_MoEntry b2