Sergey,
Thank you, but rewrote the query as:
select @LoanAmount=(Select ((loanamount+loanfee)-amtdiscount) from tblloans where id=@LoanID)
I just wanted to place the result of the calculation into the @LoanAmount variable. This basically calculates the loan principal.
Regards,
-R!
>You didn't explain what you want to do. Anyway, see corrections in the code below that will allow to run that select.
>
>>OK, here is the code that is just making my head hurt today:
DECLARE @LoanAmount money
DECLARE @LoanID Int
SET @LoanId=267
select @LoanAmount=((loanamount+loanfee)-amtdiscount) from tblloans where id=@LoanID
>>
>>It keeps giving me the "A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations." error . . . Any alternative way to do this?
>>
Ricardo A. Parodi
eSolar, Inc.