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 |
|
khushi2005
Starting Member
2 Posts |
 Posted - 2008-07-29 : 11:56:19
|
| Is it possible to get Column Aliasis from a Select Query LikeSelect col1,col2 ,Col3 as (Select ColNew from Table2)From Table1If not how do I chnage the name of the Column in a TempTableThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-29 : 11:57:44
|
| didnt get what you're asking for. do you mean you're storing alias names in another table as value and want to retrive the name from it? |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-07-29 : 12:17:36
|
| The only way I know how to do that is with dynamic sql. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-30 : 04:00:25
|
quote:
Originally posted by khushi2005
Is it possible to get Column Aliasis from a Select Query LikeSelect col1,col2 ,Col3 as (Select ColNew from Table2)From Table1If not how do I chnage the name of the Column in a TempTableThanks
Why do you want to do this?MadhivananFailing to plan is Planning to fail |
|
|
|
VGuyz
Posting Yak Master
121 Posts |
Posted - 2008-07-30 : 04:03:30
|
| Cant get u.. |
|
|
|
|
|
|
Get Column aliasis from Select Query