Use columns derived as computational result

[Magnus]

in msaccess i can refer to the name of the result column, max(id) as tmp,
here I can use "[tmp] * 10" f.ex. in another column, how can I do this in
mssql2k/msde2k ?

- Magnus

 

[Karen Vaudreuil]

You have to rewrite everything. In your example, that gives: max(id) * 10

Karen

 

[Alick [MSFT]]

Hi Magnus,

You will have to replace tmp as max(id) at the place referring to tmp as
Karen mentioned. ADP (SQL) doesn't support this ability so far, you may
submit a wish via the link below to further enhance our product's feature.

http://register.microsoft.com/mswish/suggestion.asp

Please feel free to reply to the threads if you have any concerns or
questions.



Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "Magnus" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
|
| in msaccess i can refer to the name of the result column, max(id) as tmp,
| here I can use "[tmp] * 10" f.ex. in another column, how can I do this in
| mssql2k/msde2k ?
|
| - Magnus
|
|
|

 

[Magnus]

Hi Magnus,

You will have to replace tmp as max(id) at the place referring to tmp as
Karen mentioned. ADP (SQL) doesn't support this ability so far, you may
submit a wish via the link below to further enhance our product's feature.

http://register.microsoft.com/mswish/suggestion.asp

Please feel free to reply to the threads if you have any concerns or
questions.

Thank you both for your responses, I always like to get a confirmation in
these questions.

- Magnus