R
raymond chiu
Dear all,
I need your help again.
I have one question in dot net.
If I have withdraw the data which will be exported into different excel
file, separated by different customer, and saved in the same folder of
another computer. What the syntax should be??
----------------------------------------------------------------------------------------
select count(distinct customer) into record_count from table 1;
insert into table2 select customer from table1 group by customer;
Loop for each customer
select * from table1 where customer='123456Customer'
get the excel
write to the excel
saved in the folder path and named as '123456customer.xls'
end loop;
I need your help again.
I have one question in dot net.
If I have withdraw the data which will be exported into different excel
file, separated by different customer, and saved in the same folder of
another computer. What the syntax should be??
----------------------------------------------------------------------------------------
select count(distinct customer) into record_count from table 1;
insert into table2 select customer from table1 group by customer;
Loop for each customer
select * from table1 where customer='123456Customer'
get the excel
write to the excel
saved in the folder path and named as '123456customer.xls'
end loop;