Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pvsramu
Starting Member
17 Posts |
 Posted - 2009-02-05 : 11:16:51
|
| Hi,I have a query, which gets the resultset of the CUSTOMERS. And, need to loop through each CUSTOMER row and load it into excel sheet. If the customer registered in January then insert into January SHEET, its its February then insert into February SHEET, like that.At the end, I need to create EXCEL sheet with 12 sheets with customer data, each sheet for every month.Please let me know how best we can achieve this...Thanks,Ramu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-05 : 12:37:04
|
| cant you use OPENROWSET for this? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
looping question