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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-07 : 14:17:02
|
Dan writes "Access allows me to do the following:
SELECT FILE_NO,
DUTY_TOT AS x37_TOT,
TAX_NON_DEFERRED_TOT AS x38_TOT,
FEES_TOT + ADA_NON_BONDED_TOT + ADA_BONDED_TOT + CVD_NON_BONDED_TOT + CVD_BONDED_TOT AS x39_TOT,
x37_TOT+x38_TOT+x39_TOT AS x40_TOT, <----(total of the above 3)
DUTY_AMT_LIQUIDATED AS B_TOT,
TAX_AMT_LIQUIDATED AS C_TOT,
FEE_AMT_LIQUIDATED + ADA_AMT_LIQUIDATED + CVD_AMT_LIQUIDATED AS D_TOT,
B_TOT+C_TOT+D_TOT AS E_TOT <----(total of the above 3)
FROM SHPMNT
WHERE (SHPMNT.FILE_NO="0911135201");
Unfortunately SQLServer complains saying x38_TOT is an invalid name.
Is there a way to do this with SQLServer 7?
Thanks,
Dan" |
|
|
|
|
|
Calculations and Column Aliases