出错有关问题

出错问题

SQL code

INSERT INTO RAresultA41           ([SegtID]           ,[Segtname]           ,[acctnobe]           ,[acctname]           ,[acctid]           ,[acctname2]           ,[Mtd201301]           ,[Mtd201302]           ,[Mtd201303]           ,[Mtd201204]           ,[Mtd201205]           ,[Mtd201206]           ,[Mtd201207]           ,[Mtd201208]           ,[Mtd201209]           ,[Mtd201210]           ,[Mtd201211]           ,[Mtd201212])  exec CrossTab'select b.acctid, a.SegtID, a.segtname, b.netpaid * -1 as netpaid, b.fiscaldateId, c.calendaryear, c.calendarmonth, c.fromDate, c.fromDateString, a.acctseqno, a.acctname, a.acctNoBefrom d_acctsegtType a inner join F_AccountEntry bon a.acctid = b.acctidand a.companyid = b.companyidinner join d_fiscaldate con b.fiscaldateId = c.fiscalDateIdand b.companyid = c.companyidwhere (a.segtid >=23 and a.segtid <=49)and a.CompanyID = 3and c.fiscaldateid >= 1 ','fromDateString', -- pivotCol'sum(netpaid)[]','SegtID,segtname,acctnobe,acctname,acctid','acctname','acctnobe'

Msg 8164, Level 16, State 1, Procedure CrossTab, Line 26
An INSERT EXEC statement cannot be nested.[/color[color=#008000]]----一个插入执行语句不可以嵌套。(74 row(s) affected)
上面语句能对相应的表插入数据,但出错的原因还是想知道

[解决办法]
EXEC 后面应该直接跟参数吧 你写的是查询语句。
[解决办法]
晕，你这什么语句？还有那个crosstab什么东西来的？
[解决办法]
这个是因为语法限制
所以报错
试试 OPENROWSET



EXEC('
INSERT INTO RAresultA41
SELECT a.*
FROM OPENROWSET(''MSDASQL'',''DRIVER={SQL Server}; SERVER=YourServerName; UID=sa; PWD=PASSWORD'', ''Exec CrossTab ''''select b.acctid, a.SegtID, a.segtname, b.netpaid * -1 as netpaid, b.fiscaldateId, c.calendaryear, 
c.calendarmonth, c.fromDate, c.fromDateString, a.acctseqno, a.acctname, a.acctNoBe
from d_acctsegtType a inner join F_AccountEntry b
on a.acctid = b.acctid
and a.companyid = b.companyid
inner join d_fiscaldate c
on b.fiscaldateId = c.fiscalDateId
and b.companyid = c.companyid
where (a.segtid >=23 and a.segtid <=49)
and a.CompanyID = 3
and c.fiscaldateid >= 1 '''',
 ''''fromDateString '''', -- pivotCol
 ''''sum(netpaid)[] '''',
 ''''SegtID,segtname,acctnobe,acctname,acctid '''',
 ''''acctname '''',
 ''''acctnobe '''''') AS a;
')

查看更多 下一篇