AW: SQL Dynamic column naming

Hi,

Not sure if you want to show the formula or the result of the formula:

If you want to show the formula, just put double quotes around the column
names:

Select Todays_results as "curdate()",
       Yesterdays results as "(curdate() - 1 days)"

From   Sometable

To show the result of a formula as column heading is not possible.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Chris Payne
Gesendet: Thursday, March 29, 2007 20:14
An: midrange-l@xxxxxxxxxxxx
Betreff: SQL Dynamic column naming


Is it possible to name columns the result of a formula? For example
something like

 

Select

            Todays_results as curdate(),

            Yesterdays results as (curdate() - 1 days)

From

            Sometable

 

 

 

___________________________________
Christopher Payne
CPayne@xxxxxxxxxxxxxxx
Pricing Financial Analyst

 

The Crown Group
Corporate Offices
2111 Walter Reuther Drive
Warren, MI 48091-6199

 

Phone: (586) 575-9800
Direct: (586) 558-5317
Fax:  (586) 575-9856