Column alias

Can we have more than one column alias for a sinle column in the select
list.
Something like this
SELECT field1 A,B FROM Table
What for do you need it ? (BTW, columns can only have one Alias)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Gopinath S" <gopinath_s@.nospamtrigent.com> schrieb im Newsbeitrag
news:OAzset5WFHA.580@.TK2MSFTNGP15.phx.gbl...
> Can we have more than one column alias for a sinle column in the select
> list.
> Something like this
> SELECT field1 A,B FROM Table
|||Jens Smeyer wrote:
> What for do you need it ? (BTW, columns can only have one Alias)
>
Same stored procedure is being used by two different reports which
shoud have different aliases.
Thankx
Done a work around
|||You can use like this....
select ContactName as Name, ContactName as SecondName from Customers
thanks
"Gopinath S" <gopinath_s@.nospamtrigent.com> wrote in message
news:#nqI175WFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Jens Smeyer wrote:
> Same stored procedure is being used by two different reports which
> shoud have different aliases.
> Thankx
> Done a work around
|||Hi,
No need to have different alias. You can very well use the same alias for
both the reports.
Thanks
Hari
SQL Server MVP
"Gopinath S" <gopinath_s@.nospamtrigent.com> wrote in message
news:%23nqI175WFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Jens Smeyer wrote:
> Same stored procedure is being used by two different reports which shoud
> have different aliases.
> Thankx
> Done a work around