declare @t_Ord_e_id table (order_entry_id numeric(18,0) ,po_no numeric(18,0));
declare cur_ord_ent_id cursor for
select distinct order_entry_id from order_entry_details
declare @O_ent_id varchar(50);
declare @po_no varchar(60);
declare @po_no_concted varchar(100);
set @po_no_concted=''
open cur_ord_ent_id
fetch next from cur_ord_ent_id
into @O_ent_id
while @@FETCH_STATUS=0
begin
declare cur_po_no cursor for
select distinct po_no from order_entry_details where order_entry_id=@O_ent_id
open cur_po_no
fetch next from cur_po_no
into @po_no
while @@FETCH_STATUS=0
begin
set @po_no_concted=@po_no_concted+ ','+@po_no
print @po_no
print @po_no_concted
fetch next from cur_po_no
into @po_no
end
close cur_po_no
deallocate cur_po_no
insert into @t_Ord_e_id (order_entry_id,po_no)
values(@O_ent_id,@po_no_concted)
fetch next from cur_ord_ent_id
into @O_ent_id
end
close cur_ord_ent_id
deallocate cur_ord_ent_id
this worked for me .
it was because i needed to initialize @po_no_concted to @po_no_concted=''