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 - 2004-11-03 : 07:48:30
|
| Kourosh writes "Hello,I would like to categorize my output records based on parent fileds and bypass them for aother related rows except one,I know the BREAK command in oracle and I would like to know the equivalency in SQL Server.Example 1 aa 1 aaa 2 bbb 3 ccc 2 bb 1 xxx 2 yyy 3 zzzInstead of : 1 aa 1 aaa 1 aa 2 bbb 1 aa 3 ccc 2 bb 1 xxx 2 bb 2 yyy 2 bb 3 zzzI use only query analyzer and I would like to generate a text file based on this query through a dts package. Best Regards Kourosh" |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-11-03 : 10:21:46
|
| If you generate data as in your first example, then the data won't be importable into most systems. Since you are formattting it in a manner that looks "nice", I assume this means you are trying to write report using T-SQL and DTS, output as text files. Don't do this. Use a report writer, MS Access, Excel or some other tool designed to produce reports.- Jeff |
 |
|
|
|
|
|
Record Break in Sql Report