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 - 2005-05-06 : 07:51:53
|
| Michele writes "I need to run a query in SQL then attach the results into a text file (using the Scripting.FileSystemObject code) that can be designated as fixed width, and then email the text file. I am able to do this by creating a delimited text file and emailing it, but instead, I need the file to contain fixed fields. Thanks!" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-06 : 13:30:27
|
| If you're using the file system object I think you could do it if you converted each of your resulting columns into character fields using char()Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Creating Fixed Width Text File in Stored Procedure