TRY:select clientid,max(case maitaindate is null then cast(convert(char(11),singdate,120)+time as datetime) else maitaindate end) Newdate from b group by clientid
TRY: update a set col=bb.Newdate from a ,( select clientid,max(case maitaindate is null then cast(convert(char(11),singdate,120)+time as datetime) else maitaindate end) Newdate from b group by clientid)bb where a.id=b.clientid
update a set col=bb.Newdate from
a ,(
select clientid,max(case maitaindate is null then cast(convert(char(11),singdate,120)+time as datetime) else maitaindate end) Newdate from b group by clientid)bb where a.id=b.clientid
另外,我把time字段改称int了,只记月数,比如原来是1年,现在就是12。
col=1 or col = 0
case when maitaindate is null