存储过程函数中如何定义表变量，删除表变量内容

DECLARE @temp TABLE (
LaneNo VARCHAR(10),
L5 VARCHAR(10),
L8 VARCHAR(10),
L10 VARCHAR(10)
)
DECLARE @t TABLE (
车道 INTEGER,
速度等级 VARCHAR(10),
自动过车总数 INTEGER,
该速度过车数 INTEGER,
百份比 VARCHAR(10),
累计百分比 VARCHAR(10)
)
DECLARE @iLaneNo INTEGER
DECLARE @dtStart datetime
DECLARE @dtEnd datetime
SET @dtStart = '2013-06-01 00:00:00'
SET @dtEnd = '2013-06-30 23:59:59'
SET @iLaneNo = 0


declare cursor_test cursor local forward_only static read_only
 for
  select 车道号 from report06
open cursor_test

fetch next from cursor_test into @iLaneNo
while(@@fetch_status=0)
begin
insert INTO @t EXEC Proc_AutoPassSpeed @iLaneNo,@dtStart,@dtEnd 
INSERT INTO @temp 
SELECT 
@iLaneNo,
(SELECT 累计百分比 FROM @t WHERE 速度等级 = '5'),
(SELECT 累计百分比 FROM @t WHERE 速度等级 = '8'),
(SELECT 累计百分比 FROM @t WHERE 速度等级 = '10')
delete from @t                  -------清空表中的数据
fetch next from cursor_test into @iLaneNo
end
 
 close cursor_test
 deallocate cursor_test


SELECT * FROM @temp