This is how I tried to do it, but it didn't work.

I don't understand how to use Case?

Select ISNULL(MySurvey_Started, 0) As SurveyStarted, ISNULL(Start_User_Information, 0) As Step1, ISNULL(Start_Dependents, 0) As...

I will just use two stored procedures to get the results I need

Thank you anyway

-------|----------------|-----------|--------------|------------|

UserID |TransactionType |SaleAmount |PaymentAmount |PaymentType |

-------|----------------|-----------|--------------|------------|

209541 |Executive 3 year| 6200 | |...

It is all one table. I was just going to order them by TransactionDate because the sale will always appear first.

TransactionType determines if it is a sale or payment

I need to show each transaction and then the balance on the account. Something like a receipt.

I am going to use a datalist on my aspx page to show my...

Here are the columns:

UserID, TransactionType, SaleAmount, PaymentAmount, PaymentType

UserID TransactionType SaleAmount PaymentAmount PaymentType

209541 Executive 3 Year ...

This is with the UserID in the mix

UserID TransactionType ...

Thank you for replying but I am still not getting the right results.

the values in the SaleAmount and PaymentAmount are in different rows

ok, here is how I have changed the code but I am still getting error messages

<code>

select power((1 + (0.16 / dbo.User_CIS.Length_Installment),(dbo.User_CIS.Length_Installment*1))

</code>

I did end up doing the isnull in my stored procedure and it fixed the problem.

Frank

I am doing compounding. My procedure is similar to the way you do it.

Thanks for the input!

changing the 1 to 1.0 did the trick - thank you

Thank you so much Mark, Noel, and Rob! You have helped me solve my problem and helped me understand how it works.

Everything works great except for my dateadd, it adds one to the value entered in the text box. I need it to enter the value from the text box in...

Here is the code I am working on to see if I can get the loop to work. Based on the information I have read this should work, but ...