更新时间2018-03-06 21:33:55
如果是sqlserver ,用 isnull,如果是oracle,用nvl,mysql则用 ifnull
1234UPDATE A set BYZD10 =(isnull(SELECT distinct(JF) FROM B where VIPBH=V_VIPSET.DM and fx='增加' and LX='99-期末'),0)+(isnull(SELECT distinct(JF) FROM B where VIPBH=V_VIPSET.DM and fx='增加' and LX='00-期初'),0))干脆先把所有列都隐藏了,然后在循环判断,遇到有数字的就解除隐藏,你看行不行:
12345678910111213Private Sub Worksheet_Activate()Dim i,j'隐藏for j=1 to 100 Columns(j).Hidden = Truenext j'显示For i = 2 To [a65536].End(xlUp).Row for j=1 to 100 if cells(i,j)<>"" then Columns(j).Hidden = False next jNextEnd Sub委外材料使用情况表