Use columns derived as computational result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Magnus - 27 Oct 2003 03:51 GMT

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

Reply to this Message

Karen Vaudreuil - 28 Oct 2003 01:08 GMT

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

Karen

> 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

Reply to this Message

Alick [MSFT] - 28 Oct 2003 07:44 GMT

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" <nospam@forme.com>
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
[quoted text clipped - 4 lines]
|
| - Magnus

Reply to this Message

Magnus - 29 Oct 2003 00:52 GMT

> Hi Magnus,
>
[quoted text clipped - 6 lines]
> 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

Reply to this Message