Forum Replies Created

Viewing 15 posts - 16 through 30 (of 43 total)

  • RE: date time

    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...

  • RE: SUM

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

    Thank you anyway

  • RE: SUM

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

    UserID |TransactionType |SaleAmount |PaymentAmount |PaymentType |

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

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

  • RE: SUM

    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

  • RE: SUM

    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...

  • RE: SUM

    Here are the columns:

    UserID, TransactionType, SaleAmount, PaymentAmount, PaymentType

    UserID TransactionType SaleAmount PaymentAmount PaymentType

    209541 Executive 3 Year ...

  • RE: SUM

    This is with the UserID in the mix

    UserID TransactionType ...

  • RE: SUM

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

    the values in the SaleAmount and PaymentAmount are in different rows

  • RE: having trouble with "^"

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

    <code>

    (dbo.User_CIS.Installment_Total_Fee *

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

    </code>

  • RE: DBNULL

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

  • RE: calculation

    Frank

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

    Thanks for the input!

  • RE: calculation

    changing the 1 to 1.0 did the trick - thank you

  • RE: tsql

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

  • RE: tsql

    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...

  • RE: tsql

    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 ...

Viewing 15 posts - 16 through 30 (of 43 total)