怎么把SQL2000两次导入到TXT的数据叠加起来一个TXT文件里有两个数据集。。
SET @Sql='bcp "SELECT YHDBDH,COUNT(A.DAH) AS DAH, SUM(CONVERT(NUMERIC(18, 2), C.ZJE)) AS ZJE,b.xqh,A.DBBH FROM jd_Gas.dbo.T_YHDAB A INNER JOIN jd_Gas.dbo.T_BCXXB B ON A.dbbh = B.dbbh INNER JOIN jd_Gas.dbo.T_CBJLB C ON A.DAH = C.DAH where 1=1 AND A.DBBH='''+@VDBBH+''' AND a.sffs=''银行代扣''and c.cbyf='''+@VCBYF+''' GROUP BY b.xqh,A.DBBH,YHDBDH" queryout c:\'+@VCBYF+'\'+@VCBYFR+'\'+@VFILENAME+'.txt -c -t"|" -U"sa" -P"sa"'
EXEC master..xp_cmdshell @Sql SET @Sql1='bcp "SELECT A.YHZH, B.YHMC, C.ZJE, B.DAH ,B.YHMC FROM jd_Gas.dbo.T_BCXXB D INNER JOIN jd_Gas.dbo.T_YHDAB B ON D.DBBH=B.DBBH INNER JOIN jd_Gas.dbo.T_YHDKYHZL A ON A.DAH=B.DAH INNER JOIN jd_Gas.dbo.T_CBJLB C ON B.DAH = C.DAH AND A.DAH = C.DAH where 1=1 AND c.cbyf='''+@VCBYF+''' and B.DBBH='''+@VDBBH+''' AND B.SFFS = ''银行代扣''" queryout c:\'+@VCBYF+'\'+@VCBYFR+'\'+@VFILENAME+'.txt -c -t"|" -U"sa" -P"sa"'
EXEC master..xp_cmdshell @Sql1 这第二个会覆盖掉第一个。。怎么实现,第二个的数据加到第一个后面啊
第一个数据集数据
YHDBDH DAH ZJE XQH DBBH
001 3 176.40 3510000094 AG1111 第二个数据集数据
YHZH YHMC ZJE CBYF DAH YHDBDH DBBH XH
126345879654241 黄琼 58.80 200906 001 001 AG1111 111
496846513248964 溜溜 58.80 200906 002 001 AG1111 02
476496841653185 丽丽 58.80 200906 003 001 AG1111 01
我要实现的效果是把这两个数据一起导入到TXT
001 3 176.40 3510000094 AG1111 126345879654241 黄琼 58.80 200906 001 001 AG1111 111
496846513248964 溜溜 58.80 200906 002 001 AG1111 02
476496841653185 丽丽 58.80 200906 003 001 AG1111 01
SET @Sql='bcp "SELECT YHDBDH,COUNT(A.DAH) AS DAH, SUM(CONVERT(NUMERIC(18, 2), C.ZJE)) AS ZJE,b.xqh,A.DBBH FROM jd_Gas.dbo.T_YHDAB A INNER JOIN jd_Gas.dbo.T_BCXXB B ON A.dbbh = B.dbbh INNER JOIN jd_Gas.dbo.T_CBJLB C ON A.DAH = C.DAH where 1=1 AND A.DBBH='''+@VDBBH+''' AND a.sffs=''银行代扣''and c.cbyf='''+@VCBYF+''' GROUP BY b.xqh,A.DBBH,YHDBDH" queryout c:\'+@VCBYF+'\'+@VCBYFR+'\'+@VFILENAME+'.txt -c -t"|" -U"sa" -P"sa"'
EXEC master..xp_cmdshell @Sql SET @Sql1='bcp "SELECT A.YHZH, B.YHMC, C.ZJE, B.DAH ,B.YHMC FROM jd_Gas.dbo.T_BCXXB D INNER JOIN jd_Gas.dbo.T_YHDAB B ON D.DBBH=B.DBBH INNER JOIN jd_Gas.dbo.T_YHDKYHZL A ON A.DAH=B.DAH INNER JOIN jd_Gas.dbo.T_CBJLB C ON B.DAH = C.DAH AND A.DAH = C.DAH where 1=1 AND c.cbyf='''+@VCBYF+''' and B.DBBH='''+@VDBBH+''' AND B.SFFS = ''银行代扣''" queryout c:\'+@VCBYF+'\'+@VCBYFR+'\'+@VFILENAME+'.txt -c -t"|" -U"sa" -P"sa"'
EXEC master..xp_cmdshell @Sql1 这第二个会覆盖掉第一个。。怎么实现,第二个的数据加到第一个后面啊
第一个数据集数据
YHDBDH DAH ZJE XQH DBBH
001 3 176.40 3510000094 AG1111 第二个数据集数据
YHZH YHMC ZJE CBYF DAH YHDBDH DBBH XH
126345879654241 黄琼 58.80 200906 001 001 AG1111 111
496846513248964 溜溜 58.80 200906 002 001 AG1111 02
476496841653185 丽丽 58.80 200906 003 001 AG1111 01
我要实现的效果是把这两个数据一起导入到TXT
001 3 176.40 3510000094 AG1111 126345879654241 黄琼 58.80 200906 001 001 AG1111 111
496846513248964 溜溜 58.80 200906 002 001 AG1111 02
476496841653185 丽丽 58.80 200906 003 001 AG1111 01
我第二个数据集会覆盖掉第一个数据集的数据啊。