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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2009-11-10 : 10:58:04
|
| I am executing a script to get the required report in prod server. How to get that result into XL file?Please let me know the process, I am using sql 2005 version |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-11-10 : 11:31:51
|
| Well....some would say that you use SQL Server Integration Services (SSIS)Some might say to use Reporting ServicesI would say, if you can live with a csv file, then I would tell you to either write a query or create a view and bcp the data outCan you post the script you are talking aboutBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
|
|
|
Sql select statement results to XL