LZ很努力,我也要向LZ学习
一、嵌套一下
Select fID,fNo,GC=Max(GC),AJ=Max(AJ),FQ=Max(FQ),DK=Max(DK) From (Select a.fID,a.fNO,
(Case When left(b.fNO,2) = 'GC' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) GC,
(Case When left(b.fNO,2) = 'AJ' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) AJ,
(Case When left(b.fNO,2) = 'FQ' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) FQ,
(Case When left(b.fNO,2) = 'DK' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) DK
From
Archives a Left Join Contract b On a.fID = b.fArchivesID ) TB Group By fID,fNO
二、没什么问题吧?
再次向lz学习先进经验,呵呵
一、嵌套一下
Select fID,fNo,GC=Max(GC),AJ=Max(AJ),FQ=Max(FQ),DK=Max(DK) From (Select a.fID,a.fNO,
(Case When left(b.fNO,2) = 'GC' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) GC,
(Case When left(b.fNO,2) = 'AJ' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) AJ,
(Case When left(b.fNO,2) = 'FQ' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) FQ,
(Case When left(b.fNO,2) = 'DK' Then convert(varchar,b.fNO) + '||' + convert(varchar(10),b.fDate,21) Else '' end ) DK
From
Archives a Left Join Contract b On a.fID = b.fArchivesID ) TB Group By fID,fNO
二、没什么问题吧?
再次向lz学习先进经验,呵呵
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货