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 - 2001-05-06 : 14:42:51
|
Casey writes "I am working in a SQL 7.0 NT environment
I am running a series of select statement all within one query (if running SQL Analyzer) or all within one stored procedure.
In order to define what each result set represents, I use a select statement to output a literal that describes the following result set.
Because I am converting the fields being selected , I am specifying column aliases. I want to compute the totals for each of the select states.
Ex:
Select 'Count of Authors by Last Name'
Select count(*), left(au_lname,20) from authors
group by au_lname
order by au_lname
compute total sum(count(*))
(the actual query is more meaningful!)
When the query is run with the compute statement, the column headings are not returned.
Does anyone know why this would be and what the syntax would be?
Any help is greatly appreciated." |
|
|
|
|
|
missing column headings