新增文章

文章标题分类内容

文本拼接

declare @FID_Src varchar(max) = '' 
   
select @FID_Src = @FID_Src +','+ CONVERT(varchar(20),FID_SRC) from a_SeAlterEntry where FID = 1002 
select SUBSTRING(@FID_Src, 2, LEN(@FID_Src) - 1)

-------------------------------------------------------------------------------------------------------------------------------------------
   SELECT * FROM ICChatBillTitle WHERE FTypeID = 61 ORDER BY FInterID
      
   SELECT FTypeID ,STUFF( ( SELECT CONVERT(nvarchar(100),FColName) +' '+ CONVERT(nvarchar(100),FColCaption) +' ,'
                   FROM ICChatBillTitle WHERE FTypeID = a1.FTypeID
                   ORDER BY FInterID
                   FOR XML PATH('') ),1,0,'')
         
   FROM ICChatBillTitle  a1
   WHERE FTypeID   = 61 
   GROUP BY FTypeID

-- 结果 Fdate 制单日期 ,FCustIDName 购货单位 ,FSaleStyleName 销售方式 ,

-------------------------------------------------------------------------------------------------------------------------------------------
   select

FEntryId 
      ,STUFF( ( select  ';'+ CONVERT(nvarchar(100),FName)  from (
       -------------------------------------------------------------------------------------------------------------------------------------------
         select     a1.FPkId ,a1.FEntryId ,a2.FName 
         from       PAEZ_TSGY            a1
         left join  WGDP_t_Cust100001_L  a2  on a2.FID = a1.F_PAEZ_TSGY   -- 特殊工艺
       -------------------------------------------------------------------------------------------------------------------------------------------
       ) b1 where FEntryId = b2.FEntryId  order by FPkId   for xml path('') ),1,1,'')
         
   from (
   -------------------------------------------------------------------------------------------------------------------------------------------
      select     a1.FPkId ,a1.FEntryId ,a2.FName 
      from       PAEZ_TSGY            a1
      left join  WGDP_t_Cust100001_L  a2  on a2.FID = a1.F_PAEZ_TSGY   -- 特殊工艺
   -------------------------------------------------------------------------------------------------------------------------------------------
   ) b2   group by FEntryId