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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-03-20 : 16:00:31
|
| Hello all. I am running 2 select statements and sending the results using xp_sendmail and I'm haveing a small problem.I would like to get rid of the 'extra' space that is added in between the 2 select statements. Can anyone help?thanks. |
|
|
Jay99
468 Posts |
Posted - 2002-03-20 : 16:14:15
|
| Can you post some code so we can see what space you are talking about?Jay<O> |
 |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2002-03-20 : 17:21:17
|
| These are the results of my 2 select statements. The first returns the three ship dates with revenue numbers and the second select statement returns the TOTAL. You'll notice that in between the two select statements I have what appears to be 3 carriage returns. Any way on getting rid of those extra line so that it looks like one continuos flow of data?ShipDate Freight Revenue ----------- -------------------- 03/19/2002 $462.70 03/18/2002 $555.49 03/17/2002 $13.49 ----------- -------------------- TOTAL $1,031.68 |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-20 : 18:54:32
|
| Your answer is over here: [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=14087[/url] where you cross-posted. That isn't necessary here at SQLTeam as most of us read all the forums.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
delete spaces and dashes in between 2 selects