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 |
|
nibbles70
Starting Member
2 Posts |
 Posted - 2014-02-02 : 15:14:29
|
| How can I easily select a derived column again in the same query?SelectCOL1,COL2,<complex_functions> as COL3,COL3 / COL2 as COL4from... |
|
|
nibbles70
Starting Member
2 Posts |
Posted - 2014-02-02 : 15:25:01
|
| Example :select 1 as A, 2 as B, 3 as C ,B * C as D;Msg 207, Level 16, State 1, Line 4Invalid column name 'B'.Msg 207, Level 16, State 1, Line 4Invalid column name 'C'. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-02-02 : 22:55:01
|
[code]select COL1, COL2, COL3, COL3 / COL2 as COL4from( select COL1, COL2, COL3 from . . .) as D[/code]
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-03 : 04:24:52
|
quote:
Originally posted by nibbles70
Example :select 1 as A, 2 as B, 3 as C ,B * C as D;Msg 207, Level 16, State 1, Line 4Invalid column name 'B'.Msg 207, Level 16, State 1, Line 4Invalid column name 'C'.
in this case you can directly do 2 * 3 AS Dhowever if its a really complicated expression you need to use derived table approach as shown by Tan------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2014-02-03 : 06:07:12
|
| Derived columns can be accessed using derived table although it can be directly access in ORDER BY clauseMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
selecting same column twice