TDJMQS保留测试SQL

INSERT INTO BillDetail_ZJK
            (kehu,rq,djbh,danwbh,spbh,shl,shl_kp,hshj,hshj_kp,hsje,hsje_kp,is_zx,beizhu_dj,beizhu_mx,time,spid,yuany,pihao,is_up,uptime)

SELECT '贵州大家康健(贵州)' AS kehu,a.rq,a.djbh,a.bendian AS danwbh
      ,c.spbh
      ,b.jlgg * b.diaocsl AS shl,b.jlgg * b.diaocsl AS shl_kp
      ,0 AS hshj,0 AS hshj_kp,0 AS hsje,0 AS hsje_kp
      ,'否' AS is_zx
      ,a.beizhu AS beizhu_dj,b.beizhu AS beizhu_mx
      ,CONVERT(CHAR(19),GETDATE(),120) AS TIME
      ,b.spid,'' AS yuany,'' AS pihao
      ,'N' AS is_up,'' AS uptime
FROM dbqhcrkhz AS a
     INNER JOIN dbqhcrkmx AS b ON a.djbh = b.djbh
     INNER JOIN spkfk AS c ON b.spid = c.spid
WHERE a.djbh='QHDZDA00047611  '