I have a query that needs converting to a stored procedure...goes something
field1 + field 2 as field3,
field3 + 5 as field4,
field4 + 492 as field 5....etc.
There are about 6 actual fields, and a number of fields that are calculated
based on other fields that are also calculated (fields 4 and 5 above).
Access allows this, but I can't figure out how to convince SQL Server to do
the same thing.
The purpose is to pull a list of clients whose reports are "due", based on
the contract date that is in ...