Calculated field in a calculation.
From: Lind (anonymous_at_discussions.microsoft.com)
Date: 04/29/04
- Next message: CB: "Inserting a string with an Apostrophe"
- Previous message: Steve Kass: "Re: Multiple Server query"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 09:40:24 -0700
In Access if
FieldA = FieldB + FieldC
And
FieldC = FieldD - FieldE,
I can use the statement
FieldA = FieldB + FieldC
but in SQL Server, I need to use
FieldA = Field B + (FildD-FieldE)
This works fine with a simple query. However, the queries
I would like to move to SQL Server Stored Procs have SQL
statements that run between 3 and 4 pages with many
calculated fields consisting of several other calculated
fields. How are such things (large queries with very
convoluted calculations) normally handled in SQL Server?
- Next message: CB: "Inserting a string with an Apostrophe"
- Previous message: Steve Kass: "Re: Multiple Server query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|