问个存储问题，语法太不熟悉，请大家帮忙
传递一参数 返回一SQL查询
sql语句如下
select bdp_name,bdp_num,yqghsj,bdp_desc,(select '标项 '+rtrim((select count(distinct
bdp_fzid) from bid_detailed_plan where bdp_fzid <b.bdp_fzid)))
bx,bdp_fzid,a.bi_id,a.bi_endbmtime, ' ' flag from bid_item a inner join bid_detailed_plan b
on a.bi_id=b.bdp_pid where a.bi_id = '20070202131249 ' order by bdp_fzid
要传递bi_id参数
还要对上面SQL查询的纪录再操作
语法 好像INTO T 不太清楚
然后返回操作完的T
[解决办法]
create table #t(...)
insert into #t exec 存储过程名 参数列表
select * from #t
