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 |
|
Kwisatz
Starting Member
14 Posts |
 Posted - 2008-11-24 : 08:37:36
|
| Hi allI am doing some simple selects and outputting the results of these to text. I have an issue with formatting for some of my selects.My problem is that most of my selects keep nice formatting i.e look like:Column1 Column2 Column3--------- ---------- ----------Data1 Data2 Data3But one particular table contains a SQL statment as data and this seems to throw the formatting out i.e.Column 1 Column2 Column3------------- ------------------------- -----------Data1 SQL STATEMENTSQL STATEMENT CONTINUEDMORE SQL Data3Does anyone know of a way I can keep my data formatted as in example one above where it alines to the columns?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 08:48:11
|
| why should you be concerned about this? you can always format the results in the way you wanted at your front end. Or even choose results to grid option to view results in query analyser. |
 |
|
|
Kwisatz
Starting Member
14 Posts |
Posted - 2008-11-24 : 09:08:55
|
| I am using OSQL to call the SQL and output this to a csv file. So it looks terrible when the formatting is all over. |
|
|
|
|
|
|
Formatting Issue