游标循环插入临时表

[微醺_zZ]

declare @Code uniqueidentifier
declare list cursor for select distinct Code from A
open list 
fetch next from list into @Code
while (@@ROWCOUNT>0)
begin
Select *  into #tbl From A
fetch next from list into @Code
end
close list
DEALLOCATE list 

游标执行一遍之后出现错误提示：数据库中已存在名为 '#tbl' 的对象。

请问，我想将每次游标循环查出来的数据都插入到这个临时表中该怎么做？

[让你望见影子的墙]

create table @tb1( ……)
declare @Code uniqueidentifier

declare list cursor for select distinct Code from A
open list 
fetch next from list into @Code
while @@fetch_status=0
begin
Select *   From A
fetch next from list into @Code
end
close list
DEALLOCATE list 

[水族杰纶]

create table  #tbl()
declare @Code uniqueidentifier
declare list cursor for select distinct Code from A
open list 
fetch next from list into @Code
while (@@ROWCOUNT>0)
begin
insert #tbl Select *   From A
fetch next from list into @Code
end
close list
DEALLOCATE list