Sql

create   procedure  dbo.communityAndWish
as
set  nocount  on
declare   @param1   varchar ( 20 ), @param2   varchar ( 20 ), @index   int
set   @index   =   1
create   table  #temptb1(
    ecardId  int   ,
    spaceName  varchar ( 50 )
)

declare  cur1  cursor   for   select  ecardId  from  ecard
declare  cur2  cursor   for   select   spaceName  from  community

open  cur1
open  cur2

fetch  cur2  into   @param2
fetch  cur1  into   @param1

while   @@FETCH_STATUS = 0
     begin
         insert   into  #temptb1(ecardId,spaceName)  values ( @param1 , @param2 )
         fetch   next   from  cur1  into   @param1
         fetch   next   from  cur2  into   @param2
     end
close  cur1
close  cur2

deallocate  cur1
deallocate  cur2
select   *   from  #temptb1
drop   table  #temptb1
go

execute  dbo.communityAndWish
drop   procedure  communityAndWish