新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 删除

if exists ( select * from sys.views where object_id = OBJECT_ID(N'dbo.a_ICFieldName') )
               drop     view                                         dbo.a_ICFieldName
   go

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_ICFieldName 金蝶老单 合并字段名称

create view dbo.a_ICFieldName
   as 
   select 
   
      b1.* 
      
      ,'【'+ b1.FID +'.'+  b1.FFieldName +' '+  b1.FCaption +'】'  FFullName
      
   from (
   ---------------------------------------------------------------------------------------------------------------------------------------------
      select FID,FBillName,FFieldName
      
            ,stuff(  ( 
            ----------------------------------------------------------------------------------------------------------------------
               select distinct ','+ FCaption2
                  
               from aICField where FID=a1.FID and FFieldName=a1.FFieldName
            ----------------------------------------------------------------------------------------------------------------------
             for xml path('')   )   ,1,1,'') FCaption
       
            ,stuff(  ( 
            ----------------------------------------------------------------------------------------------------------------------
               select ','+ CAST( FSort as varchar(10))
                  
               from aICField where FID=a1.FID and FFieldName=a1.FFieldName
               order by FSort
            ----------------------------------------------------------------------------------------------------------------------
             for xml path('')   )   ,1,1,'') FSort
       
      from aICField  a1
      
      group by FID,FBillName,FFieldName  
   ---------------------------------------------------------------------------------------------------------------------------------------------
   ) b1

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_ICFieldName  where FID = 'S01' and FFieldName LIKE '%%' order by FFieldName   -- 金蝶老单 合并字段名称
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go