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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-17 : 14:13:15
|
| Vincent writes "Hi SQL Team,I need to write a SQL Server 2000 stored procedure (Windows 2000 server SP2) in which,Query a database, manipulate the result, create/open a flat file , write the manipulated query result into the file (in specific format), close the file. Please let me know if there is any sample or how to go aboutdoing this.Thanks and RegardsVincent" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-17 : 14:15:03
|
Don't take this the wrong way Vincent, but if this is a homework assignment, sorry, but we won't do it for you.Take a look in SQL Server Books Online under "bcp" and "DTS", they'll give you some ideas, and they'll be some sample code that you can modify.Also do a forum search on SQL Team, you'll probably find something  |
 |
|
|
|
|
|
Microsoft 2000 - Stored procedure example for open, close and writing to a file