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 |
|
gimmely
Starting Member
5 Posts |
 Posted - 2007-04-27 : 14:04:38
|
| I'd like to know if it's possible to use simple SQL query to accomplish the following:I have "Compute Sum(Field1), Sum(Field2), Sum(Field3)". But the output is like: Sum ====== Sum ====== Sum ======I want to have them lined up as: Sum Sum Sum ====== ====== ======Looks like a simple question. |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-04-28 : 01:38:16
|
| Lookup "WITH ROLLUP" in BOL instead of using Compute...--Jeff Moden |
 |
|
|
mattyblah
Starting Member
49 Posts |
Posted - 2007-04-30 : 12:04:37
|
| any chance in posting the queries you're running? |
|
|
|
gimmely
Starting Member
5 Posts |
Posted - 2007-05-02 : 10:50:52
|
| Matty - R U asking for my query or from Jeff? |
|
|
|
|
|
|
how to line up multiple SUM() in Compute clause?