SP_EXECUTE_SQL('insert into jy_xjyxgs(xjmc00,yxgs00,flag00,tjlb00) select  zwmc00,count(distinct YBH000||PYRQ00||ZWMC00) YXGS00,4,''4'' from VW_JY_XJJG00 where  BGRQ00 between '''||PKSRQ00||''' and  '''||PJSRQ00||''''||
                 '  and SFYXXJ=''Y'' and (SQKS00='||PKSBH00||' or '||PKSBH00||'=0) and  (MZZYBZ='''||PMZZYBZ||''' or '''||PMZZYBZ||'''=''2'')  and (BBMC00= nvl('''||PBBMC00||''',BBMC00)) '||
                 ' AND KSSID0 IS NOT NULL AND (YMJG00 IS NOT NULL OR YMJGKB IS NOT NULL OR YMSM00 IS NOT NULL) group by zwmc00');