这不是C#问题,是数据库问题,或许不是数据库问题, 只是个逻辑问题,featch in results { select 1990, 1991, 1992 into m_Amount1990, m_Amount1991, m_Amount1992 where *** = cur_line.*** and ***** = 'amount';
select 1990, 1991, 1992 into m_re1990, m_re1991, m_re1992 where *** = cur_line.*** and ***** = 're';
insert (1990,cur_line.***,m_Amount1990,m_re1990) into tab; insert (1991,cur_line.***,m_Amount1991,m_re1991) into tab; insert (1992,cur_line.***,m_Amount1992,m_re1992) into tab;
只是个逻辑问题,featch in results
{
select 1990,
1991,
1992
into m_Amount1990,
m_Amount1991,
m_Amount1992
where *** = cur_line.***
and ***** = 'amount';
select 1990,
1991,
1992
into m_re1990,
m_re1991,
m_re1992
where *** = cur_line.***
and ***** = 're';
insert (1990,cur_line.***,m_Amount1990,m_re1990) into tab;
insert (1991,cur_line.***,m_Amount1991,m_re1991) into tab;
insert (1992,cur_line.***,m_Amount1992,m_re1992) into tab;
}
这样做,会产生2条的1号,2号的重复纪录,自己解决,
也可能答的不是你想要的,那就是你没说明白。。
“存储过程”许多人只是随声附和,来蹭分的,
这种人最可恨。
你知道“存储过程” 与 SQL 的区别么?第一个说“存储过程” 得人不用回答,
因为他有理由,在后边乱叫得那些人!!