I have the following simple Select statement which produces an error when I
attempt to save it as part of a stored proc.
Select InvoiceID, dbo.Customer_CalculateAgedBalance (CustomerID) as
Where AgedBalance > MinimumBalance
Note: dbo.Customer_CalculateAgedBalance is a UDF.
It produces an error because 'AgedBalance' is an invalid column name. My
question is this. I would like to include the value contained in
'AgedBalance' in my Where clause without having to call the UDF a second
time. Is there anyway I can do this?