Use columns derived as computational result

  • Thread starter Thread starter Magnus
  • Start date Start date
M

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
 
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
|
|
|
 
Alick said:
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.
Click to expand...

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

- Magnus
 
Back
Top